Showing posts with label sql. Show all posts
Showing posts with label sql. Show all posts

Wednesday, April 20, 2011

Did you checked what is the log file of SCCM DB ? or did you checked what is the backup size and why it is increasing ?

Did you checked what is the log file of SCCM DB ? or did you checked what is the backup size and why it is increasing ?

 

Yes it is because of transaction log size increase … check below query to know the size of the log files….

 

 

 

SELECT name,size from sys.database_files


output:-

name                         size
SMS_SiteCode           662576
SMS_SiteCode_log     3541704