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 |
|
maxismclaren
Starting Member
5 Posts |
 Posted - 2002-08-22 : 10:22:43
|
| I have a Maintenence Plan running for my db, and it overwrites every day, but when I go into the Restore Database dialog, it lists backups to Feb-2002! I checked the backup folder and there is only one file there and it is the size of the running database. I tried to restart SQL service, and detach/reattach db. Is there some DBCC statement I can use? |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-08-22 : 11:58:37
|
| This is just the backup history . You can use sp_delete_backuphistory to keep this manageable.sp_delete_backuphistory [ @oldest_date = ] 'oldest_date' where oldest date is when you want to keep history up to. I tend to have a scheduled job that runs this once a week so I never have more than a month's worthdeclare @date datetimeset @date = getdate()-30exec msdb.dbo.sp_delete_backuphistory @dateHTHJasper Smith |
 |
|
|
|
|
|
Phantom backup files