March 21, 2011 at 10:33 am
We need to backup our SQL server 2005 to another machine over the internet.
I've tried to do a backup but didn’t find any option to backup to an external server.
I've tried to do an export but I get the following error:
“Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported.”
But my version on the source server is: 9.00.4035.00 and on the destination server: 9.00.4262.00
How can I backup / Export my DB (including stored procedures) to another Server /DB over the internet.
March 21, 2011 at 10:37 am
backup the database as normal,
find the .bak file and copy it or ftp it to the other server.
you also may want to zip the .bak with a password for security.
restore the .bak on the remote server.
March 21, 2011 at 10:40 am
Thank you for your quick reply.
However I missed out on the fact that we need to do this on a daily basis.
Therefore set up an automated process
March 21, 2011 at 10:46 am
then either use SSIS, just set up the external server as a destination so you won't actaully store the packages there so you shouldn't get the error.
or,
use a form of replication , Snapshot may work for you. or possibly transactional.
depending on your setup, I would pick replication as it can be a lot less hassle to setup
March 21, 2011 at 11:06 am
A few scripts that might help: http://www.sqlservercentral.com/search/?q=copy+backup+to+server&t=s
March 22, 2011 at 5:00 am
Hi Lars
The below links could be of some help to you
http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/69644/
http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/69022/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply