 |
|
|
|
Next: Access with SQL
|
| Author |
Message |
External
Since: Dec 10, 2003
Posts: 4
|
(Msg. 1) Posted: Wed Jan 21, 2004 3:25 pm
Post subject: Attaching Database Failed
Archived from groups: microsoft>public>sqlserver>connect (more info?)
|
|
|
Can someone please help me with this problem.
I Did a database backup from serverA and restore to
serverB using w2k. I detached the database from serverB,
and when try to attach to the restored database, I got an
error" Error 9003:The LSN(120998:148:1) passed to log
scan in database "xyz" is invalid.
How do I fix this error. Thanks. |
|
| Back to top |
|
 | |
External
Since: Dec 29, 2003
Posts: 31
|
(Msg. 2) Posted: Thu Jan 22, 2004 2:52 am
Post subject: Re: Attaching Database Failed [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi
That is a Severity 20 error. Errors messages with a severity level of 20 or
higher are considered fatal errors and terminate the client connection.
There is a KB article # 328354 (FIX: A RESTORE DATABASE WITH RECOVERY
Statement Can Fail with Error 9003 or Error 9004), but that was fixed in
SP3.
If you are running SP3, you either have a corrupt DB, or you have
encountered another problem. In the latter's case, call your local Microsoft
PSS.
I would bet that the DB is corrupt. Where did you try to attach the DB
again, server B?
Can you try to restore the backup from Server A again on Server B and then
run DBCC CHECKDB and DBCC CHECKALLOC to see if you have corruption and it
came across in the backup?
--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike.DeleteThis@NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
"Someone" wrote in message
> Can someone please help me with this problem.
> I Did a database backup from serverA and restore to
> serverB using w2k. I detached the database from serverB,
> and when try to attach to the restored database, I got an
> error" Error 9003:The LSN(120998:148:1) passed to log
> scan in database "xyz" is invalid.
> How do I fix this error. Thanks. |
|
| Back to top |
|
| |
External
Since: Dec 10, 2003
Posts: 4
|
(Msg. 3) Posted: Thu Jan 22, 2004 12:06 pm
Post subject: Re: Attaching Database Failed [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Thank you for your reply. I applied sp3 and reattach the
database and I got the same error again. I am doing a new
restore as I write this and I will try to attach again.
Thanks.
>-----Original Message-----
>Hi
>
>That is a Severity 20 error. Errors messages with a
severity level of 20 or
>higher are considered fatal errors and terminate the
client connection.
>
>There is a KB article # 328354 (FIX: A RESTORE DATABASE
WITH RECOVERY
>Statement Can Fail with Error 9003 or Error 9004), but
that was fixed in
>SP3.
>
>If you are running SP3, you either have a corrupt DB, or
you have
>encountered another problem. In the latter's case, call
your local Microsoft
>PSS.
>
>I would bet that the DB is corrupt. Where did you try to
attach the DB
>again, server B?
>Can you try to restore the backup from Server A again on
Server B and then
>run DBCC CHECKDB and DBCC CHECKALLOC to see if you have
corruption and it
>came across in the backup?
>
>
>--
>--------------------------------
>Mike Epprecht, Microsoft SQL Server MVP
>Epprecht Consulting (PTY) LTD
>Johannesburg, South Africa
>Mobile: +27-82-552-0268
>
>Specialist SQL Server Solutions and Consulting
>
message
>> Can someone please help me with this problem.
>> I Did a database backup from serverA and restore to
>> serverB using w2k. I detached the database from
serverB,
>> and when try to attach to the restored database, I got
an
>> error" Error 9003:The LSN(120998:148:1) passed to log
>> scan in database "xyz" is invalid.
>> How do I fix this error. Thanks.
>
>
>.
> >> Stay informed about: Attaching Database Failed |
|
| Back to top |
|
| |
External
Since: Dec 10, 2003
Posts: 4
|
(Msg. 4) Posted: Thu Jan 22, 2004 2:19 pm
Post subject: Re: Attaching Database Failed [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
I just finished the restore, and got the same error when
I tried to attach to the database again.
>-----Original Message-----
>Thank you for your reply. I applied sp3 and reattach the
>database and I got the same error again. I am doing a
new
>restore as I write this and I will try to attach again.
>Thanks.
>
>>-----Original Message-----
>>Hi
>>
>>That is a Severity 20 error. Errors messages with a
>severity level of 20 or
>>higher are considered fatal errors and terminate the
>client connection.
>>
>>There is a KB article # 328354 (FIX: A RESTORE
DATABASE
>WITH RECOVERY
>>Statement Can Fail with Error 9003 or Error 9004), but
>that was fixed in
>>SP3.
>>
>>If you are running SP3, you either have a corrupt DB,
or
>you have
>>encountered another problem. In the latter's case, call
>your local Microsoft
>>PSS.
>>
>>I would bet that the DB is corrupt. Where did you try
to
>attach the DB
>>again, server B?
>>Can you try to restore the backup from Server A again
on
>Server B and then
>>run DBCC CHECKDB and DBCC CHECKALLOC to see if you have
>corruption and it
>>came across in the backup?
>>
>>
>>--
>>--------------------------------
>>Mike Epprecht, Microsoft SQL Server MVP
>>Epprecht Consulting (PTY) LTD
>>Johannesburg, South Africa
>>Mobile: +27-82-552-0268
>>
>>Specialist SQL Server Solutions and Consulting
>>
in
>message
>>> Can someone please help me with this problem.
>>> I Did a database backup from serverA and restore to
>>> serverB using w2k. I detached the database from
>serverB,
>>> and when try to attach to the restored database, I
got
>an
>>> error" Error 9003:The LSN(120998:148:1) passed to log
>>> scan in database "xyz" is invalid.
>>> How do I fix this error. Thanks.
>>
>>
>>.
>>
>.
> >> Stay informed about: Attaching Database Failed |
|
| Back to top |
|
| |
External
Since: Jan 06, 2007
Posts: 1
|
(Msg. 5) Posted: Sat Jan 06, 2007 3:16 pm
Post subject: RE: Attaching Database Failed [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
