Options
Virtual Restores Source DB
stevenwatson
Posts: 4
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.
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.
Comments
The virtually restored database depends only upon the backup file and the virtual data and log files
Product Management - HyperBac Technologies
Red Gate Software
The Source DB I deleted was the backup file.
So the only files left on the disk was the virtual data and log files.