| Author |
Topic |
|
denis_the_thief
Aged Yak Warrior
596 Posts |
 Posted - 2012-11-11 : 10:48:11
|
| 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 backupsCan the Database be restored to a point in time using our backup and our Log File? |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2012-11-12 : 10:28:52
|
| Try to perform a tail-log backup first. |
 |
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2012-11-12 : 10:49:21
|
quote:
Originally posted by Hommer
Try to perform a tail-log backup first.
Thanks. In this case we can't since the D Drive which has the Database File is dead. Anyways, this is only a hypothetical situation.I was just wondering if the Transaction Log file (rather than Log backup) would be of any use if you lose your Database. |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-11-13 : 14:40:15
|
| 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. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-11-13 : 15:07:09
|
| Yes, like Hommer and Jeff said, perform a Tail of the log backup.-Chad |
|
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2012-11-13 : 15:20:37
|
quote:
Originally posted by jeffw8713
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? |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-11-13 : 15:35:01
|
| http://sqlskills.com/BLOGS/PAUL/post/Disaster-recovery-101-backing-up-the-tail-of-the-log.aspx-Chad |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2012-11-17 : 10:14:36
|
quote:
Originally posted by tkizer
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.
How could the entire Database be in memory? I realize SQL Server keeps what it feels like in the cache. But everything running in memory? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Restore point in time from Log FILE