[thelist] create/restore an MSSQL database from a local .bak file
Tab Alleman
talleman at Lumpsum.com
Tue Aug 7 14:37:31 CDT 2007
Did you try selecting the "From Device" option in the General tab of the Restore Database wizard?
Then Select Devices... Disk... browse to your .bak file.
> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Sarah Adams
> Sent: Tuesday, August 07, 2007 3:17 PM
> To: thelist
> Subject: [thelist] create/restore an MSSQL database from a local .bak
> file
>
>
> I have googled unsuccessfully for this, and the MSSQL help
> documents are
> not getting me anywhere. I am setting up a local development
> copy of a
> client's site and database. I have a .bak file sent to me by
> the client
> in order for me to have a copy of the MSSQL database. Unfortunately,
> when I go to the Restore Database wizard in SQL Server Enterprise
> Manager, it only allows me to select .bak files saved directly on the
> database server, not from my local machine. 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?
>
> TIA
>
> --
> sarah adams
> web developer & programmer
> portfolio: http://sarah.designshift.com
> blog: http://hardedge.ca
> --
>
> * * Please support the community that supports you. * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>
More information about the thelist
mailing list