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