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-12 : 23:01:34
|
| shriram writes "my sql server crash i am install new server i have old .mdf file with me but am not able to restore it how can i get my data back" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-03-13 : 03:24:37
|
| look at sp_attach_dborsp_attach_single_file_db==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
aclarke
Posting Yak Master
133 Posts |
Posted - 2002-03-14 : 00:55:09
|
| A low-tech way to do it via Enterprise Manager is to create the database on the new server and then take that database offline. Then copy your .mdb file over top of the mdb file SQL Server just created. Then bring the database back online and hope for the best. I guess it would work even if you don't have the log file, which I've always had. |
|
|
|
|
|
|
database restore