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 - 2002-03-31 : 22:52:12
|
| pattanawadee writes "I have been in serious status now , My the old sqlserver cannot boot I only can copy all of winnt directory , InetPub and MSSQL from the old and I would like to create new one server instead of the old one ,How can I use the dat file which I copy from the old server to the new server? Could I just copy directory MSSQL from the old one to the new server? (I try to restore it but not work) I have many database and very important ,Please suggest me How to solve thsi problem, Best Regard,Pattanawadee" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-03-31 : 23:37:10
|
| Which version? dat file sounds like v6.5.If not try sp_attach_db.Otherwise try creating a database with the same structure, closing the server and replacing the dat file with the one saved.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Could I copy dat file from /MSSQL/DATA to new sqlserver