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

No comments:

Post a Comment