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.
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.
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