February 25, 2008 at 7:22 am
I have set up a backup maintenance plan in SS2005 that runs every night at midnight. The maintenance plan wizard automatically generates the BAK file name with something like [database]_yyyymmdd0000.bak. But sometimes, it will generate with a 0001.bak instead.
Can you help me understand why the ending number is sometimes 0000 and 0001 other times?
Thanks in advance for your hepl.
February 25, 2008 at 4:04 pm
The last 4 digits are the system time at time of backup commencement. In this case, 0000 represents midnight.
This is set when the backup file is created, when the backup job starts running. There may be something running on the server around the same time that creates some lag, causing the file to be created at one minute past midnight instead of bang on midnight.
Check your scheduled jobs and also find out what other processes are hitting the server around that time (e.g. a reporting server generating reports). Failing that, run a trace or SQL Profiler to capture what is happening around that time (give or take an hour or so - could be a long-running process).
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
February 26, 2008 at 6:38 am
Thanks for the information, Scott. Looking back, that is way too intuitively obvious. For some reason, I recalled it being some sort of incremental counter.
Thank you again.
Regards,
gary
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply