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 |
|
mistys
Starting Member
3 Posts |
 Posted - 2006-01-12 : 14:18:43
|
| I recently had a server crash--the kernel corrupted. I was able to recover all of the files on the harddrive in their actual states.I installed SQL 7.0 on another machine, and NEED to get the databases from the previous machine loaded into the new one. I have the entire directory file from the old machine--- C:/MSSQL7/*.* --- including the data file, which seems to contain the databases I'm missing.I've tried just coping over the data files, replacing the data files, replacing the entire directory under MSSQL7, etc.Does anyone know how I can access those databases from the previous machine having the actual files from it? Thanks in advance for whatever help can be provided.ES |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-12 : 14:21:40
|
| Does SQL Server 7.0 have the ability to attach files? I can't remember. If so, you can run sp_attach_db or sp_attach_single_file_db to attach the database. If 7.0 doesn't have this ability, then you'll need to restore from your backups. You could also install 2000, which I know has attach, and keep your database compatibility mode at 70 to reduce the testing effort needed.Also, attaching might not even work though as I'm sure that the MSSQLSERVER service wasn't stopped when the crash happened, which could mean your MDFs are hosed.You might need to contact MS.Tara Kizeraka tduggan |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-01-12 : 21:10:49
|
| just a thought...the files you are 'missing' may not even be in the default drive. check the other drivesHTH--------------------keeping it simple... |
|
|
|
mistys
Starting Member
3 Posts |
Posted - 2006-01-13 : 00:23:38
|
| Any idea where other files might be? it doesn't seem to even want to start the sql server up when i just copy the files.... and i don't have any backups.thanks.es |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-01-13 : 10:13:34
|
| What is in the SQL Server error log (C:\MSSQL7\Log\errorlog)? This is where SQL Server shouild tell you why it can not start up. |
|
|
|
mistys
Starting Member
3 Posts |
Posted - 2006-01-13 : 11:41:00
|
| Nothing in the error log.I know pretty much nothing about SQL. I have the MDF & LDF files for the databases I need to work, and that's it. Somehow, I need to get those databases to be accessible. |
|
|
|
|
|
|
|
|
Moving Databases between servers with data files