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_d
b 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:3rrpb0dij3ge90o
b16vrkbb8dusi0iqh0b@.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 object
s and data.
Incase you are trying to attach the MDF and LDF of SQL 2000 to the same vers
ion, 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 th
an using sp_attach_db.
Thanks
Hari
MCDBA
"Ryan Stonecipher [MSFT]" <ryanston@.online.microsoft.com> wrote in messa
ge news:eIlBrSCSEHA.3628@.TK2MSFTNGP12.phx.gbl...
Are you sure that the transaction log file you are specifying to sp_attach_d
b 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:3rrpb0dij3ge90o
b16vrkbb8dusi0iqh0b@.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.