December 18, 2009 at 6:53 am
Hello Gurus
We have moved the system databases from one SAN Drive to another, in order to remove the old SAN drive from the cluster. Everything looks fine, but, when I query select * from sysdatabases in master. the mdf path for master DB is still showing the old path. But, the properties of the DB shows the new path also, exec sp_helpfile shows the new mdf and ldf location as well. I als confirmed that the physical location of mdf and ldf are in new san drive. but not sure why sysdatabases is showing the old path. Can you please suggest what should be done.
Thanks
Ali
December 21, 2009 at 6:27 pm
What was your process for moving the master database? Did you follow the steps in the MS KB article:
http://support.microsoft.com/kb/224071
Joie Andrew
"Since 1982"
December 22, 2009 at 7:50 am
Yes. I have used the kbarticle. My SQL agent is down. As I said, I am on the cluster, and my old drives, where my sys databases were residing is not in the cluster anymore. Please advice.
Thanks
Ali
December 22, 2009 at 12:50 pm
Hmmm. Not sure. I do not have as much experience with clusters as others have.
Question though - the SAN LUN that the master mdf was moved to is a cluster resource, correct?
I can try moving a master on a test system and see if I can recreate your results.
Joie Andrew
"Since 1982"
December 22, 2009 at 1:30 pm
Yes. It is a cluster resource. Eventhough, I moved the mdfs, it was working fine until the Lun is removed from the cluster. Once the lun is removed, my SQL agent is not coming up.
December 22, 2009 at 1:41 pm
After you remove the LUN, does your master database come up? MSDB? TEMPDB? MODEL?
What is the error message you get when trying to start the Agent?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 22, 2009 at 1:42 pm
What is the error being reported by the SQL Agent, check the log directory of your instance for the error file, you could open it using any text editor.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 23, 2009 at 4:04 am
SQL Server picks up the path for the master data and log files from startup parameters.
As far as I know, it will always ignore the paths stored for master within the master database. However, this may not be true during application of SPs or CUs (I have not tested this).
If you want to get the path stored within master to match the real path of master, you will have to start SQL Server in single user mode and issue an ALTER DATABASE on the master DB with the correct path name.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
December 23, 2009 at 7:12 am
My error Log
server Microsoft SQL Server 2000 - 8.00.2282 (Intel X86)
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2009-12-18 12:38:57.44 server Copyright (C) 1988-2002 Microsoft Corporation.
2009-12-18 12:38:57.44 server All rights reserved.
2009-12-18 12:38:57.44 server Server Process ID is 6992.
2009-12-18 12:38:57.44 server Logging SQL Server messages in file 'I:'.
2009-12-18 12:38:57.45 server SQL Server is starting at priority class 'normal'(4 CPUs detected).
2009-12-18 12:38:57.47 server Address Windowing Extensions enabled.
2009-12-18 12:38:58.42 server SQL Server configured for thread mode processing.
2009-12-18 12:38:58.44 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2009-12-18 12:38:58.70 server Attempting to initialize Distributed Transaction Coordinator.
2009-12-18 12:39:01.84 Starting up database 'master'.
2009-12-18 12:39:02.45 Server name is ''.
2009-12-18 12:39:02.45 Starting up database 'msdb'.
2009-12-18 12:39:02.45 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2009-12-18 12:39:02.45 Starting up database 'model'.
2009-12-18 12:39:02.48 server SQL server listening on .
2009-12-18 12:39:02.67 server SQL server listening on TCP, Shared Memory, Named Pipes.
2009-12-18 12:39:02.67 server SQL Server is ready for client connections
2009-12-18 12:39:02.97 Clearing tempdb database.
2009-12-18 12:39:03.23 Starting up database 'tempdb'.
2009-12-18 12:39:03.28 Recovery complete.
2009-12-18 12:39:03.28 SQL global counter collection task is created.
2009-12-18 12:39:03.33 Launched startup procedure 'sp_startup'
2009-12-18 12:39:03.91 Using 'sqlmap70.dll' version '' to execute extended stored procedure 'xp_sendmail'.
2009-12-18 12:39:03.95 Error: 1073759806, Severity: 1, State: 0
2009-12-18 12:39:03.95 Starting SQL Mail session....
2009-12-18 12:39:06.08 Error: 1073759778, Severity: 1, State: 0
2009-12-18 12:39:06.08 SQL Mail session started..
2009-12-18 13:11:54.64 Using 'xpstar.dll' version '2000.80.2282' to execute extended stored procedure 'xp_sqlagent_enum_jobs'.
2009-12-21 10:40:03.75 Using 'xplog70.dll' version '2000.80.2039' to execute extended stored procedure 'xp_msver'.
December 23, 2009 at 7:57 am
Everything in your log file looks fine.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
December 23, 2009 at 8:02 am
1st and 2nd error
http://support.microsoft.com/kb/315886
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 23, 2009 at 8:04 am
EdVassie (12/23/2009)
...If you want to get the path stored within master to match the real path of master, you will have to start SQL Server in single user mode and issue an ALTER DATABASE on the master DB with the correct path name.
In support of Ed's statement
http://support.microsoft.com/kb/224071
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 23, 2009 at 8:18 am
You have given the SQL Server erroelog. What is in the SQL Agent errorlog.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply