 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / March 2008Daily backup problem
My SQL 2000 server's daily (full) backup started failing due to a lack of disk space. This daily backup has been running for quite a while so im surprised. The file system was full but it seems the old backup are not being deleted even though the maintenance plan is set to ""Remove files older than 1 day". Any ideas why this would happen? Solutions? Paul Old fulls, or old t-log backups? If t-log make sure every db in the plan is set to full recovery model. If you have databases in Simple recovery, make a separate plan for them without the t-log backup step  SignatureKevin3NF SQL Server dude You want fries with that? http://kevin3nf.blogspot.com/ I only check the newsgroups during work hours, M-F. Hit my blog and the contact links if necessary...I may be available. > My SQL 2000 server's daily (full) backup started failing due to a lack of > disk space. This daily backup has been running for quite a while so im [quoted text clipped - 4 lines] > > Paul Old fulls. I only do full backups. > Old fulls, or old t-log backups? If t-log make sure every db in the plan is > set to full recovery model. If you have databases in Simple recovery, make [quoted text clipped - 8 lines] > > > > Paul Paul, The delete happens after the backup is taken. If you do not have enough space for the backup it will not delete the old backup. Could this be your problem? Chris > Old fulls. > I only do full backups. [quoted text clipped - 15 lines] >> > >> > Paul No there is enough space for 3 days of backups > Paul, > [quoted text clipped - 23 lines] > >> > > >> > Paul Check to see if the account running the SQL Server Agent has permissions to delete those fulls. Look for the maintenance plan logs in the \LOG directory (same location as the ERRORLOG file(s) ) SignatureKevin3NF SQL Server dude You want fries with that? http://kevin3nf.blogspot.com/ I only check the newsgroups during work hours, M-F. Hit my blog and the contact links if necessary...I may be available. > Old fulls. > I only do full backups. [quoted text clipped - 15 lines] >> > >> > Paul The account has full admin permission so that not a problem. Like I said this has not been a problem for months. I don't see a log specifacally for maintenance logs. > Check to see if the account running the SQL Server Agent has permissions to > delete those fulls. Look for the maintenance plan logs in the \LOG [quoted text clipped - 19 lines] > >> > > >> > Paul The account have the permissions to delete these file. No problem there. I don't see a maintenance plan specific log file. Paul > Check to see if the account running the SQL Server Agent has permissions to > delete those fulls. Look for the maintenance plan logs in the \LOG [quoted text clipped - 19 lines] > >> > > >> > Paul Add a "text file" option in the Reporting tab of the Database maintenance GUI (SQL 2000) SignatureKevin3NF SQL Server dude You want fries with that? http://kevin3nf.blogspot.com/ I only check the newsgroups during work hours, M-F. Hit my blog and the contact links if necessary...I may be available. > The account have the permissions to delete these file. No problem there. I > don't see a maintenance plan specific log file. [quoted text clipped - 28 lines] >> >> > >> >> > Paul |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.