Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Automatic Backup

Author  Topic 

sunny_10
Yak Posting Veteran

72 Posts

Posted - 2013-02-21 : 07:13:12
Hi

I want to schedule Automatic Backup of Database . I am using SQL Express 2005.

Thanks

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-21 : 08:29:36
SQL Express 2005 does not have SQL Agent, so you will need to schedule the backup job using Windows Scheduler.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-02-23 : 02:22:57
Read up on the BACKUP DATABASE command - which give a number of options regarding the destination.
It could be worth adding some notification on the Scheduled job - for success\failure

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

AlexVlg
Starting Member

3 Posts

Posted - 2013-03-08 : 02:22:36
Try out SQLBackupAndFTP. It's an easy tool to schedule backup jobs. You can save your backups to local folder, FTP, Dropbox, Google Drive or Amazon S3. There is free version with basic features, also you can try full version in trial mode.
http://sqlbackupandftp.com/
Go to Top of Page
   

- Advertisement -