Results 1 to 2 of 2

Thread: Log file

  1. #1
    Join Date
    Oct 2003
    Posts
    83

    Unanswered: Log file

    From QA how can I check the present status of log file for a particular database?I want to check weather the log file is full or not?How much percentage it is full?And how can I take any action if the log file is full?
    Everything should be done from QA?

    Subhasish

  2. #2
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    dbcc sqlperf(logspace) will tell you the status and %full (as well as size) of all the log files in the instance.

    Best way to reduce the log file size is to backup the log file up (using backup log ....) and then shrink the log file (using dbcc shrinkfile ...).
    Both are well documented in BOL.
    Regards
    Dbabren

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •