|
Home > Archive > MS SQL Server > October 2006 > Database Attach Help!!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Database Attach Help!!
|
|
| Paul Glickenhaus 2006-10-24, 6:30 pm |
| Due to space issues we had to detach one of our databases. It stopped
working because the drive ran out of space. We have moved the .mdf and the
..ldf to another drive with much more space. When I try to attach I get the
following?
Error 3624
74 transactions rolled forward in database
2006-09-22 12:07:49.53 spid53 SQL Server Assertion: File: <page.cpp>,
line=1920
Failed Assertion = 'IsValidSlot (sid)'.
2006-09-22 12:07:49.53 spid53 Error: 3624, Severity: 20, State: 1.
2006-09-22 12:07:49.53 spid53 Error: 3314, Severity: 21, State: 3
I believe that the transaction lof is corrupt. I there a way to clear the
transaction log and then re-attach?
Any other ideas allso welcome.
Thank you
Paul
| |
| Tibor Karaszi 2006-10-24, 6:30 pm |
| I am surprised that you have X transactions rolled forward if you detached the database... You could
try sp_single_file_attac
h and see if that work with only the mdf file. If not, I suggest you open a
case with MS support.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Paul Glickenhaus" < PaulGlickenhaus@disc
ussions.microsoft.com> wrote in message
news:A957BF1E-7448-4363-8A23- 6F8937C95CF9@microso
ft.com...
> Due to space issues we had to detach one of our databases. It stopped
> working because the drive ran out of space. We have moved the .mdf and the
> .ldf to another drive with much more space. When I try to attach I get the
> following?
>
> Error 3624
> 74 transactions rolled forward in database
>
> 2006-09-22 12:07:49.53 spid53 SQL Server Assertion: File: <page.cpp>,
> line=1920
> Failed Assertion = 'IsValidSlot (sid)'.
> 2006-09-22 12:07:49.53 spid53 Error: 3624, Severity: 20, State: 1.
> 2006-09-22 12:07:49.53 spid53 Error: 3314, Severity: 21, State: 3
>
>
> I believe that the transaction lof is corrupt. I there a way to clear the
> transaction log and then re-attach?
>
> Any other ideas allso welcome.
>
> Thank you
>
> Paul
>
>
|
|
|
|
|