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 - 2001-05-20 : 23:03:44
|
Richard writes "Today we stopped SQL Server 7, copied the MDF file (a five-month, 245MB project) to the network, reformatted, and installed Windows 2000 SBS with SQL Server 2000 (an easy upgrade, we thought).
Lo and behold, both SQL Server 2000 (on the newly-formatted server) and SQL Server 7 (Desktop edition on my workstation) refuse to attach the MDF file, claiming they cannot find the accompanying LDF (no longer in existence). Using sp_attach_single_file_db did not help, nor did creating a database of the same name on the server, detaching it, and trying to swap the old MDF file for it.
Please help... if I have to get out a hex editor to get this database attached, I'm ready, but nothing I've tried works so far, and this is very important data--I can't believe the log file is THAT key to the database's operation, especially after committing anything left while shutting down the service.
Thanks in advance for any help you might be able to give. I'm in a real spot here." |
|
|
|
|
|
|
|
HELP... need to MDF only, but it was not detached