HELP! Error atttaching DB

Hi!
When I try Attach a DB I have this error:
Error: 3624
Location: recovery.c:2440
Expression: seenCKptEnd
SPID: 51
Process ID: 1344
Any idea ?
Are you sure that the transaction log file you are specifying to sp_attach_db is the correct one? If you're not dealing with mismatched files, I would recommend contacting Microsoft PSS for help in recovering your database, as this is usually indicative of some sort of log integrity problem.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine.
"Joao Pinto" <joao.pi@.mail.telepac.pt> wrote in message news:3rrpb0dij3ge90ob16vrkbb8dusi0iqh0b@.4ax.com...
Hi!
When I try Attach a DB I have this error:
Error: 3624
Location: recovery.c:2440
Expression: seenCKptEnd
SPID: 51
Process ID: 1344
Any idea ?
|||Hi,
Are you trying to attach the SQL 2000 MDF and LDF file to SQL 7. If yes, you will not be able to attach a SQL 2000 database to SQL 7 due to
architectural changes. Only solution is to use DTS tools to transfer objects and data.
Incase you are trying to attach the MDF and LDF of SQL 2000 to the same version, then the issue might because of problem with the logfile
as well as if the database was in an inconsistent state. If the MDF and LDF file is from a suspect database, it is very difficult to attach.
If you have a backup, better option is to try restoring the backup rather than using sp_attach_db.
Thanks
Hari
MCDBA
"Ryan Stonecipher [MSFT]" <ryanston@.online.microsoft.com> wrote in message news:eIlBrSCSEHA.3628@.TK2MSFTNGP12.phx.gbl...
Are you sure that the transaction log file you are specifying to sp_attach_db is the correct one? If you're not dealing with mismatched files, I would recommend contacting Microsoft PSS for help in recovering your database, as this is usually indicative of some sort of log integrity problem.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine.
"Joao Pinto" <joao.pi@.mail.telepac.pt> wrote in message news:3rrpb0dij3ge90ob16vrkbb8dusi0iqh0b@.4ax.com...
Hi!
When I try Attach a DB I have this error:
Error: 3624
Location: recovery.c:2440
Expression: seenCKptEnd
SPID: 51
Process ID: 1344
Any idea ?
|||Here is a way to get the database attached, if it is a SQL Server 2000
database.
1. Create a new database with the same name and make sure the file names
for the MDF and LDF are identical to the ones you want to attach.
2. After you create the database. Stop SQL Server.
3. Copy the original MDF and LDF files over the newly created ones.
4. Restart SQL server.
The database will probably sill come up suspect but you can then put it in
emergency mode and possibly get the data out.
Rand
This posting is provided "as is" with no warranties and confers no rights.