Megabyte
Posted 17 August 2013 - 01:07 AM
So I just had a hellish 2 days restoring a failed server.
Tip for the wise: If you use r1soft from Idera, it restores each database table row-by-row, then checks each row one at a time for errors.
This is great for making sure everything is correct. Not so great when you have 60+ databases with 200,000+ row tables in them.
One database in particular took from 1:50pm Thursday until 6:30am Friday to finish.
I cried.
Rumors of my demise have been greatly exaggerated.
Deer Leader of the Goriest Revolution
Posted 17 August 2013 - 03:13 PM
That seems very accurate and terribly inefficient. A very fast SSD would probably make it much better though. >.>
Megabyte
Posted 17 August 2013 - 04:38 PM
An SSD would also not last very long on a high volume server. 
Rumors of my demise have been greatly exaggerated.
Deer Leader of the Goriest Revolution
Posted 17 August 2013 - 09:31 PM
Guest_ElatedOwl_*
Posted 18 August 2013 - 08:55 AM
They have ones with better read/write cycles now specifically for databases.
I bet that costs a pretty penny
Deer Leader of the Goriest Revolution
