SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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 Year-(Total Hours in a Year* # of 9′s)/100 Read more

0 comments, 647 reads

Posted in Vinay Thakur on 27 February 2012

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.


to install, just download the exe. and extract it.

setup.exe /settings… Read more

0 comments, 1,963 reads

Posted in Vinay Thakur on 21 February 2012

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 possible to the same will be affects on the mirrored… Read more

0 comments, 456 reads

Posted in Vinay Thakur on 15 February 2012