How to upgrade to SQL Server 2008 R2 with minimal downtime: 1-2 minutes
Here is real life example, how to upgrade SQL Server 2005 to SQL Server 2008 R2 with less than 2 minutes downtime and without any conne...
Read More
Tampilkan postingan dengan label Mirroring. Tampilkan semua postingan
Tampilkan postingan dengan label Mirroring. Tampilkan semua postingan
Database Mirroring between a Server in Domain and Server outside domain (workgroup)
When you setup a Database Mirroring via the GUI in SSMS, you are requested to specify the fully qualified domain names (FQDN) of the server...
Read More
Is the % of an index fragmentation in Log shipped / Mirror database equal to the Primary/Source database?
Suppose there is Log shipping or Mirror between database X and database Y. The mdf/ldf file(s) of the X DB and Y DB located in different st...
Read More
4 ways to efficiently monitor DB Mirroring with/without email/SMS Alerts
A setup of DB Mirroring ( See my post here ) cannot be full without a setup of DB Mirroring monitoring. I want to share with you 4 ways to...
Read More
Langganan:
Postingan (Atom)