Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...

Currently I have a live SQL server running as the backbone of a production website we will be using. We need a copy of this database to move over to another server without interruption. If I use the ...

I think this can be updated with the appropriate ALTER DATABASE command, but may not be necessary if the current server version supports the older compatibility level. You could also do a full restore ...

However, the Compatibility Level property for that database remains at the release it was upgraded from. For instance, if you copy a SQL 2000 database to SQL Server 2008, the new copy is an upgrade to ...