Now, there are a plethora of posts about it, and two of them really stand out: http://support.microsoft.com/default.aspx?scid=kb;EN-US;941105 - an issue with Windows Server 2003 http://support.microsoft.com/kb/929668 - if SQL Server 2005 is a (direct) upgrade from SQL Server 2000 Also, you will find many blog posts suggesting to attempt a repair of the MSXM 6 (currently, … Continue reading Failed to load msxmlsql.dll is SQL Server 2005
Author: Calin OPREA
Tool review – SQL Backup and FTP
We currently do have a process in place that takes a full backup, creates some zip files, sends the over to another server, and whatever else is left. Obviously, it is prone to errors. Therefore I was more than interested to see this tool in action (as recommended by Pinal Dave). Also, I will not … Continue reading Tool review – SQL Backup and FTP
Online index operations are fully logged in SQL Server 2008 and later!
The title is self-explanatory, but I had no idea until I recently saw my transaction log size skyrocketing; and here's the article: http://support.microsoft.com/kb/2407439 best regards, io
Backup, file manipulation operations and encryption changes on a database must be serialized
I love scratching my head; that's why I became a DBA in the first place, I get the chance to scratch my head and swear a lot, without anyone complaining about it. The most recent head-scratching situation was when we checked our backup history table (we use a custom script, and no, we're not allowed … Continue reading Backup, file manipulation operations and encryption changes on a database must be serialized
“A MOF syntax error occurred” when installing SQL Server
OK, in my case it was a clustered environment, but I bet this applies to single instances as well. I ran the setup (it's not quite my first SQL Server install, you know) and after configuring all the steps, I hit Install and waited. The good news is that I didn't have to wait too … Continue reading “A MOF syntax error occurred” when installing SQL Server
master database restore failed in SQL Server 2008 R2 SP1 CU1
We just woke up having 30+ instances of SQL Server 2008 R2 Enterprise edition in development and testing. Which is bad for obvious reasons. So basically I have to uninstall the Enterprise and re-install Developer Edition on all the machines. Steps to take: Create a maintenance plan to back up all the databases (simplest way; … Continue reading master database restore failed in SQL Server 2008 R2 SP1 CU1
Is truncate logged or non-logged in SQL Server?
Okay, second blog post in one day – slowly trying to recoverJ. Below is an excerpt from a stored procedure from BizTalk server: --If you are doing this we assume it is because you have a huge, old db so it is just faster for us to --find things which are not done and hold … Continue reading Is truncate logged or non-logged in SQL Server?
Fix orphaned users in SQL Server 2005 – not
A quick one, again (haven't been blogging for a while, I have like a ton of blogs on my mind, lack the time, though): I think most of the DBAs have stumbled upon "how to fix orphaned users in SQL Server", right? Well, a quick overview of the script: SET NOCOUNT ON SET QUOTED_IDENTIFIER OFF … Continue reading Fix orphaned users in SQL Server 2005 – not
DTS package runs from command line, but fails from SQL Server Agent
Yet another quick one for you. One of my colleagues was trying to set up a job to run a DTS package (yeap, I know, a bit of a last century stuff). Whenever he ran the package from the command line, everything was running fine. However, when he ran the same package from within a … Continue reading DTS package runs from command line, but fails from SQL Server Agent
How can I tell if my restore process is actually doing something
Just stumbled into this: if you have a large DB to be restored, it might take forever to actually see the progress moving to 10%, 20%, and so on. Yeah, I know, you should never do a restore from the SSMS, but don't try to tell me thatJ. Anyway, coming back to our scenario: if … Continue reading How can I tell if my restore process is actually doing something
SQL-PLAY 