Hi!
We have a problem with a database asignation. When we try to make an attach
(sp_attach_db) the system display an error:
Server: Msg 3624, Level 20, State 1, Line 1
Location: recovery.c: 2657
Expression: seenCkptEnd
SPID: 10
Process ID: 560
Connection Broken
We work with SQL Server 7.0 SP2
What can we do?
Thank you in advance.Did you detach the database first? Does it come from the same SQL Server ver
sion?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Israel" <i.rodriguez@.promis.net> wrote in message news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl
..
> Hi!
> We have a problem with a database asignation. When we try to make an attac
h
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>|||I do not think that at least half the groups you have included on your To:
line are relevant
It looks as though you may have a problem with the files which you are
trying to attach.
How did you shutdown the database for which these files originally were?
Was it cleanly?
What was your syntax?
The files were not in use by a database were they?
It may be that you need to contact the boys and girls in MS PSS and they may
be able to help you here.
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Israel" <i.rodriguez@.promis.net> wrote in message
news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an
> attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>
Friday, March 23, 2012
Problem with sp_attach_db
Labels:
asignation,
attach,
database,
display,
errorserver,
hiwe,
level,
microsoft,
msg,
mysql,
oracle,
server,
sp_attach_db,
sql,
system
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment