I am using an SQL hosted service which runs Microsoft SQL Server 2005
To access the hosted server I use Microsoft SQL 2012 Server Management Studio.
Today I accidentally cleared all the data on hosted server and then asked the provider to restore the database for me.
The provider provided me with a .BAK file.
I have tried many suggestions found on blogs to restore the file from Microsoft SQL 2012 Server Management Studio to hosted SQL Server 2005.
Any suggestions ?