Rebuild log in SQL Server 2005 database

Question

Rebuild log in SQL Server 2005 database

river1

SSC-Insane

Points: 24309
More actions
February 11, 2010 at 2:55 am

#145129

Hi,
I have a database that is in emergency mode. i need to rebuild the LOG , in SQL Server i used DBCC rebuild_log. Is there any command in SQL Server 2005 to do this?
Thank you

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

rafael_si Ten Centuries Points: 1059 More actions · Answer 1

Hi,

This option was descontinued in the 2005 and incorporated into the DBCC CHECKDB with the REPAIR_ALLOW_DATA_LOSS option in the SQL 2005.

Please, see this article wrote by CHECKDB's father Paul S. Randal:

http://www.sqlskills.com/blogs/paul/2007/10/02/CHECKDBFromEveryAngleEMERGENCYModeRepairTheVeryVeryLastResort.aspx

Rafael Melo

Brazil

free_mascot One Orange Chip Points: 27169 More actions · Answer 2

see one more article:

http://www.sqlservercentral.com/Forums/Topic306817-146-1.aspx

HTH

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

First question: Why do you need to rebuild the transaction log? That's not something to do lightly.

Take a look at this: http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

river1 SSC-Insane Points: 24309 More actions · Answer 4

http://www.sqlskills.com/blogs/paul/2007/10/02/CHECKDBFromEveryAngleEMERGENCYModeRepairTheVeryVeryLastResort.aspx

Thank you very mutch.

My database problem is solved!