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 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