This is a follow up post to my earlier post How to remove a filegroup that was part of a SQL table partitioning function. In this post I will explain another scenario which prevents you from dropping a existing filegroup that is locked due to a partition scheme.
In the following scenario an asker in the forums was having trouble dropping a filegroup that they believed was no longer in use however they were receiving the following error when attempting to drop the filegroup.
I regularly get asked about error codes in a Windows environment, especially when the developers have nicely coded their work to only output something such as “failed with the operating system error 3”. It is at this point where you shake you head and wonder well that’s great but what does error code 3 mean! Here are links to some further information on these.
I just recently had a colleague come to me with an issue when trying to add domain accounts to a local group on a Windows 2008 R2 server. Turns out that when he added the account the domain account appeared in the local group members list and then disappeared.
Just a quick post to remind those of you corporate and personal users of Windows XP and Office 2003 – it really is time to think about upgrading. Windows XP and Office 2003 reach end support on the 8th April, 2014.
Database mirroring is a very handy HA solution available per database for SQL 2005/2008 and is available in both Enterprise and Standard edition. This solution also provides both automatic and manual failover. Therefore it is a HA solution available to almost all SQL server users.
When you have large log shipped databases one of the potential issues I see asked many times is how to add additional data files to the existing log shipped database.
This post was prompted by John Sansom’s (b | t) post Your Road to Becoming a DBA: Acquiring Experience is Key. I was going to leave a comment but it was getting a bit long so I thought this might be better. Continue reading
I recently sat and passed the VCP 5 exam. Current holders of the VCP 4 certification have until February 29th, 2012 to pass the VCP 5 exam and qualify to receive the VCP 5 qualification without having to take one the usual pre-requisite classes.