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 |
|
paulferree
Starting Member
8 Posts |
 Posted - 2009-08-13 : 12:34:16
|
| Long story short.Our server running SQL 2000 crashed and we had to move all data to our new servers running SQL 2008. I want to attach the DB from 2000 into 2008. However I get an error message saying the LDF is corrupt.I've tried to piece together advice from similar postings but to no avail. What are the steps I need to take to restore this DB? (FYI, I had other DBs that I was able to transfer fine using this method. This is the only problem one.)Thank you,Paul |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
paulferree
Starting Member
8 Posts |
Posted - 2009-08-13 : 13:41:27
|
| Yeah I tried that and I get this error message:File activation failure. The physical file name "m:\data files\microsoft sql server\MSSQL\data\[db_name]_log.LDF" may be incorrect.The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure.Msg 1813, Level 16, State 2, Line 1Could not open new database '[db_name]'. CREATE DATABASE is aborted.'Thanks.Paul |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
paulferree
Starting Member
8 Posts |
Posted - 2009-08-13 : 15:23:32
|
| Unfortunately that does not exist. :-( |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
Transferring 2000 DB to 2008. Get corrupt LDF msg