Number of databases on a virtual server

Is there a limit to the number of databases exposed through a virtual server?
I'm looking at porting over 200 databases from 12 different servers into a clustered environment and want to minimize the number of SQL Server installs that need to be performed on the cluster.
Thanks in advance.
The limits for standalone SQL Server holds true for virtual SQL Server.
Databases per instance of SQL Server --> 32,767
Database size --> 1,048,516 TB
Filegroups per database --> 256
Files per database --> 32,767
File size (data) --> 32 TB
File size (log) --> 32 TB
For more information, please refer to
Maximum Capacity Specifications
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||also check out the links below - which document well the potential issues
you may face when consolidating SQL Server .
http://www.microsoft.com/windows2000...ble/bpdcac.asp
http://www.microsoft.com/technet/pro...olidation.mspx
cheers,
Andy
"poul0004" <poul0004@.discussions.microsoft.com> wrote in message
news:BFAC1003-8F16-4EDD-AD15-7B6050E59B51@.microsoft.com...
> Is there a limit to the number of databases exposed through a virtual
server?
> I'm looking at porting over 200 databases from 12 different servers into a
clustered environment and want to minimize the number of SQL Server installs
that need to be performed on the cluster.
> Thanks in advance.
|||also slightly more detailed - more planning orientated
http://www.microsoft.com/technet/pro.../sql2kcon.mspx
"poul0004" <poul0004@.discussions.microsoft.com> wrote in message
news:BFAC1003-8F16-4EDD-AD15-7B6050E59B51@.microsoft.com...
> Is there a limit to the number of databases exposed through a virtual
server?
> I'm looking at porting over 200 databases from 12 different servers into a
clustered environment and want to minimize the number of SQL Server installs
that need to be performed on the cluster.
> Thanks in advance.
sql