sql server (alternate): SQL 2000 System Db's -- sql server (alternate)

SQL 2000 System Db's

billkellaway NO[at]SPAM hotmail.com
11/28/2003 8:53:33 AM

sql server (alternate): Hello there,

This is somewhat of a newbie SQL question. What are the minimun
databases SQL needs to operate correctly. I have inherited a SQL db
and am not a DBA.

The db's that exist are: Master, Model, MSDB, TempDB, Pubs, Northwind
along with the databases I've created.

It seems to me that SQL probably needs Master and that I know I can
delete Northwind. Does anyone know about the rest ???

Thanks,

Re: SQL 2000 System Db's

John Bell
11/28/2003 5:07:43 PM

Hi

See

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_3vcm.asp

Northwind and Pubs are sample databases, the others are system databases.

John

[quoted text, click to view]