Search found 2 matches

by OrnSveinsson
Wed Mar 23, 2016 8:15 am
Forum: General Computer Forum
Topic: Operational db without an .ldf file and no useful backups on SQL Server 2005.
Replies: 3
Views: 4194

Re: Operational db without an .ldf file and no useful backups on SQL Server 2005.

You will have data loss but it can be done. 1) Detach database and move your mdf to save location. 2) Create new databse of same name, same files, same file location and same file size. 3) Stop SQL server. 4) Swap mdf file of just created DB to your save one. 5) Start SQL. DB will go suspect. 6) ALT...