Archives: February 2012
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
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
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