Monthly Archives: February 2012

High Availability 9’s

This is very important to understand what is high¬†availability 9’s, This is a measurement of high availability¬†¬†where you can tell how much downtime is feasible for your organization for a Year(annually). the calculation is as follows =Total Hours in a … Continue reading

Posted in Disaster Recovery, High Avaliability | Tagged , | Leave a comment

Desktop Edition Sql server 2000 MSDE Install upgrade

for sql server 2000 (I know its old) desktop edition does not includes any GUI. so installation of desktop edition ie MSDE is via command prompt. you can install the setup for desktop edition for free from here. http://www.microsoft.com/download/en/details.aspx?id=22661 to … Continue reading

Posted in Add/remove, Installation, Limitation, Troubleshooting | Tagged , , | Leave a comment

Dynamic Add/Remove file in Mirroring/Logshipping

Yesterday we were having discussion on high availability feature Mirroring and Log shipping with my colleagues (Amol & Alankar) on whether can we dynamically add/drop any new file in our principle or primary database, got conclusion that YES it is … Continue reading

Posted in Add/remove, Disaster Recovery, High Avaliability | Tagged , | Leave a comment