May 20, 2008 at 7:52 pm
We run a script to check the blocking issues every morning. We find a LogBack up job for master db running everyday. But the Backup team doesn't see it on their systems. The backup team says, they are not running any backup job . But this backup job shows up in the process Info. So, we manually kill it everyday. It takes a lot of wait time. We can't find where it comes from ?
Below is the info from the Process Info Page
Process ID : 86
User: ABC\Admistrator
Database: Master
Status: Runnable
Open Transactions: 0
Command: Backup Log
Application: Symantec Backup Exec for Windows
Wait Time: 42600844
WaitType: NetworkIO
CPU : 0
Physical IO: 12
memory Used: 1
Login Time: 5/19/2008 10:04:53 PM
Host: XYZ
Network Library : LPC
Network Address: 0015C58947C3
Blocked by : 0
Blocking : 0
This is the info from the Process details
BACKUP LOG [abc_xyc] TO virtual_device = 'abc_xyz_00__bfbdb0fa_9b94_4392_8ce0_0719ad2a00c5_' WITH NO_TRUNCATE
Master DB Properties
Size: 71MB
Space Available : 17MB
No of users: 49
Data File location: c:\ProgramFiles\MicrosoftSQLserver\MSSQL\data\master.mdf
Automatically grow file (enabled) 10%
Transaction Log File: c:\ProgramFiles\MicrosoftSQLserver\MSSQL\data\mastlog.ldf
Automatically grow file (enabled) 10%
Reocovery Model (Master): Simple
Auto update stats, and Auto create stats enabled.
SQL server 2000.
Please let me know if any one knows what the problem was??
Thanks
Rahul
May 20, 2008 at 9:52 pm
You cannot backup the log for the master database. It is in SIMPLE recovery model which does not require a log backup to be done. This cannot be changed for the master database.
It looks like you are using Symantec Backup Exec to do SQL Server backups. Check the configuration of it. Or check the manual to see how Backup Exec tries to backup databases. Better yet, ditch it altogether and use SQL Server to do the backups to disk, then get Backup Exec to backup those flat files. Much simpler (assuming you have the disk space available).
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply