How can i restore my data after Nt server crash?

[Norov]

NT server 4.0 crahsed. And there was no emergency repair disk. So, I copied all MS SQL server7.0 data files. After that i created new partition, formatted and installed Nt Server and SQL server 7.0. But how can i restore my old data? Please tell me what to do now?

[Markus]

As long as you still have the datafiles it's easy. Just copy the files to the location there you want them. Then use sp_attachdb 'dbname','filename' to add the databases to your server.
In case you don't have the original files but only a backup you need to create an empty database and them restore from the backup.


------------
Norov at 1/22/01 7:42:07 PM

NT server 4.0 crahsed. And there was no emergency repair disk. So, I copied all MS SQL server7.0 data files. After that i created new partition, formatted and installed Nt Server and SQL server 7.0. But how can i restore my old data? Please tell me what to do now?