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.
Posted by Aalap Desai on January 9, 2009 | Permalink
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).
Posted by: recovery for sql server | January 21, 2009 at 08:04 AM
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).
Posted by: repair sql server database | March 26, 2009 at 08:45 AM
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.
Posted by: mssql repair database 2005 | June 04, 2009 at 02:02 PM