My customer got a total hard drive failure.
After sending it to drive recovery specialist we were able to recover the LDF log file (MyDB_0.LDF).
But the MDF file was completely destroyed (MyDB.MDF).
They have a good full backup from a month ago.
I tried this technique (to create a Tail Log Backup) by Paul Randal (Case #2) as follows:
1) Installed SQL Server 2012 on a new PC
2) Created a new database of same name (MyDB) - with same MDF and LDF file names as original
3) Took the new database offline
4) deleted the MDF and LDF files of the new database
5) put "MyDB_0.LDF" in the place of the LDF file I just deleted
6) put the database back on-line
7) after hitting F5 to refresh databases - it shows "MyDB (Recovery Pending)"
8) tried to do Tail Log Backup with this command
BACKUP LOG [MyDB] TO DISK = N'C:\BACKUP\MyDB_TailLog.b
ak' WITH NO_TRUNCATE
And I get this error...
Msg 3447, Level 16, State 1, Line 3
Could not activate or scan all of the log files for database 'MyDB'.
The sad thing is I know we can get this data back using ApexSQL-Log.
I can see all the transactions since the last full backup in this program - so the log file is not damaged.
But my client doesn't want to pay the $2000 fee for this software.
There has to be a way to restore this data, without having to purchase a third party tool.