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 |
|
cmorga23
Starting Member
10 Posts |
 Posted - 2007-12-11 : 12:25:21
|
| Could you tell me how to make my backup files not overwrite each other? Right now I have a job setup to run a backup everyday at 12am, but when I arrive in the morning there is just one file in the folder. I want it to read like this (BUP_Master_12/11/07 12:00am, BUP_Master_12/12/2007 12:00am). I want to see a file for everyday. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cmorga23
Starting Member
10 Posts |
Posted - 2007-12-11 : 14:31:33
|
| Seems a little hard. Is there an easy way to complete this task. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-11 : 14:39:31
|
| You don't need to understand the code in order to run it. Check out the comment header for an example call to it so that you can try it out.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
cmorga23
Starting Member
10 Posts |
Posted - 2007-12-11 : 16:20:49
|
| Seems to work. Can you tell how I can automate this process now. How can I make this run for mutiple database's at different times? Sorry if this is a noob question. Just trying to learn. |
|
|
|
|
|
|
BACKUP HELP