October 10, 2001 at 9:08 pm
I receive this error meassage when I try to reattach a database:
(Server: Msg 3456, Level 21, State 1, Line 1
Could not redo log record (373:27178:25), for transaction ID (0:345376), on page (1:1658), database 'pier1_mart' (5). Page: LSN = (373:27178:13), type = 2. Log: OpCode = 2, context 4, PrevPageLSN: (373:27178:17).
Connection Broken
What can I do?
Rob DeMotsis
Sr. SQL Server DBA
October 11, 2001 at 6:59 am
Remove the log file, let SQL create a new one - will happen automatically if you use EM in SQL2K, use sp_attach_single_db in SQL7.
Andy
October 11, 2001 at 8:46 am
When I try that, I get another error message
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'Pier1_Mart'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'e:\Pier1mart_db\pier1_mart_Log.LDF' may be incorrect.
I removed the log file from that folder entirely.
Any other suggestions?
Thanks.
Rob DeMotsis
Sr. SQL Server DBA
October 11, 2001 at 4:04 pm
You tried it using sp_attach_single_file_db also?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply