Is there a way to schedule a job on Windows Server 2003 [small business edition] that will create a backup of a SQL 2005 Express DB?

I'm not sure if there is a native job/process for this on SQL Express or not. If there is not, how would I go about creating one?


I use expressmaint - works like a champ

| improve this answer | |
  • 1
    I would vote you up on this, that looks great. Just don't have the rep to do so yet... – RSolberg May 19 '09 at 22:46
  • We wrote an application to assist in backups for our customers using sql 2005 express, but expressmaint looks like it does basically the same things. Or you can just do the stored procedure calls built into MSSQL – Jack B Nimble May 19 '09 at 22:47

I believe Quest Software's freeware version of Toad has the ability to manage SQL jobs on SQL Server express.

Another option would be to script out the task using sqlcmd and schedule it using the Windows task manager.

| improve this answer | |

I was using expressmaint for a while then when I upgraded to SQL Express 2008 I had to switch to SalBackupAndFTP. It lets you schedule backups, etc, and supports SQL Express 2005/08, oh and its free. (BTW the ftp part is optional, it also lets you save to disk)

| improve this answer | |

To elaborate on the second part of boxelephant's answer, here's a sample script you could save as a bat file and run via Windows scheduler.

sqlcmd -E -S .\sqlexpress -Q "BACKUP DATABASE [MyDatabaseName] TO  DISK = N'c:\Backups\MyDatabaseName.bak' 
WITH NOFORMAT, NOINIT,  NAME = N'My Database-Full Database Backup'

This just logs into the local sqlexpress instance using a trusted connection and creates a full backup of MyDatabaseName and saves it to disk. You'd probably want to tweak the script to incorporate some sort of date/time stamp in the bak file name so you don't overwrite the previous backup.

The sqlcmd syntax can be found here: http://msdn.microsoft.com/en-us/library/ms162773.aspx

I've never used either of the third-party solutions mentioned, but if one meets your needs, it's likely easier to use one of them than rolling your own from scratch. OTOH, this is still pretty easy if all you need is a super lightweight backup plan.

| improve this answer | |
  • This is exactly what I do. Works well enough. – PowerApp101 May 20 '09 at 6:26

Microsoft SQL Server Management Studio Express allows for backups, among all the other things it can do.

| improve this answer | |
  • I don't think you can have that run as a scheduled job/task on the express versions. For the regular version of SQL I believe Management Studio would be a heck of a start. – RSolberg May 19 '09 at 22:51
  • Yep, you can do a one-off backup but you can't schedule. – PowerApp101 May 20 '09 at 6:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.