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 |
|
amex45
Starting Member
16 Posts |
 Posted - 2002-09-13 : 10:18:57
|
| Is any body aware of the following error Error 3456. I am trying to attach the 2 data files and one log file which is taken from a suspected database after reset. Here is the error meessage for your refServer: Msg 3456, Level 21, State 1, Line 1Could not redo log record (7417:9321:23), for transaction ID (0:19810758), on page (1:10572), database 'FDYPIPELINEPROD' (34). Page: LSN = (7417:9321:8), type = 2. Log: OpCode = 2, context 4, PrevPageLSN: (7417:9321:17).Connection BrokenAny input is greatly appreciatedRegards |
|
|
solart
Posting Yak Master
148 Posts |
Posted - 2002-09-13 : 11:02:17
|
| A shot in the dark.BOL says that a detach must be performed before you can perform an attach."I am trying to attach the 2 data files and one log file which is taken from a suspected database after reset."This sounds like maybe the detach was not successfully performed or not done at all.You still might try the attach without the log file (let the log file get generated). Assuming this succeeds, your data may be in a transactionally inconsistent state and/or you may be missing data in your database.Maybe you could provide more details on your situtation.solart |
 |
|
|
|
|
|
Error 3456