Home > Blogs > VMware VROOM! Blog


Site Recovery Manager SQL Server Database Sizing

VMware vCenter Site Recovery Manager (SRM) is a component of the VMware Infrastructure that accelerates recovery for the virtual environment through automation, ensures reliable recovery by enabling non-disruptive testing and simplifies recovery by eliminating complex manual recovery steps and centralizing management of recovery plans.
 
SRM uses a database to store the protection group settings, recovery plan settings, results for testing recovery plans or actually running a real recovery and much more. Some of the disk space usage is permanent in nature while some of it is transient.
 
A SQL Server Database sizing guide is now available for VMware vCenter Site Recovery Manager at http://www.vmware.com/products/srm/resource.html under the "Tools" category which will assist you in estimating transient as well as non transient disk space usage for SRM SQL server Database.
 
This guide uses following input parameters to estimate the SQL Server Database size for both primary and the secondary site. 
 

Number of Protected VMs
Number of Protection Groups
Number of VMs you Plan to Recover
Number of Recovery Plans
Average Number of Protection Groups to be included in each Recovery Plan
Average Number of Test Failovers/Recoveries to perform per month
Average Number of default steps per Recovery Plan
Average Number of "message steps" to be added per Recovery Plan
Average Number of "command steps" to be added per Recovery Plan

 
Just fill in these numbers based on your inventory setup to obtain an estimate about the disk space usage for your SRM Database.

4 thoughts on “Site Recovery Manager SQL Server Database Sizing

  1. recovery for sql server

    There is a good tool,which recover sql files-Recovery Toolbox for SQL Server,also as is known software is free,it repair data from corrupted databases in the MS SQL Server format (files with the *.mdf extension),supports data extraction via the local area network,can save recovered data as SQL scripts, it is also possible to split data into files of any size,compatible with all supported versions of Microsoft Windows, such as Windows 98, Windows Me, Windows NT 4.0, Windows 2000, Windows XP, Windows XP SP2, Windows 2003 Server, Windows Vista,tool supports the following database formats: Microsoft SQL Server 7.0, 2000, 2005,also can repair .mdf files of Microsoft SQL Server 2005, repair mdf file of Microsoft SQL Server 2005 (64-bit).

    Reply
  2. repair sql server database

    Know good tool which recover data also it restore sql files too-repair sql server database,it is free as how as i remember,utility repair data from corrupted databases in the MS SQL Server format (files with the *.mdf extension),supports data extraction via the local area network,can save recovered data as SQL scripts, it is also possible to split data into files of any size,compatible with all supported versions of Microsoft Windows, such as Windows 98, Windows Me, Windows NT 4.0, Windows 2000, Windows XP, Windows XP SP2, Windows 2003 Server, Windows Vista,tool supports the following database formats: Microsoft SQL Server 7.0, 2000, 2005,also can repair .mdf files of Microsoft SQL Server 2005, repair mdf file of Microsoft SQL Server 2005 (64-bit).

    Reply
  3. mssql repair database 2005

    In my opinion there is unbeaten tool,which recover sql files-mssql repair database 2005,because it has many probabilities and as far as I know has free status,program can help with this problem and retrieve the data, that was considered to be lost,mwill extract housekeeping data from the source database and preview the data, that can be recovered,this tool is a good solution to recover data from corrupted databases in MS SQL Server format,restore databases represent files, like any other documents, they can be easily corrupted by viruses, all sorts of malware, hard drive failures, file system errors, incorrect user actions, etc,supports both data extraction to your hard drive as scripts in SQL format and data export directly to a database in MS SQL Server format.

    Reply
  4. Venkat Sarath

    thanks for sharing this info please comment if other tools are available.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *