Friday, February 10, 2012

Changing data directory

How to change data directory for all databeses including system ones
(master, temdb etc.)
Can't do it by update sysfiles because (I can't figure why) this object
cannot be modified -
Regards
Piotr
Inidivisual database names can be changed via detaching and attaching,
chaging the path of the system databases needs a registry hack for that,
because the service will start them.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\Parameters
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"piotr" <ksswd@.poczta.fm> schrieb im Newsbeitrag
news:eqXDppacFHA.2736@.TK2MSFTNGP12.phx.gbl...
> How to change data directory for all databeses including system ones
> (master, temdb etc.)
> Can't do it by update sysfiles because (I can't figure why) this object
> cannot be modified -
> Regards
> Piotr
>
|||In the registry I can only change master database path and I can't detach
model, tempdb nor msdb databases
Piotr
Uytkownik "Jens Smeyer"
<Jens@.Remove_this_For_Contacting.sqlserver2005.de> napisa w wiadomoci
news:%23YK9K2acFHA.2756@.tk2msftngp13.phx.gbl...
> Inidivisual database names can be changed via detaching and attaching,
> chaging the path of the system databases needs a registry hack for that,
> because the service will start them.
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\Parameters
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "piotr" <ksswd@.poczta.fm> schrieb im Newsbeitrag
> news:eqXDppacFHA.2736@.TK2MSFTNGP12.phx.gbl...
>
|||hi Piotr,
piotr wrote:
> In the registry I can only change master database path and I can't
> detach model, tempdb nor msdb databases
>
please have a look at http://support.microsoft.com/kb/224071/EN-US/
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Finally made it, thanks a lot.
Uytkownik "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> napisa w
wiadomoci news:3has31Ffpu70U1@.individual.net...
> hi Piotr,
> piotr wrote:
> please have a look at http://support.microsoft.com/kb/224071/EN-US/
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

No comments:

Post a Comment