My client wants to migrate MSSQL server 2000 to 2008 R2.
He dont have many databases, only 1 database with a size 250GB.
I am planning to take the backup of that database in 2000 SQL Server and restore in 2008 SQL Server and change the compatability of that database to 100.
Can anyone tell me, will that scenario work with out any issues?
Waiting for your reply and thanks in Advance
Thanks & Regards,