Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Location
    Aix en Provence (France)
    Posts
    2

    Unanswered: SQLServer Backup and restore

    My company recently bought a BI software for the controlling departement based on SQL Server.
    It's the first SQL Server database we get (we are full Oracle on other domains).

    SQLServer has been provided as a runtime and we have very few details on the administration.

    I wonder if a classic full disk dayly backup is OK or do we have to use SQLserver administration tool ?

    If the first solution is OK, what is the procedure to restore (list of files...) ?

    Thank you in advance for your answer on a so basic question.

    Best regards
    Olivier CHIONO

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    The full disk backup will only work if you are doing a cold backup (with MSSQLSERVER service stopped. The critical files to restore are master.mdf, mastlog.ldf and whatever files make up your database (select * from (dbname)..sysfiles) Getting back a database this way is a little tricky, as you will have to fool SQL Server into thinking it is still on its old home (SQL Server does not like machine name changes).

    I would advise using any number of hot backup utilities. Most vendors (Veritas, OmniBack, Legato, etc.) have a plug in that will handle the SQL backups and restores.

    Hope this helps.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You can do a full disk backup, but then you will only be able to restore to the time of the backup. If you use SQL Server to backup database and logs to a separate platform (preferably a remote location) you could do point-in-time restores up to the time of failure.
    Can you afford to lose a day's worth of data?

    For a single SQL database 3rd party backup tools should not be necessary, unless you already have some for Oracle which will handle SQL Server. You should get a SQL Server consultant to come in and analyze your situation to devise backup, restore, and secury procedures.

    blindman

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    149
    My 2 cents worth, if you need faster recovery throw some differentials along with the transaction log backups.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •