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 |
|
bechbd
Starting Member
7 Posts |
 Posted - 2004-02-10 : 09:57:54
|
| I have a SQL database maintence plan configured to do a full database backup every night and a transaction log backup every 4 hours. The plan is also configured to delete any files more than 1 day old. The problem that I am having is that sometimes the files will not be deleted for several days in a row. I examine the SQL server log file and I don't see anything that would indicate that there was a problem with any of the backups until I get an error stating that the backup drive is out of space. Any one have any ideas why this is occurring? |
|
|
MuadDBA
628 Posts |
Posted - 2004-02-10 : 11:00:27
|
| Are those files being backed up to tape? They could be in use by the backup software at the time you try to delete them and so get an access violation. |
 |
|
|
bechbd
Starting Member
7 Posts |
Posted - 2004-02-10 : 12:10:22
|
| They are being backed up to disk then moved to tape later. The strange thing is that this has happened 2 to 3 times over the past year. I have made no changes to the maintenece plan and once I delete the old backups it seems to work just fine for quite awhile after that. |
|
|
|
|
|
|
SQL Database Maintence Plan errors