Red Gate forums :: View topic - Virtual Restores Source DB
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Virtual Restore 2
SQL Virtual Restore 2 forum

Virtual Restores Source DB

Search in SQL Virtual Restore 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
stevenwatson



Joined: 19 May 2011
Posts: 3
Location: Australia

PostPosted: Thu May 19, 2011 2:39 am    Post subject: Virtual Restores Source DB Reply with quote

I just ran a test, where I restored a virtual DB from a RedGate SQL backup (sqb).

The source DB was on a local disk, and the resore worked fine.

I then updated a table, and again all worked fine.

I then deleted the source DB, and the system let me do this, no problems.
I was a bit surprised this was allowed, as I thought the virtual DB depended on this file.

I was further suprissed when I ran a query on the virtual DB, on a table I had not changed with an update or insert, and the query returned the correct data.

Where did this data come from, as the source DB files are gone???
And the virtual files should not containe this data and it was not altered from the original backup.
Back to top
View user's profile Send private message
javen



Joined: 25 May 2010
Posts: 50

PostPosted: Mon May 23, 2011 5:24 am    Post subject: Reply with quote

Hi Steven,

The virtually restored database depends only upon the backup file and the virtual data and log files
_________________
Jeffrey Aven
Product Management - HyperBac Technologies
Red Gate Software
Back to top
View user's profile Send private message
stevenwatson



Joined: 19 May 2011
Posts: 3
Location: Australia

PostPosted: Wed May 25, 2011 12:08 am    Post subject: Reply with quote

Sorry for not being clear.

The Source DB I deleted was the backup file.
So the only files left on the disk was the virtual data and log files.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group