Lesson 3: Configuring Log Shipping Mode in VS .NET

Generating PDF417 in VS .NET Lesson 3: Configuring Log Shipping Mode

Lesson 3: Configuring Log Shipping Mode
PDF417 Encoder In .NET
Using Barcode drawer for Visual Studio .NET Control to generate, create PDF417 image in .NET framework applications.
www.OnBarcode.com
PDF417 Scanner In VS .NET
Using Barcode recognizer for VS .NET Control to read, scan read, scan image in .NET applications.
www.OnBarcode.com
Figure 18-8 Selecting Standby Mode
Make Bar Code In .NET
Using Barcode creator for VS .NET Control to generate, create barcode image in Visual Studio .NET applications.
www.OnBarcode.com
Bar Code Scanner In .NET
Using Barcode scanner for VS .NET Control to read, scan read, scan image in Visual Studio .NET applications.
www.OnBarcode.com
5. When you select Standby Mode, the Disconnect Users In The Database When Restoring Backup option becomes available. The RESTORE command requires exclusive access to the database, so this option is necessary to specify how you want to handle connected users when the restore process begins. The default is to leave users connected to the database, which will cause the restore job to fail. If you select the Disconnect Users In The Database When Restoring Backups check box, the restore will force users off the database after a small delay. 6. Click OK to save your changes and close the Secondary Database Settings dialog box. 7. Click OK to close the Database Properties dialog box for the primary database.
Generating PDF417 In C#.NET
Using Barcode creation for Visual Studio .NET Control to generate, create PDF417 image in Visual Studio .NET applications.
www.OnBarcode.com
PDF-417 2d Barcode Drawer In Visual Studio .NET
Using Barcode generator for ASP.NET Control to generate, create PDF 417 image in ASP.NET applications.
www.OnBarcode.com
BEST PRACTICES
Generating PDF-417 2d Barcode In VB.NET
Using Barcode printer for .NET framework Control to generate, create PDF 417 image in Visual Studio .NET applications.
www.OnBarcode.com
Creating Barcode In .NET Framework
Using Barcode generation for Visual Studio .NET Control to generate, create barcode image in VS .NET applications.
www.OnBarcode.com
Scalability
PDF417 Generator In .NET
Using Barcode printer for .NET framework Control to generate, create PDF-417 2d barcode image in .NET framework applications.
www.OnBarcode.com
Code128 Creator In Visual Studio .NET
Using Barcode creator for .NET Control to generate, create Code 128 Code Set B image in VS .NET applications.
www.OnBarcode.com
Use Standby mode when you are using log shipping for scalability reasons.
Drawing Matrix Barcode In .NET
Using Barcode generation for .NET Control to generate, create Matrix 2D Barcode image in Visual Studio .NET applications.
www.OnBarcode.com
Making Identcode In .NET Framework
Using Barcode maker for .NET framework Control to generate, create Identcode image in .NET applications.
www.OnBarcode.com
Quick Check
Encode UCC - 12 In None
Using Barcode creation for Microsoft Excel Control to generate, create UPC A image in Microsoft Excel applications.
www.OnBarcode.com
Draw Data Matrix ECC200 In VB.NET
Using Barcode maker for .NET framework Control to generate, create ECC200 image in .NET framework applications.
www.OnBarcode.com
1. True or false: Standby mode allows users and applications to access and modify the secondary database. 2. True or false: The default setting for Standby mode is to leave users connected to the database when the restore backup operation begins.
Creating Bar Code In VB.NET
Using Barcode creator for .NET framework Control to generate, create bar code image in .NET framework applications.
www.OnBarcode.com
Generating GS1-128 In VS .NET
Using Barcode creation for ASP.NET Control to generate, create EAN / UCC - 14 image in ASP.NET applications.
www.OnBarcode.com
18
Data Matrix ECC200 Generator In .NET
Using Barcode printer for Reporting Service Control to generate, create Data Matrix 2d barcode image in Reporting Service applications.
www.OnBarcode.com
EAN 128 Drawer In None
Using Barcode generator for Software Control to generate, create UCC.EAN - 128 image in Software applications.
www.OnBarcode.com
Implementing Log Shipping
Decode QR Code JIS X 0510 In None
Using Barcode reader for Software Control to read, scan read, scan image in Software applications.
www.OnBarcode.com
Code 128A Encoder In Objective-C
Using Barcode drawer for iPhone Control to generate, create Code 128 Code Set C image in iPhone applications.
www.OnBarcode.com
Quick Check Answers
1. False. Standby mode puts the secondary database in read-only access mode. No database updates are allowed. 2. True. This default setting leaves user connected to the database, which will cause the restore job to fail.
PRACTICE
Configuring Standby Mode
In these practice exercises, you will review the mode of the previous log shipping configuration and create a new standby configuration.
Practice 1: Review the Secondary Database Configuration
In this practice, you will review the log shipping mode of the LSTesting2 database. 1. In SSMS, select the LSTesting database. 2. Right-click the LSTesting database and choose Properties. 3. Select the Transaction Log Shipping page. 4. In the Secondary Databases section of the log shipping configuration, click the browse button ( ) next to the LSTesting2 database. 5. Click the Restore Transaction Log tab. 6. Verify that the No Recovery Mode option is selected. 7. Click Cancel to close the Secondary Database Settings dialog box, and then click Cancel to close the Database Properties window. 8. Select the LSTesting2 database in Object Explorer. 9. Verify that the database LSTesting2 status is (Restoring ). 10. Click New Query on the toolbar. 11. In the New Query window, type the following query:
SELECT * FROM LSTesting2.HumanResources.Department
12. Click Execute on the toolbar. 13. Verify that the server returns the following error message:
Msg 927, Level 14, State 2, Line 1 Database 'LSTesting2' cannot be opened. It is in the middle of a restore.
14. Close the New Query window. 15. Click No to discard the changes in the New Query window.
Lesson 3: Configuring Log Shipping Mode
Practice 2: Delete the Secondary Database Configuration
In this practice, you will delete the log shipping configuration of the LSTesting2 database. 1. In SSMS, select the LSTesting database. 2. Right-click the LSTesting database and choose Properties. 3. Select the Transaction Log Shipping page. 4. In the Secondary Server Instances And Databases section, select the secondary database and click Remove. 5. In the confirmation message, click Yes to confirm that you want to remove the secondary database. 6. Click OK to close the Database Properties window and save the configuration. 7. In the Save Log Shipping Configuration window, click Close. 8. Select the LSTesting2 database in Object Explorer. 9. Right-click the LSTesting2 database and choose Delete. 10. In the Delete Object window, click OK to confirm the deletion.
Practice 3: Create a Standby Log Shipping Configuration
In this practice, you will create a new standby log shipping configuration. 1. In SSMS, select the LSTesting database. 2. Right-click the LSTesting database and choose Properties. 3. Select the Transaction Log Shipping page. 4. Click Add below Secondary Server Instances And Databases. 5. Click Connect; then use the appropriate credentials to connect to the secondary server. If you are using the same instance as the one that contains your primary database, connect to the default server. Click Connect to establish the connection. 6. In the Secondary Database text box, name the database LSTesting2. 7. Select Yes, Generate A Full Backup Of The Primary Database And Restore It Into The Secondary Database. 8. Click Restore Options, and type the C:\LogShipPractice\Database path for both the database and log folders. Click OK. 9. Click the Copy Files tab.
Copyright © OnBarcode.com . All rights reserved.