Data Backup and Recovery Discussions

SMSQL SnapInfo sizing

radek_kubka

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

[bump] Anyone??

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public