Re: Device on Mapped drive

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 14:09:17 -0500

Dude, there is a reason SQL doesn't support NAS and mapped drives. You have
pretty much taken a HUGE data integrity feature and tossed it out the
window. You might want to rethink this idea. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jack Jones" <jj@u.net> wrote in message
news:%233MfZTdBEHA.1452@TK2MSFTNGP09.phx.gbl...
> Hey,
> I resolved this myself, maybe some one else will find it usful.
> By default MSSQL does not allow mapped drives for storing data
> devices/backup devices/files etc. however,  when you step up to NAS
storage
> SQL can accomadate, this is done by using the dbcc trace flag 1807, this
> turns on the ability to dump/load/restore databases from/to mapped
drives -
> I just tried it and it works fine!!
>
> BTW, you will also need to allow the logon service for MSSQLSERVER access
to
> the network share, this caught me out also - but works fine now -thanks
>
> Jack
>
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote in
> message news:eURwZAdBEHA.2800@tk2msftngp13.phx.gbl...
> > Jack,
> >
> > No, mapped drives are not supported. You will have to expand local
> storage.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > Solid Quality Learning
> > More than just Training
> > www.SolidQualityLearning.com
> >
> > "Jack Jones" <jj@u.net> wrote in message
> > news:ebBox6cBEHA.2576@TK2MSFTNGP11.phx.gbl...
> > > Hey,
> > > Does anyone know if it is possible to load a database from a mapped
> drive?
> > I
> > > am running out of space on my SQL2000 server but one of my other
servers
> > has
> > > a couple of  TB's free. I tried mapping a drive to the free drive and
> then
> > > tried to verify the database file I need to load, but SQL does
reconise
> > > drives other than local drives,
> > >
> > > Has anyone any ideas?
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Issues creating a new failover cluster on the same server
    ... G:\Microsoft SQL Server\MSSQL.1 ... CHNSQL04 Cluster Group ... Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running ...
    (microsoft.public.sqlserver.clustering)
  • Re: Replacing SBS2000 - Need Guidance
    ... Actually this has changed they will support the SQL on the SBS 2008 itself. ... Installation of SQL to the SBS2008 itself is not supported. ... If the total required capacity could be easily covered by HDD*2 I would simply install a single RAID5 array consisting of 3 drives in array plus hotspare. ...
    (microsoft.public.windows.server.sbs)
  • Re: Filegroup recommendation
    ... >>> filegroup, and the transaction logs into their own filegroup. ... >>> and multiple hard drives. ... In a multiple-processor system, SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Worst monday of my life - please help...
    ... If that's the case, restoring the SQL ... but it finally did install with a few hiccups. ... >> or just leave the mirrored drives in the server on the secondary IDE ... I decided it was time to re-add the mirror. ...
    (microsoft.public.windows.server.sbs)
  • Re: N+1 Configuration
    ... Jasper Smith (SQL Server MVP) ... But looking in the cluster admin tool, ... mounting all other drives under that drive ...
    (microsoft.public.sqlserver.clustering)