moving master db to another location

Hi ,
My master's .mdf & .ldf file is currently in D:\ drive and if i want it to
be changed to E:\ drive how can i do that ?
i am not able to detach it nor change the file name from EM ..
appreciate ur advise
tks & rdgs
Message posted via http://www.droptable.comHi,
http://www.databasejournal.com/feat...cle.php/3379901
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
--|||Hi
http://support.microsoft.com/defaul...kb;en-us;224071
"maxzsim via droptable.com" <u14644@.uwe> wrote in message
news:60f711ff30917@.uwe...
> Hi ,
> My master's .mdf & .ldf file is currently in D:\ drive and if i want it to
> be changed to E:\ drive how can i do that ?
> i am not able to detach it nor change the file name from EM ..
> appreciate ur advise
> tks & rdgs
> --
> Message posted via http://www.droptable.com|||... and for SQL Server 2005 there is a section 'Moving System Databases' on
BOL.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/72bb62ee-9602-4f71-be51-c466
c1670878.htm
Ben Nevarez, MCDBA, OCP
Database Administrator
"maxzsim via droptable.com" wrote:

> Hi ,
> My master's .mdf & .ldf file is currently in D:\ drive and if i want it t
o
> be changed to E:\ drive how can i do that ?
> i am not able to detach it nor change the file name from EM ..
> appreciate ur advise
> tks & rdgs
> --
> Message posted via http://www.droptable.com
>|||Oops, I just notice that the original post says 'EM' so I guess it is not
SQL Server 2005 :-)
Ben Nevarez, MCDBA, OCP
Database Administrator
"Ben Nevarez" wrote:
[vbcol=seagreen]
> ... and for SQL Server 2005 there is a section 'Moving System Databases' o
n
> BOL.
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/72bb62ee-9602-4f71-be51-c4
66c1670878.htm
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "maxzsim via droptable.com" wrote:
>|||Hi ,
I was trying to move both msdb & model using the following steps :
1. addede the parameter -T3608
2a. use master
go
sp_detach_db 'msdb'
go
2b. use master
go
sp_detach_db 'model'
go
3. stop & restart SQL SERVER
4. i could not restart the SQL SERVER Service from the SQL Server Service
Manager as it keeps restarting & stopping by itself
any way i can get it to work now ?
tks & rdgs
Uri Dimant wrote:[vbcol=seagreen]
>Hi
>http://support.microsoft.com/defaul...kb;en-us;224071
>
>[quoted text clipped - 6 lines]
Message posted via http://www.droptable.com|||Hi ,
I got the 18502 error (looked into past posting seems no solution)
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 5/29/2006
Time: 6:11:53 PM
User: N/A
Computer: ALTIRISSERVER
Description:
18052 :
Error: 823, Severity: 24, State: 2.
and
from the SQL Error Log i got the followings :
2006-05-29 18:11:51.41 server Microsoft SQL Server 2000 - 8.00.760 (Inte
l
X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
2006-05-29 18:11:51.42 server Copyright (C) 1988-2002 Microsoft
Corporation.
2006-05-29 18:11:51.42 server All rights reserved.
2006-05-29 18:11:51.42 server Server Process ID is 2268.
2006-05-29 18:11:51.42 server Logging SQL Server messages in file 'd:\ms
sqlserver\MSSQL\log\ERRORLOG'.
2006-05-29 18:11:51.42 server SQL Server is starting at priority class
'high'(2 CPUs detected).
2006-05-29 18:11:51.44 server Performance monitor shared memory setup
failed: -1
2006-05-29 18:11:51.53 server SQL Server configured for thread mode
processing.
2006-05-29 18:11:51.53 server Using dynamic lock allocation. [2500] L
ock
Blocks, [5000] Lock Owner Blocks.
2006-05-29 18:11:51.57 server Attempting to initialize Distributed
Transaction Coordinator.
2006-05-29 18:11:52.60 spid4 Starting up database 'master'.
2006-05-29 18:11:53.85 spid4 Error: 823, Severity: 24, State: 2.
2006-05-29 18:11:53.85 spid4 Cannot recover the master database. Exiting
.
Any solutions besidess re-install ?
tks & rdgs
maxzsim wrote:[vbcol=seagreen]
>Hi ,
> I was trying to move both msdb & model using the following steps :
>1. addede the parameter -T3608
>2a. use master
> go
> sp_detach_db 'msdb'
> go
>2b. use master
> go
> sp_detach_db 'model'
> go
>3. stop & restart SQL SERVER
>4. i could not restart the SQL SERVER Service from the SQL Server Service
>Manager as it keeps restarting & stopping by itself
>any way i can get it to work now ?
>tks & rdgs
>
>[quoted text clipped - 4 lines]
Message posted via http://www.droptable.com|||Hi ,
further info :
I have checked the registery for the Master db the path is as per the
startup parameters before i moved the 'model' and 'msdb' database
really appreciate all advise
tks & rdgs
maxzsim wrote:[vbcol=seagreen]
>Hi ,
> I got the 18502 error (looked into past posting seems no solution)
>Event Type: Error
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17055
>Date: 5/29/2006
>Time: 6:11:53 PM
>User: N/A
>Computer: ALTIRISSERVER
>Description:
>18052 :
>Error: 823, Severity: 24, State: 2.
>and
>from the SQL Error Log i got the followings :
>2006-05-29 18:11:51.41 server Microsoft SQL Server 2000 - 8.00.760 (Int
el
>X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>2006-05-29 18:11:51.42 server Copyright (C) 1988-2002 Microsoft
>Corporation.
>2006-05-29 18:11:51.42 server All rights reserved.
>2006-05-29 18:11:51.42 server Server Process ID is 2268.
>2006-05-29 18:11:51.42 server Logging SQL Server messages in file 'd:\ms
>sqlserver\MSSQL\log\ERRORLOG'.
>2006-05-29 18:11:51.42 server SQL Server is starting at priority class
>'high'(2 CPUs detected).
>2006-05-29 18:11:51.44 server Performance monitor shared memory setup
>failed: -1
>2006-05-29 18:11:51.53 server SQL Server configured for thread mode
>processing.
>2006-05-29 18:11:51.53 server Using dynamic lock allocation. [2500]
Lock
>Blocks, [5000] Lock Owner Blocks.
>2006-05-29 18:11:51.57 server Attempting to initialize Distributed
>Transaction Coordinator.
>2006-05-29 18:11:52.60 spid4 Starting up database 'master'.
>2006-05-29 18:11:53.85 spid4 Error: 823, Severity: 24, State: 2.
>2006-05-29 18:11:53.85 spid4 Cannot recover the master database. Exitin
g.
>Any solutions besidess re-install ?
>tks & rdgs
>
>[quoted text clipped - 24 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200605/1