Re: qiestion about master

Hello,

Login into SQL Express using SQLCMD or SQL Server Express management studio
and execute sp_helpdb <dbname> against
each of the system datatabases and note the physical location. If the file
you specified is used then please do not delete the files.

Note:

Each SQL Server instance require these system databases

Thanks
Hari

"Dirk" <sdcsd@ds> wrote in message
news:%23P8ULRQcHHA.2316@xxxxxxxxxxxxxxxxxxxxxxx
Hi, thanks but

i still don't know whether the master, model .. of the central
databasesystem are linked or not to the master, model ... put in
c:\documents and settings\user\... and related to the MDF/LDF files of an
user. Are those local system databases needed for running the central
databases?


"Hari Prasad" <hari_prasad_k@xxxxxxxxxxx> schreef in bericht
news:%234F8PbNcHHA.4888@xxxxxxxxxxxxxxxxxxxxxxx
Hello,

Please do not remove the MDF/LDF files belongs to Master, Model, MSDB,
TempDB databases. Those are all system database files which is required
to run the SQL Server instance. Incase if you delete those files the
entire instance will become non-operatable.

Thanks
Hari

"Dirk" <zerze@ssdg> wrote in message
news:uSqzGIKcHHA.4348@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

i use sql server 2005 express where i created several databases. When
opening Management Studio, i can see, besides my databases, also Master,
Model etc .. which manage the databases.
Now i also use MDF files which are disseminated on the same server.
I see that for one given user, there was also a Master, Model etc ... in
c:\document and settings\that user\ .....

My question is: are those Master, Model etc ... related with the Master,
Model ... of the central database system or are they independant? What
if i delete the MDF files and its related system files in c:\.doc and
settings\.. ?

Thanks
Dirk







.

Relevant Pages

  • 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: How can I remove Public access to SQL Express dbs?
    ... Will the SQL Server Management Studio work ... You can't delete guest but can render it unusable by revoking ... CONNECT permission in databases other than master and tempdb. ...
    (microsoft.public.sqlserver.security)
  • Why is sp_helpdb and sysdatabases different
    ... This is the case for all databases except ... exec sp_helpdb master. ... sp_help is showing on F:\ F: is the correct location. ...
    (comp.databases.ms-sqlserver)
  • Re: Server Migration...
    ... If you have restored all of your databases, ... Columnist, SQL Server Professional ... Does that mean I need to restore all user databases first and I restore ... Master, MSDB, Model. ...
    (microsoft.public.sqlserver.server)
  • Re: Use Management Studio with 2000 databases?
    ... I would like to point out that you should probably install the SQL Server ... Management Studio (SSMS) along side Enterprise Manager if you use the ... You'll need EM for working with SQL 2000 server databases. ... Management Studio as compared to Enterprise Manager. ...
    (microsoft.public.sqlserver.tools)