Forum Discussion

jbejarano's avatar
jbejarano
Level 1
10 years ago

How to restore a SQL server?

I have a couple of SQL servers and I´m doing restore test and I´m facing whit the problem that I have to do a two steps restores one for the OS whit the SDR and other for the SQL instance is that true or there is other way to do it in a one step?

I´m using a SQL Agent, Windows Agent, is an Appliance 3600.

Thanks for your help.

Agents
Backup and Recovery
Backup Exec 3600 Appliance
Restore
Windows Server (2003-2008)
  • pkh's avatar
    pkh
    10 years ago

    This is correct.  It is always a 2-step restore as you described.

    SQL backups/restores using the SQL Agent is done by invoking the SQL API.  This neads SQL Server to be up and running before the restore of the SQL data can begin.

  • pkh's avatar
    pkh
    Moderator
    10 years ago

    This is correct.  It is always a 2-step restore as you described.

    SQL backups/restores using the SQL Agent is done by invoking the SQL API.  This neads SQL Server to be up and running before the restore of the SQL data can begin.