Question Locked

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

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

3 replies

by shellbot

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.

by alexgreen86

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.

This discussion is closed to new replies.