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 |
|
csharpula
Starting Member
2 Posts |
 Posted - 2005-03-29 : 12:15:01
|
| Hello,I have a backup job which writes the db content to a bak file each time the backup job is running,the problem is that it is writing to the same file and I want a new bak file to be created each time the job is activated.How can I do this?Thanks a lot! |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-29 : 14:47:36
|
| http://weblogs.sqlteam.com/tarad/archive/2004/08/04/1876.aspxMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2005-03-30 : 05:06:42
|
| Create a DB Maintenence job which takes care of your requirement.Hemanth GorijalaExchange a Dollar, we still have ONE each._______Exchange an Idea, we both have TWO each. |
|
|
|
|
|
|
backup job