SQL Server AlwaysOn High Availability Configuration VII: New database

7.  New Database

7.1 in SQL01 server open SQL Studio connect to SQL01, right-select "New Database"

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/73/2C/wKiom1X23peiNRjpAAFzCzfBM0k017.jpg "title=" 1. PNG "alt=" wkiom1x23peinrjpaafzczfbm0k017.jpg "/> 7.2 Input database name

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/73/28/wKioL1X24N_REvujAAItQTducN0253.jpg "title=" 2.png " alt= "Wkiol1x24n_revujaaitqtducn0253.jpg"/>

7.3 On the "Options" page, select the recovery mode as "full" and click "OK"

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/73/2C/wKiom1X23rrT_frtAAIAElQzU5k120.jpg "title=" 3.png " alt= "Wkiom1x23rrt_frtaaiaelqzu5k120.jpg"/>

7.4 The database is created as follows:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/73/28/wKioL1X24Pzhr9hUAAFLKW9iiig006.jpg "title=" 4.png " alt= "Wkiol1x24pzhr9huaaflkw9iiig006.jpg"/>

7.5 Right-click "DB01"-"Tasks"-"Backup"

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/73/2C/wKiom1X23tXRYDWTAALPKnjvKic720.jpg "title=" 5.png " alt= "Wkiom1x23txrydwtaalpknjvkic720.jpg"/>

7.6 Click "OK"

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/73/28/wKioL1X24RuS2A-tAAGZlxTm9u8014.jpg "title=" 6.png " alt= "Wkiol1x24rus2a-taagzlxtm9u8014.jpg"/>

7.7 Click "OK"

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/73/2C/wKiom1X23vPjZSbeAABrLvnmkGA587.jpg "title=" 7.png " alt= "Wkiom1x23vpjzsbeaabrlvnmkga587.jpg"/>

This article is from the "Huang Jinhui column" blog, be sure to keep this source http://stephen1991.blog.51cto.com/8959108/1694754

SQL Server AlwaysOn High Availability Configuration VII: New database