topic Re: SMSQL SnapInfo sizing in Data Protection https://community.netapp.com/t5/Data-Protection/SMSQL-SnapInfo-sizing/m-p/28482#M5365 <HTML><HEAD></HEAD><BODY><P>[bump] Anyone??</P></BODY></HTML> Tue, 17 Sep 2013 14:20:11 GMT radek_kubka 2013-09-17T14:20:11Z SMSQL SnapInfo sizing https://community.netapp.com/t5/Data-Protection/SMSQL-SnapInfo-sizing/m-p/28478#M5364 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">Hi all,</SPAN></P><P></P><P><SPAN style="color: #000000;">Can someone clarify a little bit what has been stated in TR-4003 re SnapInfo sizing please?</SPAN></P><P></P><P><SPAN style="color: #000000;">There is a useful hint on p.46:</SPAN><BR /><SPAN style="color: #000000;"><EM>“Note that <SPAN style="text-decoration: underline;">the size of a TLOG backup equals the used portion of the TLOG and not the actual TLOG file size</SPAN>. The used portion’s size may be determined by using the command DBCC SQLPERF(‘LOGSPACE’).”</EM></SPAN></P><P></P><P><SPAN style="color: #000000;">Further down sizing SnapInfo sizing steps are explained, referring to a script in the Load Generation Scripts section of the Appendixes – but there is only a load generation script, useless for obtaining TLOG file size.</SPAN></P><P></P><P><SPAN style="color: #000000;">I googled a bit &amp; found this script, which in my view does the job:</SPAN></P><P><SPAN style="color: #1f497d;"><A href="http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a06a00d8-2e21-4cb0-aff1-af2ef00d4e8c/need-a-script-for-log-space-monitoring" target="_blank">http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a06a00d8-2e21-4cb0-aff1-af2ef00d4e8c/need-a-script-for-log-space-monitoring</A></SPAN></P><P></P><P><SPAN style="color: #000000;">Can someone confirm that only used portion of TLOG should be used for SnapInfo sizing?</SPAN></P><P></P><P><SPAN style="color: #000000;">Thanks,</SPAN><BR /><SPAN style="color: #000000;">Radek</SPAN></P><DIV class="mcePaste" id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow: hidden;"> </DIV></BODY></HTML> Thu, 05 Jun 2025 05:54:01 GMT https://community.netapp.com/t5/Data-Protection/SMSQL-SnapInfo-sizing/m-p/28478#M5364 radek_kubka 2025-06-05T05:54:01Z Re: SMSQL SnapInfo sizing https://community.netapp.com/t5/Data-Protection/SMSQL-SnapInfo-sizing/m-p/28482#M5365 <HTML><HEAD></HEAD><BODY><P>[bump] Anyone??</P></BODY></HTML> Tue, 17 Sep 2013 14:20:11 GMT https://community.netapp.com/t5/Data-Protection/SMSQL-SnapInfo-sizing/m-p/28482#M5365 radek_kubka 2013-09-17T14:20:11Z