Monday, March 19, 2012

how to detach master db

Hi,
how do I detach master db?
what are the steps?What for?
AMB
"Britney" wrote:

> Hi,
> how do I detach master db?
> what are the steps?
>
>|||Hi Britney,
Look at this thread for common detaching.
http://groups.google.de/groups?q=ti...phx.gbl&rnum=1
But most of them wont work with the master db. Wonder why you want to
attach / detach the master db ?
HTH, Jens Smeyer.
http://www.sqlserver2005.de
--
"Britney" <britneychen_2001@.yahoo.com> schrieb im Newsbeitrag
news:uLDsr1ERFHA.904@.tk2msftngp13.phx.gbl...
> Hi,
> how do I detach master db?
> what are the steps?
>|||all I want to ask is if it's possible to do so.
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:enPchDFRFHA.1416@.TK2MSFTNGP10.phx.gbl...
> Hi Britney,
> Look at this thread for common detaching.
>
http://groups.google.de/groups?q=ti...phx.gbl&rnum=1
> But most of them wont work with the master db. Wonder why you want to
> attach / detach the master db ?
> HTH, Jens Smeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Britney" <britneychen_2001@.yahoo.com> schrieb im Newsbeitrag
> news:uLDsr1ERFHA.904@.tk2msftngp13.phx.gbl...
>|||You have to change the start paramters for the SQL Server to do so:
-dD:\MSSQL7\data\master.mdf <--
-eD:\MSSQL7\log\ErrorLog
-lD:\MSSQL7\data\mastlog.ldf <--
for more details look here:
rl]
HTH, Jens Suessmeyer.
[url]http://www.sqlserver2005.de" target="_blank">http://support.microsoft.com/Defaul...qlserver2005.de
--
"Britney" <britneychen_2001@.yahoo.com> schrieb im Newsbeitrag
news:%23Cdc6LFRFHA.612@.TK2MSFTNGP14.phx.gbl...
> all I want to ask is if it's possible to do so.
> "Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in
> message news:enPchDFRFHA.1416@.TK2MSFTNGP10.phx.gbl...
> http://groups.google.de/groups?q=ti...phx.gbl&rnum=1
>

No comments:

Post a Comment