Is there anyone out there who has restored a local database to a database on a different server using the Restore Database interface? The books say you can but I have never tried it. I thought I would have to copy over the full backup (or transaction logs)to the other server and then restore locally. I assume that to do the restore to a different server we would have to have a drive letter mapped to that server and database location and then the restore database will work. I know that you can't backup to a network drive and I also thought the converse was true (that you couldn't restore across the network) but maybe I'm wrong. Please advise...
Bessebo
Bessebo