September 2009 Blog Posts
After attaching or restoring a database to SQL Server 2005, you may encounter an error when executing a CLR object. Error: An error occurred in the Microsoft .NET Framework while trying to load assembly id 65538. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE. This KB article describes the issue and shows the fix, however it says the bug occurs when the database is attached/restored to a different SQL instance. I’ve encountered the error three times now. In at least one occurrence of the error, it...
The SQLCAT team released a very informative whitepaper regarding backup and recovery of very large databases in SQL Server 2008. It is a must read if you are a SQL Server DBA. Check it out here. If you are not already following the SQLCAT team’s blogs and you are a SQL Server DBA, you need to get with the times and start following one of the best online resources for SQL Server.
I have modified isp_Backup, which is the stored procedure that I use to backup SQL Server databases. This new version includes one bug fix and three new features:
Bug Fix – removed ReportServerTempdb from exclusion list
Bug Fix – fixed file retention code to handle database names with spaces
Feature – support for SQL Server 2008 including compression
Feature – archive bit option
Feature – COPY_ONLY option
I decided that excluding the ReportServerTempdb from the backups was unnecessary. This database, used...
For various reasons, you may need to manually remove SQL Server replication. Microsoft has a good KB article which shows how to do it. It has always worked in the past, but I ran into a situation a couple of weeks ago where it couldn’t remove the distributor via sp_dropdistributor. I don’t recall what error we were getting, but I didn’t have time to figure out what was wrong so with the help of a Microsoft engineer we were able to setup another distributor and then get replication working again. Later I tried “drop database” command on the original distribution...