Want to hire - quick job, sql express backup

[TenYardFight]

I can figure this out, but if you've already got experience doing this, let's do it together. It will probably go much faster.

I'm trying to create a scheduled task to backup a sql database in sql server express.

https://www.google.com/search?q=sch...me.0.57j0j62l3.12404&sourceid=chrome&ie=UTF-8

Give me an idea what you would charge. Thanks.

 

[Nerm]

Unless the backup software you are using supports VSS you will have to stop the sql service, run the backup, then restart the service. For clients that are too cheap to buy real backup software I usually accomplish this with a batch script and scheduled tasks. I also recommend a SQL backup software called SQLBackupAndFTP if you are not familiar with managing and backing up SQL databases.

 

[TenYardFight]

Thanks Nerm, will try it.

 

[YeOldeStonecat]

SQL Studio Express (baby version of SQL Enterprise Manager) allows the database to make "snapshots" of the database to a specified directory. And from there you can use standard backup software to copy those files....since they're not in use. So this is already a tool built into the manager.

I have not had experience setting up the scheduled backup....usually the software developer does this or has a hand holding guide to allow you to set that up.

I urge caution in using VSS software for databases, unless it has a special SQL (or other database) plugin. With VSS only...much of the data of a database engine is volatile in system memory...not yet written or updated to the database files. So getting a hot copy of live database files (such as if you relied on VSS) will result in an incomplete/inaccurate/possibly useless backup file. For doing hot backs of a database...should use backup software with a specific database engine plugin.

 

[nlinecomputers]

http://geekswithblogs.net/JaydPage/...up-of-a-sql-server-2008-express-database.aspx

Very easy to setup. You don't need to hire anyone to do this.

 

[TenYardFight]

I've had SQLBackupandFTP configured for a couple days now. It's emailing me every night telling me it backed up successfully, and our regular nightly backup is taking those files to two other places. Best of all, it's doing all that for free and took just a few minutes to setup. Thanks!