SQL Server

From: Mathew (anonymous_at_discussions.microsoft.com)
Date: 03/02/04 

Date: Mon, 1 Mar 2004 20:00:10 -0800

Hi,

I started my new job in a company a couple of days ago.
As I knew, 4 system databases (Master, Tempdb, MSDB, and
Model) should not be deleted, and deleting these
databases can cause variety of problems. Unexpectedly, I
saw that there is not any of these databases in the
database list in enterprise manager, and their main
database is working pretty well. How can it happen?
Please explain a little bit about this topic.

Thank you so much for your time.

Mathew

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: Move databases between servers
    ... What I'm trying to do now is to copy master. ... Now I'm reinstalling sql with identical version, and restore all databases ... Since the logins are in master and operators/agents are in msdb why I ... copy all database and log files to new server ...
    (microsoft.public.sqlserver.setup)
  • backup after installation
    ... and the application databases? ...
    (microsoft.public.sqlserver.programming)
  • Re: Move databases between servers
    ... Tell me why you need to move master, msdb, and model? ... When you restore databases on your other server SQL Server adds ... If you have lots of jobs defined you could try restoring MSDB. ...
    (microsoft.public.sqlserver.setup)
  • Re: Move Existing SQL Server to a New Server
    ... Restore master, then model, then msdb then the user ... databases during start up ... I do not want to move all user databases, ... > moving or restoring the databases - especially related to ...
    (microsoft.public.sqlserver.setup)