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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-04 : 08:45:47
|
| Allan writes "Hi. I hawe had a server brakedown (it was shot down correctly but newer got back running) and cannot get it running again. But i have the mdf/ndf and ldf files( from a navision db) copied from the down server to a new one running win2k server with sql2k.What do i need to do, to get the database attached and back online ?" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-04 : 09:06:56
|
| Try sp_attach_db.If that fails thenhttp://www.nigelrivett.net/RecoverCorruptDatabase.htmlBut you should restore from your backup.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Down server -> new server