Post reply

Is there is any DBCC Command to do Health Check of Log files?

  • January 23, 2005 at 12:22 am

    #109166

    Hi,

     we all know that  all the health check commands like DBCC CheckDB,DBCC CheckAlloc etc are used to check the database objects which are located in the datafiles.

     

    Is there is any DBCC Command to do Health Check of Log files? also is there is any command to fix the errors in the log files.

    coz we have encountered an error with log file while restoring the database

    "An error occurred while processing the log for database 'maumtri'.."

     

    Thanks in advance

     

     

     

  • January 26, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • January 26, 2005 at 9:18 am

    #539166

    Don't believe there is but for a file that might be corrupt you can stop SQL Server, rename the log files extension to like .old from .ldf then restart SQL, it will build a new log file automatically.

Viewing 3 posts - 1 through 2 (of 2 total)

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