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 ?
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 ?
Microsoft SQL Server 2005
Last Comment
Aaron Tomosky
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.