-
Database mirroring on a clustered Sql Server instance
Mirroring is a high availability feature introduced in Sql Server 2005. Combining it with Sql Server cluster, it can buy an insurance policy for your high availability needs, if you will, in that cluster provides one layer of protection, and mirroring provides another layer. You can create a clustered Sql Server instance, which provides protection…
-
Remote desktop into Windows 2003 Enterprise R2 SP2 in a home network
I have a home network, which consists of a Linksys Wireless-G broadband router. This router gives out dynamic IP addresses to laptops and workstations. I remember that when I had Windows 2003 standard installed on one workstation, I could remote into it using Terminal Service. I’ve since installed Windows 2003 Enterprise R2 SP2, and my…
-
Rebuild master database
Recently, the default instance of Sql Server 2005 on my laptop refused to start. Here is the message in the Windows event log: The SQL Server (MSSQLSERVER) service terminated with service-specific error 3417 (0xD59). Here is the message in the Sql Server error log: The log scan number (253:272:1) passed to log scan in database…
-
Looking for unused indexes and checking index fragmentation in Sql Server 2005
Here is a script to check unused indexes in your Sql Server 2005 databases. Once one particular index has been used, the dm_db_index_usage_stats will be updated. All this information will be lost every time Sql Server instance is cycled. Therefore, you should run it after Sql Server has been running for a while, as it…
-
Sql Server 2005 AWE on Windows 2003 32-bit
Here are steps to enable AWE so that Sql Server 2005 can use additional memory, if your physical memory is more than 4 GB on 32-bit Windows 2003 box. 1. Add /pae at the end of last line inside c:\boot.ini 2. Run gpedit.msc. On the left hand pane, expand Computer Configuration, expand Windows Settings, expand…