Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sitka
Aged Yak Warrior
571 Posts |
 Posted - 2010-12-29 : 11:18:58
|
| I want to use Camtasia to make a movie of a restore database operation with the GUI. The problem is the SSMS GUI is not smart enough to exclude the virtual backups that take place with a Host Level native imaging involved with Windows Server Backup.Database backed up. Database: abpm, creation date(time): 2010/04/13(16:11:15), pages dumped: 233, first LSN: 59:62:37, last LSN: 59:78:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{04C3921A-EC56-474B-97B0-E60A683CA8DC}5'}). This is an informational message only. No user action is required.Above is a typical log entry. So what a user would have to do is manually build the list of files "from device" to use the restore database interface. This has got to be the most painful GUI experience left in this world. Has anyone any experience that would eliminate these Backups of type=virtual device from the SSMS interface. It has been suggested that disableing the guest level SQL Server VSS Writer service would prevent these backups from occurring. but it is my understanding that the SQL Server VSS Writer service is what enables the Host Server the ability to write the Guests SQL files in a consistent state using VDI.More on the SQL writer service here. http://technet.microsoft.com/en-us/library/ms175536.aspx"it's definitely useless and maybe harmful". |
|
|
|
|
|
SSMS database restore GUI.