August 14, 2014 at 8:12 am
Just testing some storage software and trying to get a database attached in restoring mode
First the database is paused and snapshotted by the storage. I then run log backups all day.
locally the software works, it restores using VDI into restoring mode and allows me to play in the transaction log backups.
Remotely the software will not do the restore, I have an open call with the vendor which is frustratingly 'as per design' at the minute.
I am trying to find the syntax to attach the files from the snapshot in restoring mode OR use restore to attach storage snaphot files.
How is this done? or is it buried in VDI!
Thanks
August 15, 2014 at 5:57 am
It's vendor specific whether or not they actually support database restores as part of their snapshot mechanism. Some do, some don't. A test restore is the best mechanism to validate if their defined snapshot works or not. You're on the right track.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply