attaching databases

I has some databases on a different pc. sql is running on my pc. i want to
attach those databse to my sql server but when i go to attach them i can
only see my c: drive and not the whole network. can this be done?You won't be able to attach them if they are already attached to A.N.Other
instance of SQL Server.
Why not BACKUP / RESTORE the database onto your P.C.
Also see
http://www.mssqlserver.com/faq/general-networkdrives.asp
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"matta25" <matta125work@.hotmail.com> wrote in message
news:eZElhjRiDHA.2452@.TK2MSFTNGP10.phx.gbl...
> I has some databases on a different pc. sql is running on my pc. i want
to
> attach those databse to my sql server but when i go to attach them i can
> only see my c: drive and not the whole network. can this be done?
>|||the database have been dettached form a different pc and are just sitting
there waiting to be attach to a different pc. i need these database on this
network drive for secruity issues.
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:%23PGTS%23RiDHA.3032@.tk2msftngp13.phx.gbl...
> You won't be able to attach them if they are already attached to A.N.Other
> instance of SQL Server.
> Why not BACKUP / RESTORE the database onto your P.C.
> Also see
> http://www.mssqlserver.com/faq/general-networkdrives.asp
>
> --
> --
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
> "matta25" <matta125work@.hotmail.com> wrote in message
> news:eZElhjRiDHA.2452@.TK2MSFTNGP10.phx.gbl...
> > I has some databases on a different pc. sql is running on my pc. i
want
> to
> > attach those databse to my sql server but when i go to attach them i can
> > only see my c: drive and not the whole network. can this be done?
> >
> >
>|||Your local SQL Server might have permission problem accessing the other pc.
Why don't you copy the database files over to the local pc first?
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"matta25" <matta125work@.hotmail.com> wrote in message
news:uejdnCSiDHA.620@.TK2MSFTNGP11.phx.gbl...
> the database have been dettached form a different pc and are just sitting
> there waiting to be attach to a different pc. i need these database on
this
> network drive for secruity issues.
> "Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
> news:%23PGTS%23RiDHA.3032@.tk2msftngp13.phx.gbl...
> > You won't be able to attach them if they are already attached to
A.N.Other
> > instance of SQL Server.
> > Why not BACKUP / RESTORE the database onto your P.C.
> >
> > Also see
> >
> > http://www.mssqlserver.com/faq/general-networkdrives.asp
> >
> >
> > --
> > --
> >
> > Allan Mitchell (Microsoft SQL Server MVP)
> > MCSE,MCDBA
> > www.SQLDTS.com
> > I support PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
> >
> > "matta25" <matta125work@.hotmail.com> wrote in message
> > news:eZElhjRiDHA.2452@.TK2MSFTNGP10.phx.gbl...
> > > I has some databases on a different pc. sql is running on my pc. i
> want
> > to
> > > attach those databse to my sql server but when i go to attach them i
can
> > > only see my c: drive and not the whole network. can this be done?
> > >
> > >
> >
> >
>|||Basically, SQL Server doesn't support database files on other than local drives, as Allan mentioned.
You can also read below KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;304261
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"matta25" <matta125work@.hotmail.com> wrote in message news:uejdnCSiDHA.620@.TK2MSFTNGP11.phx.gbl...
> the database have been dettached form a different pc and are just sitting
> there waiting to be attach to a different pc. i need these database on this
> network drive for secruity issues.
> "Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
> news:%23PGTS%23RiDHA.3032@.tk2msftngp13.phx.gbl...
> > You won't be able to attach them if they are already attached to A.N.Other
> > instance of SQL Server.
> > Why not BACKUP / RESTORE the database onto your P.C.
> >
> > Also see
> >
> > http://www.mssqlserver.com/faq/general-networkdrives.asp
> >
> >
> > --
> > --
> >
> > Allan Mitchell (Microsoft SQL Server MVP)
> > MCSE,MCDBA
> > www.SQLDTS.com
> > I support PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
> >
> > "matta25" <matta125work@.hotmail.com> wrote in message
> > news:eZElhjRiDHA.2452@.TK2MSFTNGP10.phx.gbl...
> > > I has some databases on a different pc. sql is running on my pc. i
> want
> > to
> > > attach those databse to my sql server but when i go to attach them i can
> > > only see my c: drive and not the whole network. can this be done?
> > >
> > >
> >
> >
>