September 21, 2004 at 8:05 am
I am running SQL Server 2000 SP3 on Windows Server 2000. I have a nightly maint plan setup to backup the transaction logs which is set to remove the old logs after 3 days. I have verified that the job is setup correctly with the -DelBkUps 3DAYS parameter. SQL is installed to a drive letter other than system and I am using subdirectories per DB. I know that the job owner has permissions to delete files because the -DelTxtRpt 3DAYS option works and the NTFS permissions are assigned at the root folder and inherited down. Here is the complete job:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 2AB36EF2-39E1-42AF-9FF4-D44255CDE65A -Rpt "f:\Program Files\Microsoft SQL Server\MSSQL\LOG\New transaction log backup job6.txt" -DelTxtRpt 3DAYS -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog -UseDefDir -DelBkUps 3DAYS -CrBkSubDir -BkExt "TRN"'
Can anyone see why that would fail to remove older transaction logs?
September 21, 2004 at 9:54 am
Ok, found the answer to this one, guess I should have done a more thurough search. The answer is:
Like Jordanac said above, it will fail on all databases with the SIMPLE recovery model, it will also fail if there has been an unlogged event in any database, ie Bulk Loads, Table Truncations.
If you have selected "All databases" use the "Backup These Databases" option, for t-logs do not choose Master, msde or tempdb. If all else fails go down the list of databases in the log and check against the databases that should be getting backed up and make sure none on the list are "SIMPLE".
Clear as mud?
from:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=120549
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply