We have an old app that is running on SQL Server 2005 and the database is set to compatibility level 80 (SQL 2000). Would like to change to level 90 (SQL 2005). If problems surface, can we simply change back to level 80? (assuming we don't make use of any new features). Can the compatibility level be changed back and forth until all problems are worked out? The database will stay on the same server that is running 2005 binaries.
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.