-
Sql Server 2005 SP2 Cluster Install issue
I had some trouble installing SP2 on a Sql Server 2005 64-bit cluster for a client, running on Windows 2003 SP2 OS. All other components patched successfully, except Sql Server Service. It is the single component that failed. The error number on the active node, where I started the install, is error number 11009. The…
-
Sql Server 2005 SP1 Agent email notification not working
It looks that there is a bug in Sql Server 2005 SP1 that renders Sql Server Agent job email notification useless. This notification is enabled through Notification page in job property page. Below is the error message you will see in Sql Server Agent log, even when “Agent XPs” setting is set to 1: [298]…
-
Proper ways of setting up Sql Server 2005
Here are some things I’ve learned with many clients when setting up Sql Server 2005 systems. 1. Get 64-bit if you can. Throw in as many processors, memory, good disk system (properly tuned SAN, for example) as you can possibly get; 2. Apply the latest service packs for Windows. At this writing, it is SP2…
-
Database backup compression in Sql Server 2008 Katmai
It looks like database backup compression in Sql Server 2008 will only be available in Enterprise Edition, at least that is what BOL says, in the latest Sql Server 2008 CTP (November, 2007). So I gave it a little spin. I detached AdventureWorks, attached it on a Katmai instance and run two sets of backups,…
-
Get the documents out of SharePoint database
I recently helped a client to get the WSS 3.0 documents out, as the client’s SharePoint is broken and we couldn’t get it fixed in short time, but they really want the Word, Excel, and pdf documents out of there. WSS 3.0, Windows SharePoint Services, uses Sql Server for data storage. The Sql Server version…