I want to restore one database from the production system which is in the remote area to my local system.
I have taken a backup in SQL 2008 and trying to restore the same in the local system using SSMS 2008. But it is showing the below error....
A transport level error has occured when receiving results from server(provider: TCP provider, error:0 The specified network name is no longer available) Microsoft SQL server Error:64
Any help will be appreciated.