Restoring a MSSQL 2005 database can mean problems for those that do not know how to do it properly. Especially if you are restoring this database on a different server than what it was created on. Read how to do it here.