I wouldn't have much hope for your installation (with less than loading
I haven't seen any way to get the data back if you lost the LDF file (and if
SS doesn't auto-build the ldf for you).
Your case is a bit different since you lost master as well. So, you could
run REBUILDM.EXE (to get empty working system databases) and then
sp_attach_db (sp_attach_single_file_db) you databases.
But since you lost your ldf files, there's a big risk that SQL Server won't
accept the mdf files for each database. Make sure that you make a file-based
backup before you venture into this.
Tibor Karaszi, Cornerstone Sweden AB
MCDBA, MCSE, MCSD, MCT, SQL Server MVP
Please reply to the newsgroup only, not by email.
> In a stupid way i deleted my .LDF files from all my databases.
> Now sqlserver wont startup cause it does not find the mastlog.ldf
> How can i tweak my server to recreate the .LDF files?
> Please advice
> P.J. van Woerkom
> Siemens Nederland N.V.