Goodbye, Old Friend

It can be hard to say goodbye to old friends and SQL Server 2000 is definitely an old friend of mine. It was a huge improvement over SQL Server 7.0. Sure it still had some quirks (remember the pain of setting up SQL Mail?), but all in all, it offered a huge improvement over version […]

Deleted Logical Data File Reappears In LiteSpeed Backup After 2005 to 2008 R2 Conversion *UPDATED*

I recently migrated a database from a SQL 2005 SP3 server to a 2008 R2 SP1 server. In the 2005 SQL Server, the database consisted of three logical and physical files. I moved it to the 2008 R2 server by taking a native SQL backup and restoring it on the new server using the WITH […]

Too Many Bits

A commenter recently reminded me that, although I had mentioned that I attempted to do a migration from SQL 2000 to 2008 a while back, failed, and had to go back to the old version, I never really explained what happened. So now I will! We had a SQL Server cluster running SQL 2000. One […]