How to check the backups is currently running and next scheduled?

[Former Member]

Hi All ,

can any one please tell me how check any db or log backup is currently running on ms sql server and when was next one is scheduled

how to check failed backup also ?

Please send me sql query to check above or any other method to find above solutions

Thanks

Reddy

[former_member189546]

Hello

Normally t/s db13 is used for backups

Check SAP transaction db13

141118 DB13 - Planning calendar for 46C, 620 and 640 releases.

166861 Analysis of DB13 problems

1297986 Backup and Restore strategy for MS SQL Server

regards,

John Feely

[Former Member]

Hi ,

form DB13 we can check it , but in my scenario nothing schedule in DB13 , they are taking backups by using 3rd party tools

so only option to check through the sql queries

so please provide me some sql quries to check backups

[Former Member]

Hi,

How can we know which 3rd party tool your are using? This is a SAP forum. Each tool has its own method to keep track about its schedule.

Best regards,

Orkun Gedik

[former_member204080]

Hi,

check this

http://archive.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=LastBackUpDate

http://www.cupfighter.net/index.php/2009/10/check-your-sql-backup-automatically/

http://www.noupe.com/how-tos/10-ways-to-automatically-manually-backup-mysql-database.html