SQL 2000 System Db's

[Bill Kellaway]

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,

Bill

[John Bell]

Re: SQL 2000 System Db's

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

"Bill Kellaway" <billkellaway@h otmail.com> wrote in message
news:f3ae0ca6.0 311280853.56252 a59@posting.goo gle.com...[color=blue]
> 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,
>
> Bill[/color]