cancel
Showing results for 
Search instead for 
Did you mean: 

How to restore a SQL server?

jbejarano
Level 1

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.

1 ACCEPTED SOLUTION

Accepted Solutions

pkh
Moderator
Moderator
   VIP    Certified

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.

View solution in original post

1 REPLY 1

pkh
Moderator
Moderator
   VIP    Certified

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.