jagoodie
asked on
Deleted Master LDF, Need to Recover DB
Is there anyway to get my server back on-line after deleting the Master LDF?
ASKER
How do I exec this if the server is not online, as it isn't because it is down, and the master ldf is missing?
Your only option is the sp_attach_single_file_db command.
It is the only procedure that requires only the mdf file.
I have ran into the same problem and it worked. Give me more detail why you have rejected my answer.
EXEC sp_attach_single_file_db @dbname = 'pubs',
@physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf '
It is the only procedure that requires only the mdf file.
I have ran into the same problem and it worked. Give me more detail why you have rejected my answer.
EXEC sp_attach_single_file_db @dbname = 'pubs',
@physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf
You could try the rebuild master utility
Rebuildm.exe in the \Mssql7\Binn directory. This runs with the server shut down so has a good chance of working.
Rebuildm.exe in the \Mssql7\Binn directory. This runs with the server shut down so has a good chance of working.
ASKER
So, I tried that, and it said, "Failed to initilize application. Last error returned 1114."
Is there another way around this mess?
Is there another way around this mess?
You execute this in the Query Analyser
ASKER
Which cannot be done when the server is not online.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It should work Rebuildm.exe. It will copy the system databases from your installation CD (master, temp, etc). After that you should sp_attach_db for every user database.
The location for Rebuild Master utility is :
Program Files\Microsoft SQL Server\80\Tools\Binn
Hope it works.
The location for Rebuild Master utility is :
Program Files\Microsoft SQL Server\80\Tools\Binn
Hope it works.
ASKER
This ended up being the only thing that worked.
Thanks for all of your help!
=(
Thanks for all of your help!
=(
@physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf