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 |
|
tmcivery
Starting Member
46 Posts |
 Posted - 2008-05-13 : 10:41:57
|
| Hey all,I'm trying to set up a backup schedule in SQL 2005 that will keep 5 .bak files within the folder I specify. I can get it to keep one backup only even though I specify that it is to keep 5 days worth of backups. Each backup happens at 12:00 am. I think the problem I may be having is I don't know how to get the maintenance plan to name the file mmddyyyy.bak or whatever it may need to determine that the file is 5 days old. Currently I am specifying a name of gmsqlbackup.bak. Any idea's that may help me out? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-13 : 11:17:39
|
| Yes you can . choose -create backup file for every database -Folders-specify what you want. It will give you MM-DD-YY-HH-MM format. Take a history cleanup task and delete older than 5 days. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-14 : 23:01:51
|
| Should use maintenance cleanup task instead. |
|
|
|
|
|
|
Keeping 5 Days Worth of Backups