June 11, 2004 at 4:46 am
I have just set up a maintenance plan on a SQL 2000 box.
For my own piece of mind I have put in report that e-mails me the results of DBCC SQLPERF(LOGSPACE)
This seems to show that the % logspace isnt dropping.
Does the maintenance plan log backup truncate the transaction log if setup through the maintenance plan.
If not is there any extra switch that need to be added?
This is what I have at the moment.
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 220BBB64-0A2B-4AF2-9596-C13C638FCCDC -Rpt "F:\sqlserverbackups\DWH\PLANLOG\DWH Maintenance Plan6.txt" -DelTxtRpt 4MONTHS -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog "F:\sqlserverbackups\DWH\TRN" -DelBkUps 2DAYS -BkExt "TRN"'
Thanks for any help.
Simon
June 11, 2004 at 3:36 pm
Not sure, but I think maybe you need to run dbcc updateusage before running dbcc sqlperf(logspace).
Backing up the transaction log does a truncate as part of the backup, whether its initiated by a maintenance plan or otherwise. I suspect that the sqlperf is taking the information from sysindexes which may not be getting updated by the time you run it.
Steve
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply