I have a corrupt log file - can I rebuild it?

A. Yes you can, but any un-committed transactions will be lost. This command is unsupported and undocumented so should be used with caution. It works on SQL 6.5 - whether it works on 7.0 is unknown.

dbcc rebuildlog (@dbname, 1, 0)

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish