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 |
|
Weekend
Starting Member
20 Posts |
 Posted - 2007-08-02 : 01:22:29
|
| HiI use this command to backup database BACKUP DATABASE DB_Name to disk = 'E:\DB_Backups\FileName'I want to schedule this task to be run automatically.Please advise how?ThanksJ a w a d |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-08-02 : 02:00:10
|
| schedule with sql agent. or if you are using sql server express, put your command in a batch file, vbscript, powershell, etc. and schedule using windows task scheduler.before you ask me about how to use sql agent, look it up in Books online (BOL).-ec |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-08-02 : 03:42:14
|
| Or use the Maintenance Plan Wizard to set up the schedule - and a variety of other housekeeping tasks that you might like to consider.Kristen |
|
|
|
|
|
|
Backup Scheduling.