How the backup is runing successful..

Question

How the backup is runing successful..

forsqlserver

SSCoach

Points: 18902
More actions
August 6, 2010 at 7:09 am

#387518

If I am seeing a weekly backup job in script as it was created by maintenance plan then it is using msdb database as well as there is no backup command looking in this.
How the backup is runing successful..My database is some else
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

I am having difficulty understanding your question. But if you desire to know if a database is being backed up (not how it was performed) try the following code.

SELECT Database_Name,[Name] AS 'Backup file name',Backup_start_date,Backup_finish_date, is_damaged

FROM MSDB.Dbo.Backupset

If this is NOT what you need, please post your question again with some additional detail.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Please clarify your question. If you could describe in greater detail what it is you are seeking, we can help better.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Adiga One Orange Chip Points: 27284 More actions · Answer 3

If your question is how the backup job is successful without a BACKUP DATABASE command in it, here is the asnwer.

In SQL Server when a Maintenance is created as an SSIS package and stored in MSDB

Hence in the job the step refers to MSDB and calls this SSIS package.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

forsqlserver SSCoach Points: 18902 More actions · Answer 4

Thanks to all but Adiga has got my point and one thing is annoying where that backup command is...?

Thanks

Adiga One Orange Chip Points: 27284 More actions · Answer 5

Please navigate to Maintenance Plans and open the Maintenance Plan. Inside that you will have a BACKUP DATABASE task which takes care of the backups.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga