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.

  • 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.

1 Reply

Replies have been turned off for this discussion
  • 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.