YOU HAVE A SQL SERVER 7.0 DATABASE AND WOULD LIKE TO MOVE IT TO A N...

4. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P9 PPTX
THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P9 PPTX
4. You have a SQL Server 7.0 database and would like to move it to a new SQL Server 2008 instance. The database is part of an FDA-validated system and cannot be changed at all? How can this be accomplished?A. Restore the 7.0 database on your new server and set the compatibility mode to 7.B. You must upgrade the database to SQL 2005 or greater.C. Restore the 7.0 database on your new server and set the compatibility mode to 6.5.D. Copy the .mdf and log files and use SP_attach.