Last post Feb 27, 2006 03:58 AM by ErikVB
Feb 22, 2006 10:27 PM|Dan5150|LINK
How would I go about backing up a database from a remote server to my local server? I am using SQL Enterprise manager. I have tried DTS (import,export) but get errors. Any advice would be greatly appreciated.
Thanks in advance
Feb 23, 2006 12:01 PM|k4gdw|LINK
Feb 23, 2006 02:56 PM|Dan5150|LINK
Thanks k4gdw for the great step by step instructions. It worked perfectly.
I can now stop banging my head against the wall!
Feb 23, 2006 03:48 PM|k4gdw|LINK
Feb 23, 2006 05:29 PMfirstname.lastname@example.org|LINK
If your database is large, the fastest, easiest, least intrusive, and most robust solution is to just use the built in SQL Server Backup\Restore interface through the UI or through T-SQL Backup\Restore commands.
Feb 23, 2006 06:58 PM|Dan5150|LINK
Thanks Jason, the only problem is that my host will not allow the Backup\Restore so I must you DTS. I have no knowledge of Transitional SQL either. Thanks though!
Feb 27, 2006 03:58 AM|erikvb|LINK
Copying all data on a large db might cost you a lot of bandwith. My favorite tool is sql bundle from red gate (www.red-gate.com), which lets you synchronize your db structure and db contents. The developer toolkit contains
a command line utility you can schedule with windows task scheduler. Its a big expensive, but its a very flexible tool ;)