Lesson 6: Configuring and Managing Log Shipping

Activity 7: Adding a New Data File to a Log Shipped Database

Solution:

1. Create a new folder named NewDataFile in the C drive on the primary instance, DPLPR, and the secondary instance, DPLHA.
2. Execute the following query at the primary instance, DPLPR, to add the new data file to the Sales database:

   USE [master]

   GO

   ALTER DATABASE [Sales] ADD FILE

   (

   NAME = N'SalesData1',

   FILENAME = N'C:\NewDataFile\SalesData1.ndf' ,

   SIZE = 8192KB ,

   FILEGROWTH = 65536KB

   ) TO FILEGROUP [PRIMARY]

   GO

   To verify that the file has been created, run the following query on DPLPR:

   use [Sales]

   GO

   SELECT

   Name,physical_name

   FROM sys.database_files

   You should get the following output:

Figure 6.46: Verifying that the file has been created

Activity 8: Troubleshooting a Problem – Could Not Find a Log Backup File that Could be Applied to Secondary Database 'Sales'

Solution:

Finding the Error Details

1. Check the restore...