SQL job in msdb

Question

SQL job in msdb

tyang

SSCrazy

Points: 2231
More actions
September 6, 2006 at 9:10 am

#61816

I have scheduled sql backup to do full backup at 12:30am every day using maintenance plan, Tivoli back the database at 2:00am every day. But when I check the records on backset table on msdb, there is also a backup taken at 11:00pm, I double checked the schedule on both sql server and Tivoli, there is no job run at 11pm. Where can I find this schedule come from?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sreejith Sreedharan SSCertifiable Points: 5403 More actions · Answer 1

If your NT Admin has backupexec set up to backup SQL that will do the SQL backup as well. You've got to be carefull if you have Xaction log backup setup as well cos you don't want Xaction log backup to follow the backup taken by backup Exec. Cos if you need to do a point in time restore you would need the backup taken by BackupExec and the Xaction log backup.

Hope this helps

Sreejith

tyang SSCrazy Points: 2231 More actions · Answer 2

How could I find out if there is another job backing up sql dbs?

Scott Coleman One Orange Chip Points: 27452 More actions · Answer 3

If the backup log says there is a backup at 11PM that you want to find out about, one quick way would be to run sp_who2 at 11PM (or 11:01PM to be sure the phantom backup has started). Let this script run overnight and see the results the next day.

WAITFOR

TIME '23:01:00'

EXEC sp_who2