SQL recovery from database files
Posted on 2009-04-07
I have a backup system which captures data at the block level, essentially providing me with a snapshot of the server hard drive at a given point in time. This provides me with copies of the actual SQL databases and logs as they were at a pojnt in time. Since these are not database and transaction log 'backups', I am not able to use traditional 'restore' methods like RESTORE DATABASE. I figured out that I could shut down the SQL services ortake the database offline and replace the database and transaction log files on the server with the ones I had backed up. I'm wondering if there is any better way to do this type of recovery. The test I did was on a simple recovery test database, but I'm not sure how I would be able to roll back transaction logs or recover the metadata databases like master, model, msdb with what I have.