Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Reedar
Starting Member
6 Posts |
 Posted - 2008-01-17 : 17:18:28
|
| Hi All,Hopefully there is someone out there who can help. I have a problem with a Database which I need to fix by 7am tomorrow morning!!!Whilst creating some space on our server I accidentally moved an .ldf file out of the folder it belongs in (Stupid mistake to make I know!).Now the database is being marked as Suspect in Enterprise Manager.I have returned the .ldf file to the correct location as soon as I realised, but I haven't been able to access the db since.CAN SOMEONE PLEASE GUIDE ME THROUGH MAKING THE DB ACCESSIBLE AGAIN?!?!Many many thanks in advance.Reedar |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2008-01-18 : 02:00:30
|
| make sure the ldf file is in the right place, and restart SQL, it will then see the files again and it should be fine. |
 |
|
|
|
|
|
URGENT HELP WITH LDF FILE!