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 |
immad
Posting Yak Master
230 Posts |
Posted - 2013-09-24 : 08:00:15
|
hello,i want to take a sql server 2005 database backup on task schedule every 1 hour is that possible.please help me out.thanks |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-09-24 : 08:25:49
|
Schedule a tasks scheduler job with the backup command. In the simplest form it would be something like this:BACKUP DATABASE [YourDbName] TO DISK = N'C:YourBackupFolder\YourBackupfilename' More details here: http://technet.microsoft.com/en-us/library/ms187510.aspxYou can also schedule it using SQL Server Agent, and most people seem to prefer doing the backups using SQL Agent. |
|
|
|
|
|