Networks

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

Question

Locked

How do I make a copy of a database on a remote SQL server?

By jon2367 ·
I'm using SQL 2005 Express. I tried to backup the entire database using Server Mgmt Studio Express, but the paths it refers to are the local paths on the remote server. And as a result the backup fails. What I'm trying to do is to create a copy of the live database, so I can work on the copy without fear of corrupting or accidently deleting something on the live database.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Easiest solution

by Shellbot In reply to How do I make a copy of a ...

Back up the database on the local server.
(create a new backup set, change the path to path of your choosing)

Copy the backup file to your remote server, and restore the database.

Collapse -

Tool for remote backups

by AlexGreen86 In reply to How do I make a copy of a ...

This tool http://sqlbackupandftp.com/ could help you in this issue. It allows you to create a backup and send it to a remote server in your LAN or via FTP. You can also compress your backup before sending it.

Related Discussions

Related Forums