August 13, 2014 at 3:09 pm
We backed up the drive that had the \Binn folder installed for the DB engine for SQL Server 2012. Deleted the RAID 10 array to add 600 GB to the array. Rebuilt the array. We then restored the contents of the drive back to the new array. Initially we could not start the DB engine. The Windows logs indicated a file was missing. I noticed that SQLServer.exe was missing. I copied that file from another SQL Server 2012 instance and tried again. Now all we get is " A timeout was reached while waiting for the MSSQLSERVER service to connect." This is followed by "The service did not respond to the start or control request in a timely fashion." What do we need to do?
August 13, 2014 at 3:31 pm
Were all the accounts, permissions and registry settings restored?
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
August 13, 2014 at 3:34 pm
Well the DB engine does not start so I don't know if the accounts and permissions restored. IT was the drive that had the ,mdf and .ldf files on it.
August 13, 2014 at 3:38 pm
I was concerned about the windows accounts and permissions.
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
August 13, 2014 at 4:18 pm
Windows is on the other drive array and was not touched.
August 13, 2014 at 4:29 pm
lmarkum (8/13/2014)
Windows is on the other drive array and was not touched.
Ok, that works for the registry settings. But the permissions for the service accounts on this other array - it is still in question. You were missing files (specifically sqlserver.exe) so everything is not back in place on the volume that crashed. Part of that includes OS level permissions on the replaced array.
Also of concern is if you copied the same version of sqlserver.exe to the binn folder. Were both servers patched to the exact same level?
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
August 13, 2014 at 4:39 pm
We used backup exec and chose to back up with NTFS permissions. The other files we copied were from a machine also on SP1. Should we try replacing the files from the install media?
August 13, 2014 at 4:44 pm
lmarkum (8/13/2014)
We used backup exec and chose to back up with NTFS permissions. The other files we copied were from a machine also on SP1. Should we try replacing the files from the install media?
I don't know that the backup can be trusted. Case in point - files were missing and the service won't start.
If checking the permissions is out of the question, then you can try with a repair or reinstall of SQL Server from the install media.
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
August 13, 2014 at 9:25 pm
A repair operation got me going again.
August 13, 2014 at 9:35 pm
lmarkum (8/13/2014)
A repair operation got me going again.
Good to hear.
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
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply