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

[Jason Handby]

> I assume there is a way to
> get around this (short of copying the file to the database 
> server) - can
> anyone shed any light on this for me?

Unfortunately, no -- it's the server itself that restores a backup, so
the file has to be accessible to the server (either on the server
itself, or a network drive the server can see, etc.)

If you can't upload the file, you could restore it into an instance of
SQL Server running on your PC, and then use DTS to copy the database to
the live server...?


Jason