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 ...

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 ...

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