Friday, February 24, 2012

Backup master database

Hi,
Is there a need to backup the master database with my other databases?
Hagay.Absolutely..
Backup Master every day... Master contains the logins, info about the other
databases and the system configuration...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hagay Lupesko" <hagayl@.nice.com> wrote in message
news:e92o8wzhDHA.336@.tk2msftngp13.phx.gbl...
> Hi,
> Is there a need to backup the master database with my other databases?
> Hagay.
>|||Hagay
It is a very good idea to backup your master database. It
should be done on a regular basis. Daily usually as it is
very small and in most cases will only take seconds to
perform. (You do not usually need transaction logs from
your master database, most people run it in simple
recovery mode)
I prefer to keep my system database backups seperate from
my user databases, but you don't need to.
It is also a good idea to backup your master database
before making changes to other databases, configurationand
anything else that may effect any of the databases on your
server.
Hope this helps.
John

No comments:

Post a Comment