SQL Server Database Backup Status

• Robert Davis

  One Orange Chip

  Points: 28027

  More actions

  January 26, 2010 at 2:33 pm

  #1108960

  Worked perfectly on sQL 2008 for me.

  ---

  My blog: SQL Soldier[/url]
  SQL Server Best Practices: SQL Server Best Practices
  Twitter: @SQLSoldier
  My book: Pro SQL Server 2008 Mirroring[/url]
  Microsoft Certified Master: SQL Server, Data Platform MVP
  Database Engineer at BlueMountain Capital Management[/url]

• Pratap Prabhu

  Say Hey Kid

  Points: 711

  More actions

  January 26, 2010 at 2:42 pm

  #1108966

  Thanks a lot.

• Jigar Lakhani

  SSC Enthusiast

  Points: 156

  More actions

  March 9, 2010 at 3:32 pm

  #1131026

  doesnt work for me guys. Ran this in 2008 and get the following error

  Msg 1087, Level 15, State 2, Line 32

  Must declare the table variable "@Tbl".

• Robert Davis

  One Orange Chip

  Points: 28027

  More actions

  March 9, 2010 at 4:46 pm

  #1131061

  You need to run the whole thing and not just the snippet posted above.

  ---

  My blog: SQL Soldier[/url]
  SQL Server Best Practices: SQL Server Best Practices
  Twitter: @SQLSoldier
  My book: Pro SQL Server 2008 Mirroring[/url]
  Microsoft Certified Master: SQL Server, Data Platform MVP
  Database Engineer at BlueMountain Capital Management[/url]

• haider.biswas

  Grasshopper

  Points: 17

  More actions

  January 18, 2012 at 12:41 pm

  #1435449

  I am trying to use this scripts on SQL Server 2008 R2 box but not working.

  Do I need to change any part of the scripts.

  Please advise.

  Thank you,

  Haider