Ramblings of a DBA

Tara Kizer
posts - 166, comments - 837, trackbacks - 75

My Links



Search this Blog


Post Categories


September 2009 Blog Posts

Fix for CLR object execution error after attach/restore in SQL Server 2005

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

posted @ Monday, September 21, 2009 10:55 AM | Feedback (2) |

Fast and Reliable Backup and Restore of VLDBs in SQL Server 2008

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.

posted @ Thursday, September 10, 2009 4:03 PM | Feedback (0) | Filed Under [ SQL Server - Database Administration ]

Backup SQL Server 2005 and 2008 Databases

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

posted @ Tuesday, September 08, 2009 11:26 AM | Feedback (4) | Filed Under [ SQL Server - Database Administration ]

How to remove a SQL Server distribution database if other methods fail

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

posted @ Wednesday, September 02, 2009 1:59 PM | Feedback (3) |

Powered by:
Powered By Subtext Powered By ASP.NET