April 15, 2009 at 8:38 pm
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
Have a look at [msdb].[dbo].[backupset] - it has a record for each backup
April 15, 2009 at 9:41 pm
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
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?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply