Cl2-MSSQl2 outage - restored

Re: Cl2-MSSQl2 is super slow

Looks like the server has gone into a chkdsk mode here and we are checking further.
 
Re: Cl2-MSSQl2 is super slow

Tech enroute to the datacenter as well as KVM is not up on this server now, it is rush hour start and may be 30 minutes before the tech is able to aid if needed, we hope it comes up before he is there.
 
Re: Cl2-MSSQl2 is super slow

Looks like we will be needing hands on to bring it online, should arrive in next 10-15 minutes.
 
Re: Cl2-MSSQl2 is super slow

Found parking and heading in now a bit delayed..but on way in.
 
Re: Cl2-MSSQl2 is super slow

We are trying to find out what the issue is now, as the machine is hanging on BIOS on restarts.
 
Re: Cl2-MSSQl2 is super slow

We are taking the server out of the rack and checking all the cables etc and then going to rerack it and work to get it up. If that fails we will move to restoration of data.
 
Re: Cl2-MSSQl2 is super slow

We are going to have to move to process of restoration, as it seems that something major has happened to the drives or motherboard. We are going to attempt to remove the drives and put them into another server for the fastest process here, if that does not work will will move to a copy from backups procedure.
 
Re: Cl2-MSSQl2 is super slow

Good news is that we have the original drives up and going on a new server, so the drives themselves are fine. We are working now to install MSSQL and import all this over to the new hardware. We are going to keep the MSSQL2 IP off of the new server until this is completed.
 
Re: Cl2-MSSQl2 is super slow

We have SQL services installed on the new hardware and working to start copy of the mdf/ldf files over in just moments.
 
Re: Cl2-MSSQl2 outage - updates

We hit with little speed bump with some file copies. It made process have a bit of delay.
 
Re: Cl2-MSSQl2 outage - updates

Data copy done, we are going to reboot and then work on bringing the DBs online, and then assign the MSSQL2 IP when all is good.
 
Re: Cl2-MSSQl2 outage - updates

SQL has started successfully, running a CHECKDB on every database to ensure integrity and mounting IP in about 3 minutes.
 
Re: Cl2-MSSQl2 outage - updates

IP mounted, DBs loading on access as I see it now.
 
Re: Cl2-MSSQl2 outage - updates

I know someone will ask as they did not read the entire list of posts so in summary; many of them so understandable:
1. Data was not restored from backup, it was restored from a single drive off the previous hardwares RAID1 mirror, so there is no 'old' data, it is all as it was before.
2. New server hardware is Dual 2.93 ghz Intel, 4GB RAM, RAID1 HD array + RAID1 + Extra non raid (the drive off of MSSQL2 from this morning)

3. Hsphere may not be interfacing yet, we are about to work on this, it was not a priority over getting existing databases online. Working on this now.
4. Web backup/restore tool not yet online, will have this done within 24 hours.
 
Re: Cl2-MSSQl2 outage - updates

Hsphere is now online on MSSQL2.

Web interface for backup/restore will be done by tomorrow morning.
 
Back
Top