SQL Server Performance Forum – Threads Archive

Error 3624 : Transactions rolled forward

We are on SQL server 2000(SP3) on Windows 2000. Our disk drive on which Datafiles resides got full. In order to add additional disk space, we stopped and de-attached the database. After that we copied the datafiles to another location. After getting the additional disk space, we copied back the datafiles and tried to attach the database and we got the following error : Error 3624 : 8829 Transactions rolled forward in Database <xxx>
Location : filemgr:cpp:1890 In the error log, it shows that recovery happens uptil 99% and then it creates a memory dump file. Any idea was is wrong or how to get the database re-attached ? Any help in this area is highly appreciated thanks, Viral shah

http://support.microsoft.com/default.aspx/kb/811476/?
says
This problem occurs because the logins that are used for the database connections do not have permissions to all the databases in the transaction.

It could be possible that t-log is get corrupted ?! or database is in suspect mode please try to revert it status from suspect , for that please run : <a href=’http://support.microsoft.com/default.aspx?scid=kb;en-us;825197′ target=’_blank’ title=’http://support.microsoft.com/default.aspx?scid=kb;en-us;825197′<a target="_blank" href=http://support.microsoft.com/default.aspx?scid=kb;en-us;825197>http://support.microsoft.com/default.aspx?scid=kb;en-us;825197</a></a> <a href=’http://support.microsoft.com/default.aspx?scid=kb;en-us;318878′ target=’_blank’ title=’http://support.microsoft.com/default.aspx?scid=kb;en-us;318878′<a target="_blank" href=http://support.microsoft.com/default.aspx?scid=kb;en-us;318878>http://support.microsoft.com/default.aspx?scid=kb;en-us;318878</a></a> sp_resetstatus [ @DBName = ] ‘database’ where 0 is for success and 1 is for failour HTH [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Regards. hsGoswami [email protected]

]]>