Post reply

Viewing Backup Information?

  • April 15, 2009 at 8:38 pm

    #199461

    Ok, I know this is a very basic question....but its driving me crazy!! I am familiar with S2K, but not S2K5!!

    All I want to do is view the backup information within the MSDB database... Simple task I know, and I thought my Google skills were very good....but not this time....my search brings back way too many links.

    I tried to view the tables via EM, but it doesn't seem to work....

    Thank you!!

  • April 15, 2009 at 9:35 pm

    #978578

    Have a look at [msdb].[dbo].[backupset] - it has a record for each backup

  • April 15, 2009 at 9:41 pm

    #978581

    I was actually trying to open the tables through Management Studio....and I know where I was going wrong..

    I was trying to "right-click" and "edit" on the table, when I should have been doing "right-click", "script table as" and "select to"

    Thanks for your help!

  • April 16, 2009 at 8:20 am

    #978889

    db2l (4/15/2009)

    I was actually trying to open the tables through Management Studio....and I know where I was going wrong..

    I was trying to "right-click" and "edit" on the table, when I should have been doing "right-click", "script table as" and "select to"

    Thanks for your help!

    I am sorry, i didn't get you.. you got the answer?

    Thanks -- Vijaya Kadiyala
    www.dotnetvj.com
    SQL Server Articles For Beginers


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

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