What is this error about in sql server?
The message usually means that you're trying to restore a backup of another - unrelated - database over your existing database. Double check that the backup you're restoring is really of the database you think it is.

Edit: If I remember correctly, you can also get this message if you're trying to restore a differential backup without first restoring the correct full backup.