Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

5 Answers 5

up vote 3 down vote accepted

I use expressmaint - works like a champ

share|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.

share|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)

share|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'
, SKIP, NOREWIND, NOUNLOAD,  STATS = 10"

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.

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

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

share|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. –  Martin Rennix May 20 '09 at 6:25

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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