Sunday, February 19, 2012

I need backup Master data base?

I need backup Master data base, or only my DB?
why?
And What othen ?
ThanksYou need backups of database you want to be able to recover.
So if your system totally crashed and you lost all your
disks, how would you get the system back up and running as
it was before the disks all crashed? You'd need backups of
your system databases (except tempdb) and your user
databases. How often depends upon your business needs,
changes to your system and user data, etc.
You can read about backup and recovery in books online for
whichever version of SQL Server you are running.
-Sue
On Mon, 22 May 2006 11:03:19 -0300, "retf"
<re.tf@.terra.com.br> wrote:

>I need backup Master data base, or only my DB?
>why?
>And What othen ?
>Thanks
>|||Hello,
Agree with Sue and I have included the following articles for your
reference:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://support.microsoft.com/defaul...KB;EN-US;307775
HOW TO: Resolve Permission Issues When You Move a Database Between Servers
That Are Running SQL Server
http://support.microsoft.com/defaul...kb;EN-US;240872
PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/defaul...kb;EN-US;168001
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/defaul...KB;EN-US;314546
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment