Sometimes It’s The Little Things That Get You

I recently performed an in-place upgrade of a SQL Server from SQL 2008 R2 to SQL 2012. All seemed to work well, until I tried taking a database backup. That failed. This particular SQL Server uses LiteSpeed for backups and the following error was being returned when it ran: Msg 17750, Level 16, State 0, […]

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 […]