• hedera (12/31/2009)


    That's my problem - at the moment I don't have a local copy of the database, because I don't have a functional SQL server on the laptop. I asked the ISP about the compatibility number but the tech misunderstood my question.

    That is still not an issue restore the backup just make sure your backup is in a remove able drive. Then check the compatibility level, if in 80 then change to 90 do another backup and restore and then change to 100. If 90 then change to 100 after restore. You should know that if your ISP is in SQL Server 2005 then it is best to use 2005 because you cannot restore 2008 in 2005.

    Kind regards,
    Gift Peddie