Author Posts

January 18, 2018 at 10:06 am

I am running this line in order to restore a Database from a backup file which is stored locally.

Restore-SqlDatabase -ServerInstance "Server\Instance" -Database "ProdDB" -BackupFile "C:\Temp\Prod.bak"

The error that i am getting is–

Restore-SqlDatabase : Failed to connect to server Triage7204-1\Triage7204-1.
At line:1 char:1
+ Restore-SqlDatabase -ServerInstance "Triage7204-1\Triage7204-1" -Data ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Restore-SqlDatabase], ConnectionFailureException
+ FullyQualifiedErrorId : Microsoft.SqlServer.Management.Common.ConnectionFailureException,Microsoft.SqlServer.Management.PowerShell.RestoreSqlDatabaseCommand.

I have enabled TCP/IP & Named Pipes for client and even checked with starting all services related to my sql server but nothing helped.