This is a very similar problem to one that was posted a few days ago by fedum called "cant access my sql db".
The SQL Server machine suffered a power failure in the middle of a table update. when I started up sqlserver I got
Error 3456: Could not redo log record (54502:5570:53), for transaction ID (0:62146506), on page ......
The db had been marked suspect. the transaction that caused the log to not recover was a single table update, I thought Id reset the suspect status and 'backup log with no recovery' to flush the log and then drop the table concerned. I couldnt do this and the db concerned is no longer visible from enterprise manager. I still have the mdf and ldf files.
I tried sp_attach_single_file_db to try and attach just the mdf file (I renamed the ldf file so it couldnt get accidently picked up), but i get the msg
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'BAM_DataBank'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'C:\MSSQL\MSSQL\data\BAM_DataBank_Log.LDF' may be incorrect.
I dont know what to do now.
Please help because I do not have a recent backup!!!!!
The SQL Server machine suffered a power failure in the middle of a table update. when I started up sqlserver I got
Error 3456: Could not redo log record (54502:5570:53), for transaction ID (0:62146506), on page ......
The db had been marked suspect. the transaction that caused the log to not recover was a single table update, I thought Id reset the suspect status and 'backup log with no recovery' to flush the log and then drop the table concerned. I couldnt do this and the db concerned is no longer visible from enterprise manager. I still have the mdf and ldf files.
I tried sp_attach_single_file_db to try and attach just the mdf file (I renamed the ldf file so it couldnt get accidently picked up), but i get the msg
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'BAM_DataBank'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'C:\MSSQL\MSSQL\data\BAM_DataBank_Log.LDF' may be incorrect.
I dont know what to do now.
Please help because I do not have a recent backup!!!!!
