Deleting backup file?

SQL Virtual Restore: Rapidly mount live, fully functional databases direct from backups

Moderators: eddie davis, Colin Millerchip, fionag

Deleting backup file?

Postby Bgfreeman » Fri Jul 01, 2011 1:52 pm

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?
Bgfreeman
 
Posts: 15
Joined: Fri Apr 23, 2010 6:45 pm

Postby javen » Mon Jul 04, 2011 2:45 am

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
javen
 
Posts: 50
Joined: Tue May 25, 2010 12:10 am


Return to SQL Virtual Restore 2

Who is online

Users browsing this forum: No registered users and 0 guests