Data Backup and Recovery

SMSQL SnapInfo sizing

radek_kubka
3,229 Views

Hi all,

Can someone clarify a little bit what has been stated in TR-4003 re SnapInfo sizing please?

There is a useful hint on p.46:
“Note that the size of a TLOG backup equals the used portion of the TLOG and not the actual TLOG file size. The used portion’s size may be determined by using the command DBCC SQLPERF(‘LOGSPACE’).”

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.

I googled a bit & found this script, which in my view does the job:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a06a00d8-2e21-4cb0-aff1-af2ef00d4e8c/need-a-script-for-log-space-monitoring

Can someone confirm that only used portion of TLOG should be used for SnapInfo sizing?

Thanks,
Radek

1 REPLY 1

radek_kubka
3,229 Views

[bump] Anyone??

Public