[thelist] create/restore an MSSQL database from a local .bak file

Joel D Canfield joel at streamliine.com
Tue Aug 7 14:39:09 CDT 2007


> I assume there is a way to get around this

I don't think so.

MSSQL is looking for some flavor of 'local' file, even over a network
(mapped drive or, I believe, UNC path) but not over the internet.

Is the server inaccessible so that putting the file there isn't an
option? If so, DTS will let you copy/sync dbs over virtually any
connection, but it ain't as tidy as restoring from backup.

joel



More information about the thelist mailing list