Red Gate forums :: View topic - Deleting backup file?
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

Deleting backup file?

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



Joined: 23 Apr 2010
Posts: 15
PostPosted: Fri Jul 01, 2011 1:52 pm    Post subject: Deleting backup file? Reply with quote
Previously, I have been scrupulous in keeping the backup (.SQB) files that I use to mount Virtual Restore databases.

I understood thatt he data was read out of this, and stub vlf, vmdf files used to make SQL Server recognise the database.

Today, however, I had a bunch of DBs to restore, and mistakenly deleted a backup file from a mounted VR database. Nothing untoward happened, and the DB continues to function as before.

I thought the Hyperbac engine kept the backup files locked?
Back to top
View user's profile Send private message
javen



Joined: 25 May 2010
Posts: 50
PostPosted: Mon Jul 04, 2011 2:45 am    Post subject: Reply with quote
The files are not locked as they are opened for reading only. Some of the data may still be cached in the SQL buffers which may be why the database continues to be available, however the backup files still need to be online for VR to work properly
_________________
Jeffrey Aven
Product Management - HyperBac Technologies
Red Gate Software
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