Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup Set List Not Populating Expand / Collapse
Author
Message
Posted Thursday, August 1, 2013 11:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 2:48 AM
Points: 34, Visits: 102
I have posted this on Amazon's Developer Forum, but I have also seen this happen at other times.

I have a Windows 2008 server with SQL Server installed (image_1) on Amazon EC2. I create an image of that machine, then I launch the newly created AMI (image_2). When I go into (image_2)'s Management Studio to perform a database restore, I noticed that all of my backup result sets are not displaying, yet they are on disk.

What it does look like: NoBackupSets.jpg

What it should look like: ListedBackupSets.jpg

What I was hoping that would happen is I could fire up image_2, then using the Management Studio's GUI, restore a database from a point in time. This would speed up the process greatly over having to do it all individually by script.

My question is, when the backup set list is not populated, is there a way to populate it or do I have to run my restore manually from script?

Thank you in advance,
Jim


  Post Attachments 
ListedBackupSets.jpg (2 views, 82.75 KB)
NoBackupSets.jpg (2 views, 58.52 KB)
Post #1480045
Posted Saturday, August 3, 2013 12:59 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 29, 2014 5:21 AM
Points: 197, Visits: 730
James Mace (8/1/2013)My question is, when the backup set list is not populated, is there a way to populate it or do I have to run my restore manually from script?

Thank you in advance,
Jim


Hello Jim,
if not populated, yes, you have to restore manually.

The backup history is stored in msdb database, not in the backup files itself. This means, when creating your image, get sure you include the msdb-database.

If you don't want to overwrite the msd-database on the target server you can read out the backup history from the msdb database to get all the information you need for restoring your database.
Have a look at the system tables of the msdb database. Find details of it here.
Post #1480717
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse