RE: Number of databases on a virtual server

From: Uttam Parui[MS] (uttamkp_at_online.microsoft.com)
Date: 08/05/04


Date: Thu, 05 Aug 2004 22:17:03 GMT

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/default.asp?url=/library/en-us/architec/8_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



Relevant Pages

  • Re: Backup still not working
    ... So you may try to rebuild the RSM database if the ... > rename the existing files in this folder to a .old file extension, ... > this time unchecks "First Storage Group" under Microsoft Exchange Server. ... > 1) Open SQL Server Enterprise Manager. ...
    (microsoft.public.windows.server.sbs)
  • Re: cant move sharepoint by the instructions. AGAIN
    ... Monitoring database to another location. ... If you installed the SQL Server or the SQL Server Management Tools, ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Database Connectivity
    ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
    (comp.lang.python)
  • Re: MS Access DAO -> ADO.NET Migration
    ... Microsoft chose to change the name from SQL Server Everywhere ... It's a fully relational database that supports a subset of the ... DAO has methods and properties that are Access ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)