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-02-07 : 10:22:41
|
| Robert Hickey writes "Hi allHad a disk array problem on my production SQL 7 server which has had aproblem backing up ,,,have had to reinstall Nt And SQL 7 but still have access to the old filesystem namely the .mdf and .ldf files from the old database...however information has been inserted into the database in the last monththat hasn`t been backed up as there a problem with the back up so1, will the ldf and Mdf files will teh information be there??? If I usethese files to create new databases its ( have tryed it but the tables arethere but lost some information that has been inserted )2, is there ay way that I can get this information back like from thetransaction log files....Any help would be great Please help a very much screwd????Thanks in advanceRob" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-07 : 11:00:48
|
| Look in Books Online for sp_attach_db, read the entry. You *should* be able to use it, however if you did not use sp_detach_db before you reinstalled SQL 7.0, then it probably won't re-attach. You might also want to try sp_attach_single_file_db if sp_attach_db fails. |
 |
|
|
|
|
|
SQL7 problem