Preparing to use Windows PowerShell cmdlets with Data Protection for SQL Server

Data Protection for SQL Server includes a set of Windows PowerShell cmdlets to help you manage Data Protection for SQL Server components in your environment.

1. Log on to the system as an administrator.
2. From a Windows PowerShell command prompt, issue the following command:

   set-executionpolicy remotesigned

3. Import the Windows PowerShell modules from the FlashCopyManager folder:
   • FmModuleSQL.dll
   • FmModuleMMC.dll
   From the Windows PowerShell command prompt, use your administrator credentials to import modules as follows:
   1. Browse to the FlashCopyManager folder.
   2. Enter the following commands:

      import-module .\FmModuleSQL.dll
      import-module .\FmModuleMMC.dll

   3. (Optional) To use the cmdlets in these modules any time that you start Windows PowerShell, add the following lines to your profile:

        $path = (get-itemproperty -path "HKLM:\SOFTWARE\IBM\TDPSql\
      currentversion\mmc" -ea SilentlyContinue).path
      if ($null -ne $path)
      {
      dir "$path\fmmodule*.dll" | select -expand fullname | import-module
      -force -Global
      }