New named instance.

I am going to be using our SQL Server to manage a project
database. SQL Server is installed on our Windows 2000
server using SBS. Currently there is a named
instance "SERVER1\BKUPEXEC" that is being used by Backup
Exec. Do I need to create a new named instance to use as
for my database manager or can I safely use the existing
instance?| I am going to be using our SQL Server to manage a project
| database. SQL Server is installed on our Windows 2000
| server using SBS. Currently there is a named
| instance "SERVER1\BKUPEXEC" that is being used by Backup
| Exec. Do I need to create a new named instance to use as
| for my database manager or can I safely use the existing
| instance?
--
In general, using a single instance of SQL Server for all database work is
best practice, to wit:
- You can have as many as 32, 767 databases per instance but you can only
have up to 16 instances on one server.
- Using 16 databases in one instances requires less resources than having 1
database for each of your 16 instances on the server.
The only advantage with using several instances is that if one instance
crashes for whatever reason, the other instances are not affected.
Hope this helps,
--
Eric Cárdenas
SQL Server support