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.

http://www.microsoft.com/download/en/details.aspx?id=22661

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