Questions

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

Tags:
+
0 Votes
Locked

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

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.