Re: Maximum number of databases on a server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Hassan (fatima_ja_at_hotmail.com)
Date: 09/13/04 

Date: Mon, 13 Sep 2004 15:10:52 -0700

32,767 databases per instance of SQL Server.

"Ken" <Ken@discussions.microsoft.com> wrote in message
news:E12B7A3A-E7A0-41BA-B74E-3A60A166D5EA@microsoft.com...
> I was wondering if their is a hard limit to the number of databases that
can
> be attached to a SQL Server 2000 standard install.
>
> Thanks

Relevant Pages

  • Re: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)
  • Re: Please answer my queries for fresh Installation
    ... Moving SQL Server Databases ... Using WITH MOVE in a Restore to a New Location with Detach/Attach ... Disaster Recovery Articles for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Please answer my queries for fresh Installation
    ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
    (microsoft.public.sqlserver.server)
  • Re: Moving SQL Server 2000 from NT4.0 to Windows 2003
    ... Detach your existing user databases, ... user databases (or RESTORE) to the new server. ... > Hey Steve, ... Windows 2003 will not allow SQL Server SP less than 3. ...
    (microsoft.public.sqlserver.server)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... MDB is friggin dead.. ... SQL Server has taken over the world. ... than read-only access to central company databases. ... I learned to write queries in Access after an hours' ...
    (microsoft.public.excel)