Recently I’ve been assigned to help out with database migrations from SQL Server 2005 up to SQL Server 2008. The migration process goes like this:
- Put the database into single user mode
- Backup & Restore it to it’s new home
- Take the original database offline
Now, while taking the database offline isn’t all that exciting, I think that it’s a neat feature of SQL Server that you might not be aware of. So, let’s take a look!