backup after installation

anonymous_at_discussions.microsoft.com
Date: 09/30/04


Date: Thu, 30 Sep 2004 16:03:20 -0700

after installation of sql server service pack is it
recommended to backup
master
model
tempdb
msdb
and the application databases?



Relevant Pages

  • 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: what you need to do before installing the sql server version2000 service pack 3a
    ... If you do nothing else, make sure you back up your Master, Msdb & all user ... databases. ... It's also a good idea to back up your registry as well. ...
    (microsoft.public.sqlserver.server)
  • Re: Guest userin Master and tempdb database
    ... you can add it or delete it from all databases except master and tempdb. ... Most users access master and tempdb as guests and because of this, ... remove the guest account from these databases. ...
    (microsoft.public.sqlserver.security)
  • Maintenance Plan on SQL2005
    ... choose any databases to backup other than the default ones (master, model, ... msdb, tempdb). ...
    (microsoft.public.sqlserver.tools)
  • Re: Restored All Database Except the Master
    ... model is a "default" database that all new databases are modeled after ... > MASTER, MODEL, MSDB and PUBS. ... > need to restore these ones to our new SQL server? ...
    (microsoft.public.sqlserver.setup)