May 12, 2010 at 7:16 pm
I am switching hosting companies. I would like to back up my sql database and at some point restore it to new hosting service.
My DB is SQL 2008. I am using SQL Server Management Studio Express.
How do I do this?
I tried copying the remote database to my current sql instance but I get this error:
"the destination server cannot be a sql server 2005 or later express instance."
Thank you,
Norbert
May 12, 2010 at 8:54 pm
If you run a backup on the server, it will land on the host companies drive. They ought to be able to, or you can, file copy that down.
If not, I'd look to script all objects from the db, and then export all data from the server to flat files and import it on the new server.
You can pick up SS2K8 dev for $50 and put that on your machine and then use SSIS to move the db with the transfer db task
May 12, 2010 at 10:32 pm
Thank you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply