I need backup Master data base?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

retf - 22 May 2006 15:03 GMT

I need backup Master data base, or only my DB?

why?

And What othen ?

Thanks

Reply to this Message

Sue Hoegemeier - 23 May 2006 00:06 GMT

You 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

>I need backup Master data base, or only my DB?
>
[quoted text clipped - 3 lines]
>
>Thanks

Reply to this Message

"privatenews" - 23 May 2006 03:42 GMT

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/default.aspx?scid=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/default.aspx?scid=kb;EN-US;240872

PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/default.aspx?scid=kb;EN-US;168001

HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?scid=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.

=====================================================

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message