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.
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. |
|
|
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\failureJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
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/ |
|
|
|
|
|