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

[Tab Alleman]

I assume you're not allowed/able to map a drive to your local box from the sql server.   

This is untested, but you could try the RESTORE command in QA with a UNC path to your local box:

RESTORE DATABASE TestDB 
   FROM DISK = '\\mybox\myfolder\Northwind.bak'

dunno, grasping straws...

> -----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 4:03 PM
> To: thelist at lists.evolt.org
> Subject: Re: [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
> > 
> > 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.
> 
> I tried this, but when I click "Add..." I get a dialog that 
> only allows
> me to browse within the database server's drive, nothing local.
> 
> -- 
> 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 ! 
>