September 10, 2009 at 9:04 am
Hi, we tried to restore a database and it failed with this error
This operation failed with errors.
Restoring RP02P (database) from:
H:\MSSQL\backup\rp01p\rp01p_db_200909090500.sqb
SQL Server error
SQL error 9003: SQL error 9003: The LSN (22256:19787:1) passed to log scan in database 'RP02P' is invalid.
Processed 7591128 pages for database 'RP02P', file 'rp01p_primary01' on file 1.
Processed 1003 pages for database 'RP02P', file 'rp01p_log02' on file 1.
SQL Backup exit code: 1100
SQL error code: 9003
Updating SQL Server information - Pending
-----------------------------------------
Operation pending.
Now I need to drop this database as soon as possible because of the space issue. I tried to delete it from UI but the process hang and never finished untill I killed it. Any advice welcome,
LL
September 10, 2009 at 9:42 am
llokshin (9/10/2009)
Hi, we tried to restore a database and it failed with this errorThis operation failed with errors.
Restoring RP02P (database) from:
H:\MSSQL\backup\rp01p\rp01p_db_200909090500.sqb
SQL Server error
SQL error 9003: SQL error 9003: The LSN (22256:19787:1) passed to log scan in database 'RP02P' is invalid.
Processed 7591128 pages for database 'RP02P', file 'rp01p_primary01' on file 1.
Processed 1003 pages for database 'RP02P', file 'rp01p_log02' on file 1.
SQL Backup exit code: 1100
SQL error code: 9003
Updating SQL Server information - Pending
-----------------------------------------
Operation pending.
Now I need to drop this database as soon as possible because of the space issue. I tried to delete it from UI but the process hang and never finished untill I killed it. Any advice welcome,
LL
hmm, what status is the database now, when you killed the process, is the database showing as ok, or as restoring or suspect?.
if you need to drop the database due to space issue, issue the drop command in t-sql. and see what it comes back with. there are other solutions you can try, this similiar related link might help
http://www.ureader.com/message/943908.aspx
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 10, 2009 at 9:54 am
Hi Silverfox, thank you for the reply. The EM says loading\Suspect There is more to this. This process also generated exception access violation
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 9/10/2009
Time: 9:16:20 AM
User: N/A
Computer: XXXXX
Description:
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 231 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. I am not sure I can try to drop it again.
September 25, 2009 at 12:25 pm
September 25, 2009 at 12:45 pm
Hi, thank you for the reply. The problem was solved like this. We did another restore with replace from a different backup for this db. It finished with no problem and we were able to drop this database. LL
September 25, 2009 at 12:54 pm
Thanks for sharing the solution.
Manu
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply