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?
Subhasishdbcc 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.
No comments:
Post a Comment