November 8, 2004 at 4:13 am
Hi Friends
I am using SQL2K with Service pack 3A. I am trying to attach a database named Acme with the statement as follows:
EXEC sp_attach_db @dbname = "Acme",@filename1 = N"D:\Acme.mdf",@filename2 = N"D:\Acme_Log.ldf"
It shows following error:
Server: Msg 3624, Level 20, State 1, Line 1
Location: recovery.c:2440
Expression: seenCkptEnd
SPID: 81
Process ID: 1180
Connection Broken
Is there anyone who can guide me?
Thanks, Amit
November 8, 2004 at 6:21 am
Have you tried attaching the database through EM?
Good Hunting!
AJ Ahrens
webmaster@kritter.net
November 8, 2004 at 9:44 am
Can you create a new db, detach it, and then attach it back right away? Almost seems like something's wrong with your install. Are the mdf/ldf from the same version of sqL?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
November 10, 2004 at 4:21 am
Hi,
Creating a new DB, detaching & attaching is working fine. Both, MDF & LDF files are from SQL2K. Still having a problem with the previous error message. Remember, this is caused of improper server shut-down.
Kindly suggest on this.
November 11, 2004 at 1:00 pm
I've been facinated by your question ( I've never met this problem but like to know the answer anyway) so I start diging;
http://support.microsoft.com/kb/837938
It also indicates a corrupted clustered index using the standard edition while adding new columns on a table.
Hope this helps you out.
GKramer
THe Netherlands
November 14, 2004 at 10:03 pm
Hi
Tried to do the same but still having the same problem. I request to SQL DBAs to guide me.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply