February 4, 2011 at 12:11 am
Hi All,
We has a server movement from its location. After restarting the server in the new location, everything seems to be fine except SQL services. SQL Services are somehow not coming online.
can anybody have any idea what is causing this?
Vivek
February 4, 2011 at 12:26 am
Can you let us know the error message if any?
Cheers,
Satnam
February 4, 2011 at 1:03 am
This is the error.
17113 :
initconfig: Error 21(The device is not ready.) opening 'E:\MSSQL2K\MSSQL\Data\master.mdf' for configuration information.
It seems that one drive is missing/changed.
February 4, 2011 at 1:23 am
'E:\MSSQL2K\MSSQL\Data\master.mdf'
check if the drive is available. Seems like the problem with Drive/location.
----------
Ashish
February 4, 2011 at 1:25 am
Did you delete the files manually before? If yes then this might help
http://support.microsoft.com/?scid=kb%3Ben-us%3B173180&x=8&y=15
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
February 4, 2011 at 1:27 am
E drive is not there. May be its changed. How to resolve? Renaming the drive wont' work i guess.
February 4, 2011 at 1:35 am
How to resolve? Renaming the drive wont' work i guess.
No, renaming the drive will not work.
Before considering the option to resolve this issue, consider the point that do you really need the same master database on this server?
Sometime we just think too much about problem, instead of alternate.
If you looking for alternate then you can do fresh installation on this server which will create the system database. And then you can transfer the required things of master database from old server to this new server.
OR
You need to follow the document provided on MSDN, how to move system database in sql 2000/2005/2008(whichever appropriate)
----------
Ashish
February 4, 2011 at 2:21 am
Yes we need same master db on the server. Fresh installation doesn't work in such scenario.
February 4, 2011 at 2:31 am
Do you have the old master database? If not, the point's pretty moot as to whether you need it or not.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2011 at 2:39 am
Fresh installation doesn't work in such scenario.
ohhh you know this.....
then you should be considering the approach accordingly.
----------
Ashish
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply