May be this article will give you more information.
http://www.techrepublic.com/forums/ques ... corrupted/
Search found 2 matches
- Wed Mar 23, 2016 8:22 am
- Forum: General Computer Forum
- Topic: Operational db without an .ldf file and no useful backups on SQL Server 2005.
- Replies: 3
- Views: 6836
- 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: 6836
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...