Link to home
Create AccountLog in
Avatar of Errol Farro
Errol FarroFlag for Aruba

asked on

Restore database to hosted server

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 ?
Avatar of Nakul Vachhrajani
Nakul Vachhrajani
Flag of India image

What's the error that you are facing? If the backup was taken from SQL Server 2005, there should be no issues in restoring it again on a SQL 2005 instance.
ASKER CERTIFIED SOLUTION
Avatar of Marten Rune
Marten Rune
Flag of Sweden image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
note: when you use ssms connected to the server and you select task restore database, it's looking for that file ON the server, not your local machine.