Restore of a Windows Server 2012R2 database

Restore of a Windows Server 2012R2 database

Example: Crash of a simulated server

In the actual working environment, because the administrator's misoperation and the server itself causes the data destruction or loss, if the administrator's misoperation can also restore the local data back, if the database crashes that data from the local recovery is not back, below, we simulate the server crashes, Back up the data to a different server before the server crashes.

Impersonation server: Server01 is the server that is preparing to crash

Server02 is a brand new, which is the server that later put the data

Preparation: Prepare two disks, one on the Server01, the other on the SERVER02 (not the system disk. ）

First add a new disk on server 01 and copy the data to a new disk

Create a new user on server 01, named Tom,

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/81/wKioL1Uvc-TQF5vpAAE2QsXKhjw061.jpg "style=" width : 600px;height:561px; "title=" Qq20150416162128.png "width=" "height=" 561 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvc-tqf5vpaae2qsxkhjw061.jpg "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/85/wKiom1UvcpDxVi3ZAAElLwP0qt8996.jpg "style=" width : 600px;height:566px; "title=" Qq20150416162145.png "width=" "height=" 566 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1uvcpdxvi3zaaellwp0qt8996.jpg "/>

To back up data on server 01 to a new disk

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/81/wKioL1Uvc-SiH5W_AAG2zAV1jWI855.jpg "style=" width : 600px;height:219px; "title=" Qq20150416162729.png "width=" "height=" 219 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvc-sih5w_aag2zav1jwi855.jpg "/>

Step One: Copy the backup file to server 02 and add a new disk

First, place your mouse on the virtual machine circled by the red circle. Right-click > Settings

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/7E/wKioL1UvXSzCAryrAALeR8SdPr8351.jpg "title=" Qq20150416145101.png "width=" "height=" 339 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" WIDTH:600PX;HEIGHT:339PX; "alt = "Wkiol1uvxszcaryraaler8sdpr8351.jpg"/>

Click Add, and then determine

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/7E/wKioL1UvXJ_AxhhhAAKQvFj7NZI441.jpg "style=" width : 600px;height:545px; "title=" Qq20150416143253.png "width=" "height=" 545 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvxj_axhhhaakqvfj7nzi441.jpg "/>

Select a piece of hard disk, next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/7E/wKioL1UvXJ-ipMbRAAEdDSKr-sM680.jpg "style=" width : 600px;height:480px; "title=" Qq20150416143318.png "width=" "height=" 480 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvxj-ipmbraaeddskr-sm680.jpg "/>

Choose the recommended SCSI here,

Next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/82/wKiom1UvW0vysZEkAAFK5BNCJCQ399.jpg "style=" width : 600px;height:484px; "title=" Qq20150416143335.png "width=" "height=" 484 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1uvw0vyszekaafk5bncjcq399.jpg "/>

Click Create Virtual Disk, and then click Next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/82/wKiom1UvW0vydppgAAF5uaTZvdc978.jpg "style=" width : 600px;height:480px; "title=" Qq20150416143346.png "width=" "height=" 480 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1uvw0vydppgaaf5uatzvdc978.jpg "/>

Maximum disk size, look at their own server data content size, I here to 20GB is enough,

To store a virtual disk as a single file

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/7E/wKioL1UvXJ_TmrpoAAHF-JIylFY102.jpg "style=" width : 600px;height:484px; "title=" Qq20150416143414.png "width=" "height=" 484 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvxj_tmrpoaahf-jiylfy102.jpg "/>

Here the choice is the location of the disk storage, I chose the G disk, where the disk is not emphasized, in the file name

box, write your own name for this disk.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/7E/wKioL1UvXJ_yLxUzAAG4voGTwds480.jpg "style=" width : 600px;height:426px; "title=" Qq20150416143458.png "width=" "height=" 426 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvxj_ylxuzaag4vogtwds480.jpg "/>

This is where I finally put the disk, click Finish.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/82/wKiom1UvW0yQ6jeWAAEDH6sJ2C4116.jpg "style=" width : 600px;height:488px; "title=" Qq20150416143617.png "width=" "height=" 488 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1uvw0yq6jewaaedh6sj2c4116.jpg "/>

Next, to manage the disk,

Right-click Windows, select Disk Management

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/7E/wKioL1UvYYWQsfFOAADEy6NvSgI609.jpg "style=" width : 600px;height:90px; "title=" Qq20150416150220.png "width=" "height=" + "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvyywqsffoaadey6nvsgi609.jpg "/>

Right-click on disk 1 > online

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/7E/wKioL1UvYYayiH9wAAIKZzw4fFY333.jpg "style=" width : 600px;height:330px; "title=" Qq20150416150322.png "width=" "height=" "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvyyayih9waaikzzw4ffy333.jpg "/>

On disk 1, right-click Initialize

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/83/wKiom1UvYDLx-rx5AAEDuyWBetA452.jpg "style=" width : 600px;height:197px; "title=" Qq20150416150351.png "width=" "height=" 197 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1uvydlx-rx5aaeduywbeta452.jpg "/>

Click OK

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/7E/wKioL1UvYYbCfPMHAAFQVkGFEgI264.jpg "style=" width : 600px;height:500px; "title=" Qq20150416150429.png "width=" "height=" "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvyybcfpmhaafqvkgfegi264.jpg "/>

Right-click > Create a new simple volume in the circled area of the red circle

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/83/wKiom1UvYDLAz91SAAEZ2_EnxOQ735.jpg "style=" width : 600px;height:80px; "title=" Qq20150416150713.png "width=" "height=", border= "0" hspace= "0" vspace= "0" alt= " Wkiom1uvydlaz91saaez2_enxoq735.jpg "/>

The new Simple Volume wizard appears, click Next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/7E/wKioL1UvYYaiO8tTAAGcUHhw6Y8963.jpg "style=" width : 600px;height:513px; "title=" Qq20150416150730.png "width=" "height=" 513 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvyyaio8ttaagcuhhw6y8963.jpg "/>

Default Next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/83/wKiom1UvYDLCcK49AAENa2tr5Qg568.jpg "style=" width : 600px;height:513px; "title=" Qq20150416150744.png "width=" "height=" 513 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1uvydlcck49aaena2tr5qg568.jpg "/>

In assigning the following drive numbers here, the driver can be arbitrarily given, in fact, it is the difference between the drive letter, for example,

Choose D here, and the future will be D-disk. What I chose here is E.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/7E/wKioL1UvYYbTppVaAAFAWGklHPg171.jpg "style=" width : 600px;height:517px; "title=" Qq20150416150806.png "width=" "height=" 517 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvyybtppvaaafawgklhpg171.jpg "/>

Default Next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/83/wKiom1UvYHCDYqYpAAGaghyfI5c113.jpg "title=" Qq20150416150816.png "width=" "height=" 517 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" WIDTH:600PX;HEIGHT:517PX; "alt = "Wkiom1uvyhcdyqypaagaghyfi5c113.jpg"/>

The appearance of this interface means that the simple volume has been built.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/83/wKiom1UvYDaS3Ih9AAIxnG_Ee90520.jpg "style=" width : 600px;height:512px; "title=" Qq20150416150824.png "width=" "height=" "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1uvydas3ih9aaixng_ee90520.jpg "/>

To verify that the simple volume is really built, open My computer, found a new volume E, explained the simple

The volume has been successfully built.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/7E/wKioL1UvYdLCCmbZAAIKFgsnkCs721.jpg "title=" Qq20150416150900.png "width=" "height=" 408 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" WIDTH:600PX;HEIGHT:408PX; "alt = "Wkiol1uvydlccmbzaaikfgsnkcs721.jpg"/>

Next, copy the contents of the serever01e disk into the E-disk of Server02.

Run the Server02 on the \\server01\e$, enter,

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/81/wKioL1UvdXTwjstIAAGQD7DTj9g604.jpg "title=" Qq20150416163215.png "width=" "height=" 375 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:600px;height:375px; "alt = "Wkiol1uvdxtwjstiaagqd7dtj9g604.jpg"/>

Copy this data to the new volume E

Copy Start

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/85/wKiom1UvdDKTtdSLAAEbVoyg3Fw363.jpg "title=" Qq20150416163422.png "width=" "height=" 392 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" WIDTH:600PX;HEIGHT:392PX; "alt = "Wkiom1uvddkttdslaaebvoyg3fw363.jpg"/>

Step Two: Change the computer name and IP address

Change the SERVER02 computer name and IP address, and shut down the Server01 (Server01 has crashed)

Change the computer name of Server02 to Server01, because if you turn the SERVER01 data upside down

Computer name mismatch may be caused by an error.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/85/wKiom1UvdfXTYgsRAAEZLzlJ7jw814.jpg "style=" width : 600px;height:779px; "title=" Qq20150416164114.png "width=" "height=" 779 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1uvdfxtygsraaezlzlj7jw814.jpg "/>

Change IP address to 192.168.1.101, restart

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/81/wKioL1Uvd0yiEuSEAAPnD-Tsisk119.jpg "style=" width : 600px;height:403px; "title=" Qq20150416164215.png "width=" "height=" 403 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvd0yieuseaapnd-tsisk119.jpg "/>

Step three: Install the ad DS Windows Server Backup component

Add roles and Features

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/81/wKioL1UveH6ib7SUAAHmqu74TDY629.jpg "style=" width : 600px;height:274px; "title=" Qq20150416164633.png "width=" "height=" 274 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uveh6ib7suaahmqu74tdy629.jpg "/>

Select Active directory Domain Services 650) this.width=650; "Src=" http://s3.51cto.com/wyfs02/M00/6B/86/ Wkiom1uvd-gjeoxfaaku2kmva98840.jpg "title=" Qq20150416164656.png "width=" "height=" 423 "border=" 0 "hspace=" 0 " Vspace= "0" style= "width:600px;height:423px;" alt= "wkiom1uvd-gjeoxfaaku2kmva98840.jpg"/>

Adding Windows Server Backup components

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/85/wKiom1Uvdyygpn2xAAKWdZODelY932.jpg "style=" width : 600px;height:414px; "title=" Qq20150416164710.png "width=" "height=" 414 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1uvdyygpn2xaakwdzodely932.jpg "/>

The Add Roles and Features wizard appears, install. The server is restarted after installation because the domain service is installed

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/81/wKioL1UveILBlghnAAKQvTcpu_Q780.jpg "style=" width : 600px;height:414px; "title=" Qq20150416164722.png "width=" "height=" 414 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uveilblghnaakqvtcpu_q780.jpg "/>

Step four: Raise the domain controller

Add a new forest, the root domain name can be different from the previous Server01 (the purpose is to generate the directory recovery model)

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/86/wKiom1UveOWxAtvIAAFDOzzjYg4585.jpg "style=" width : 600px;height:423px; "title=" Qq20150416165254.png "width=" "height=" 423 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1uveowxatviaafdozzjyg4585.jpg "/>

Fill in the password, next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/81/wKioL1UvejqiajQeAAH5CrGD_xs959.jpg "style=" width : 600px;height:426px; "title=" Qq20150416165328.png "width=" "height=" 426 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvejqiajqeaah5crgd_xs959.jpg "/>

NetBIOS is automatically generated here and the next step

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/86/wKiom1UveOawaj_gAAFbqaISqzI340.jpg "style=" width : 600px;height:429px; "title=" Qq20150416165355.png "width=" "height=" 429 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1uveoawaj_gaafbqaisqzi340.jpg "/>

The interface is ready to install, click Install

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/81/wKioL1UvejqTT1UCAAOVllClsxs109.jpg "style=" width : 600px;height:423px; "title=" Qq20150416165455.png "width=" "height=" 423 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvejqtt1ucaaovllclsxs109.jpg "/>

Step Six: Restart the server

After clicking Restart, press F8 to enter directory Recovery mode

Then click Tools > Right button on the right side of Server Manager

Select Windows Server Backup

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/86/wKiom1Uve8eA3SbYAAC-arKVddc956.jpg "style=" width : 600px;height:255px; "title=" Qq20150416170321.png "width=" "height=" 255 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1uve8ea3sbyaac-arkvddc956.jpg "/>

Recover data, select this server

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/82/wKioL1UvfRzB2dwCAAFMbdw1unU987.jpg "style=" width : 600px;height:448px; "title=" Qq20150416170356.png "width=" "height=" 448 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvfrzb2dwcaafmbdw1unu987.jpg "/>

The type of backup storage location is local drive

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/86/wKiom1Uve8jyCD4EAAFXSxxgmJU937.jpg "style=" width : 600px;height:420px; "title=" Qq20150416170416.png "width=" "height=" 420 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1uve8jycd4eaafxsxxgmju937.jpg "/>

The backup location is a new volume, that is, your newly added disk

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/82/wKioL1UvfR7A4zBqAAGjA25tyQA860.jpg "style=" width : 600px;height:435px; "title=" Qq20150416170427.png "width=" "height=" 435 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvfr7a4zbqaagja25tyqa860.jpg "/>

The server selected is server 01

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/86/wKiom1Uve_-RmDo0AAFDOuxanmU066.jpg "style=" width : 600px;height:462px; "title=" Qq20150416170445.png "width=" "height=" 462 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1uve_-rmdo0aafdouxanmu066.jpg "/>

Here's the next step

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/82/wKioL1UvfVTBzOglAAIZXRC9GRQ451.jpg "style=" width : 600px;height:444px; "title=" Qq20150416170454.png "width=" "height=" 444 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvfvtbzoglaaizxrc9grq451.jpg "/>

The recovery type of the data is the system state

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/86/wKiom1UvfAGyvmvEAAHmzfkpsJk107.jpg "style=" width : 600px;height:458px; "title=" Qq20150416170508.png "width=" "height=" 458 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1uvfagyvmveaahmzfkpsjk107.jpg "/>

Recover from original location

Next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/82/wKioL1UvfVbBmX7iAAJicUWzW2k324.jpg "style=" width : 600px;height:469px; "title=" Qq20150416170521.png "width=" "height=" 469 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1uvfvbbmx7iaajicuwzw2k324.jpg "/>

Recovery

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/86/wKiom1UvfAKQJH3kAAFlHevUH78717.jpg "style=" width : 600px;height:472px; "title=" Qq20150416170532.png "width=" "height=" 472 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1uvfakqjh3kaaflhevuh78717.jpg "/>

Step Seven: Restart the server to check for normal

Press ENTER

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/83/wKioL1UvjGDiio-ZAAE0Dlj0Svc904.jpg "title=" Qq20150416180811.png "width=" "height=" 392 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" WIDTH:600PX;HEIGHT:392PX; "alt = "Wkiol1uvjgdiio-zaae0dlj0svc904.jpg"/>

Check if NDS records are normal

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/87/wKiom1UvivHxNqEqAAJ1wCSFUZQ292.jpg "title=" Qq20150416180857.png "width=" "height=" 420 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:600px;height:420px; "alt = "Wkiom1uvivhxnqeqaaj1wcsfuzq292.jpg"/>

This article is from the "DNS Mystery (a)" blog, please be sure to keep this source http://qqcycto.blog.51cto.com/9992729/1633585

Restoring a Windows Server 2012R2 database