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.
