SQL Server Performance Forum – Threads Archive
Disk Usage for TLOG
Hi all Is there anyway to find out using TSQL for the used space VS what is available for TLOG file? Cause the GUI won’t allow me [Database] > Report > Disk Usage. It said that Unable to display the report becuase the database has a compatibility level of 80 ?!?! ThanksAre you using 2005? If so, why have you not changed the compatabililty level to 90? Of course there may be a good reason for leaving it in 80 mode, but if not, change it to 90 mode. When you upgrade a 2000 database to 2005, the compatability level is not changed automatically, you have to do this yourself. ————————————————————–
Brad M. McGehee, SQL Server MVP
Technical Editor/Moderator www.SQL-Server-Performance.Com
Director of DBA Education for www.Red-Gate.Com
www.sqlbrad.com
www.sqlHawaii.com
Try
dbcc sqlperf(‘logspace’) MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
See thishttp://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1252873,00.html to. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>