Tag Archives: script

PowerShell script error – File not digitally signed : FIX

Today I was working on building PowerShell script to establish SQL Server Database Mirroring. To start with PowerShell, I tried to execute my first built of PowerShell Script on SQLPS, I received the following error.File C:\Temp\Mirroring\Script\DBMirrroringSetup.ps1 cannot be loaded. The file C:\Temp\Mirroring\Script\DBMirrroringSetup.ps1 is not digitally signed. The script will not execute on the system. Please [...]

SQL Script to find Expected Finish TIME for current running BACKUP / RESTORE

When SQL Server backup / Restore will be finished ? How long it will take to complete this backup or Restore ? What is expected time when SQL Server BACKUP / RESTORE will be finished? This question is asked by lot of time by DBA’s and we always answer them either based on past history [...]