Options

Deleting backup file?

BgfreemanBgfreeman Posts: 21
edited July 3, 2011 9:45PM in SQL Virtual Restore 2
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?
· Share on Twitter

Comments

  • Options
    javenjaven Posts: 50
    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
    · Share on Twitter
Sign In or Register to comment.