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 |
|
tdavis
Starting Member
2 Posts |
 Posted - 2006-04-13 : 18:50:18
|
I want to use sql enterprise manager to backup my database nightly. I also want each nightly backup to overwrite the previous nights backup, then I want to send the backup to a network share so I can send the backup file to tape.any ideas?  |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2006-04-13 : 18:51:42
|
| Why can't you create a SQL Job that makes use of the BACKUP command?=======================================If Tyranny and Oppression come to this land, it will be in the guise of fighting a foreign enemy. -James Madison, fourth US president (1751-1836) |
 |
|
|
tdavis
Starting Member
2 Posts |
Posted - 2006-04-13 : 19:29:35
|
| will that accomplish all the things listed in my previous post?if so how do I use this utility? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-04-13 : 19:34:42
|
check out the Database Maintenance Plan in Enterpise Manager
KH |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-13 : 22:33:07
|
| i prefer to use a user job for this instead of the maintenance wizardcreate a jobstep 1: backup databaseif backup file existing backup database with init optionelse backup database --to create the backup filegoto step 2 if successfulstep2:send your file to the network share, use xp_cmdshell to do thisthen schedule--------------------keeping it simple... |
|
|
|
|
|
|
backup