- Create a SQL Recovery script
Open the NBU SQL Client on a SQL Server server
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/95/9F/wKiom1kXxxeg_Y6wAAGewwFARxM320.png "/>
Select Restore SQL Server Objects
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/95/9F/wKiom1kXxxeCx_CQAACPjECCBZY990.jpg "/>
3. SQL Host Write Machine
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/95/9F/wKioL1kXxxexOU5SAADYTAt3KsU539.png "/>
4. Select the library you want to restore and save the script
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/95/9F/wKiom1kXxxjxtIawAAFDX-feFZE249.png "/>
- Create a SQL recovery policy
1. Type selection Ms-sql
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/95/9F/wKioL1kXxxig4ZOSAAGTtjrwWAU363.png "/>
2. Add a Scheduled task
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/95/9F/wKioL1kXxxnAMWhxAADG8gtTIa4951.png "/>
3. Add Client
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/95/9F/wKiom1kXxxnAOTNJAACBgPrivsc419.png "/>
4. Select Recovery Script
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/95/9F/wKiom1kXxxmyDZQkAABx3q0xw4M996.png "/>
Manual Run Policy
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/95/9F/wKioL1kXxxny5TK-AAFjEK0tiMo577.png "/>
6. Successful restoration
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/95/9F/wKiom1kXxxqioQO8AADitQISwWY187.png "/>
This article is from the "Contoso" blog, so be sure to keep this source http://contoso.blog.51cto.com/292002/1925439
NBU Restoring SQL Server to a different machine