Here's a hypothetical situation: - our Log File is on E Drive - our Database File is on D Drive - We have a Backup from last night on G Drive - During the day our D Drive dies and we can't get the Database File Back - We have no Transaction Log backups
Can the Database be restored to a point in time using our backup and our Log File?
No - you cannot restore to a point in time without available transaction log backups. The best you can do is restore to the latest backup...
Now, if the database is in full recovery model - and you are able to perform a tail-log backup (database does not need to be available for this) then you could restore to a point in time.
I appreciate that. I am very surprised. I did not think I could do anything if the Database is not available. I am how curious how I could execute any command if the Database is not available. Maybe I worded the question poorly. Let us say all the Databases are unavailable (i.e. if all were on D Drive as well) or Master is unavailable. And lets say (I forgot to mention) the Database is in Recovery mode. Any idea or any link would be helpful.
Is it that I could restore my back up and then use my Log File (I have no Log backup) to then somehow do a Tail Backup?
Paul's wife, Kimberly, illustrated the database being available when the drive it's on isn't available. This was at PASS 2011. It's because it's running in memory. But try a checkpoint, and it'll finally fail.