Re: I need backup Master data base?

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

On Mon, 22 May 2006 11:03:19 -0300, "retf"
<re.tf@xxxxxxxxxxxx> wrote:

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

why?

And What othen ?

Thanks


.

Relevant Pages

  • Re: For OS 10.4, do I need to have a 3rd party application do HD maintenance?
    ... >> I paid my Mac dealer about ... and they managed to recover all. ... Disks fail. ... the contractor was supposed to have backups, ...
    (comp.sys.mac.apps)
  • Help! I lost my life (Again)!
    ... In the matter of fact I used that HD to hold old backups from ... I have asked for quote to restore some folder from the HD from an UK based ... the prelim quote was 275 UKP (I only asked to recover on directory ... and it holds also copies from at least 2 older hard disks. ...
    (comp.arch.fpga)
  • Recover historic databases
    ... To prevent disaster recovery I do backups every day and it works fine, ... want to archive historic databases to recover it if necessary. ... version of SQL server. ...
    (microsoft.public.sqlserver.security)
  • Help Crash!!
    ... was able to recover the C:\MSSQL7\Data ... directory with all of the MDF and LDF files in it for the databases. ... copies of backups. ...
    (microsoft.public.sqlserver.server)
  • Re: What should I Do?
    ... If the c:/ and d:/ were really on seperate physical disks then would it then ... where the data is that I would just need to recover the data but not ... everything resides on because it is mirrored....plus my backups are backed up ... >> someone else takes over the server then it's been set up properly. ...
    (microsoft.public.sqlserver.server)