Hello all !!! I am trying to transfer my ASP website but I find difficulties in restoring the .bak file of the MS SQL database, due to security reasons. Does Winhost support restoring a database from a .bak file that is exported from another host? Any help would be greatly appreciated!!! Thanks!!
Unfortunately you cannot use the backup/restore feature directly off our SQL server. It will require that you have SA rights to the SQL server which can compromise the security of all databases. I suggest you perform an Import procedure from yoru local machine to our SQL server. Try using this kb article for the guidelines. http://support.Winhost.com/KB/a674/how-to-backup-sql-2008-database-using-visual-web-developer.aspx
You do not have to have SA rights to restore a DB backup. Every other hoster I can think of allows you to do this, and we allow it internally by granting specific rights to users to specific DB's. If you only support backing up a database via the VS tools, and don't allow the ability to upload data and structure, you will find that you will loose a lot of customers, or not get them in the first place. Bob
What is the error message you are getting when you run Visual Studio? What process of the script are you ing? Are you having problems running the script against your local databse or are you having problems running the script against our server to restore the database to our SQL server?
The "Copy Database Wizard" is also available in SQL Management Studio, and you can move data and structure using that tool.
Hi I am trying to restore a db from another website. Please can someone explain how I do this as there is. 1. No restore facility (that i could find) 2. and the "Copy Database Wizard" in SQL Management Studio throws and error (Object reference not set to an instance of an object) Thank you.
You'll have to run the database publishing wizard. Try looking at this kb article. http://support.Winhost.com/KB/a694/publishing-your-sql-2008-database-to-Winhost-sql-2008-server.aspx