Monday, March 12, 2012

Restore backup to remote hosted server

Sorry if this is elementary, but I have searched and cannot find an answer.

I have a backup file of a sql server 2000 database. I want to restore it to a remote hosted sql server 2005.

Using sql server management studio, it seems to me that I cannot access the files stored local on my computer.

Does anybody have a solution?

What is the best way to deploy my backup file to the remote server?

Thanks for any suggestions!

I'm afraid you have to copy the backup file to the local disk on the SQL2005 server.

No comments:

Post a Comment