General discussion

  • Creator
    Topic
  • #2195880

    sql backup

    Locked

    by ldap_pro ·

    hi all

    what do i need to restore a sql server?

    i manauly backed up under databases the system databases and the organization databases.

    there is also the database itself that i should backup. can i just stop the service and copy those files (mdf and ldf files)?

    thanks
    aki

All Comments

  • Author
    Replies
    • #3150505

      Reply To: sql backup

      by cmiller5400 ·

      In reply to sql backup

      You should backup, master, model, msdb and your user databases. Using maintenance plans for your databases, you can schedule these and dump them to a drive to backup. Each database will create a file to backup. You then can restore each database to the server once rebuilt. The exception is the master database, it requires a little more work to restore. I sugguest that you get a copy of the book MCSE Microsoft SQL Server 2000 System Administration by Microsoft. It is an excellent book and explains this in detail. Also, Microsoft’s site has a plethora of information on SQL recovery etc.

    • #3150884

      Reply To: sql backup

      by tony hopkinson ·

      In reply to sql backup

      No don’t do that, resore after a configuration change and you could break the entire thing.

      You need to back up Master before every config change (add inner login, database etc)

      MSDB every time you chnage a scheduled job

      and your databases on an sensible basis.

      If you are using the full product run up enterprise.

      The TSQL command is BACKUP
      This might give you a few ideas

      http://www.devarticles.com/c/a/SQL-Server/Building-Your-First-SQL-Server-2000-Database/3/

      you can use the scheduler to do a timed backup as well.
      Again it’s easier from enterprise. but there is a stored procedurre to add a job to teh agent, has lots of parameters though.

    • #3149461

      Reply To: sql backup

      by ldap_pro ·

      In reply to sql backup

      This question was closed by the author

Viewing 2 reply threads