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

execute in query Analyzer
to know the Size of Log File
sp_helpdb NameOfDataBase

to shrink search about
DBCC SHRINKDATABASE

Ahmed Ali
Software Developer

Mr. Ali
           Thanks.
But sp_helpdb can not give the picture of status about the log file/files.I want to know how much percentage the log file is filled up?
Does DBCC sqlperf(logspace) help me?
How can I take the back up of Log file and then shrink?I want to know thr syntax.
Asish

Try to do whatever you want to do with the log files, from "SQL Server Enterprise Manager": right click on the database and select the "All Tasks" / "Shrink Database" context menu. There you can se sizes and percentages.

If you press the "Files..." button on this dialog, you can see sizes and percentages for individual files. You can also shrink files. (i never did it though)

If you want to do all this from QA, you can monitor with "SQL Profiler" to see what happens behind the scenes when you use "Enterprise Manager" to see those sizes and do the shrinking. And look in BOL to find out more about the SQL commands that EM uses when it calculates sizes and shrinks the databases.

defiant.