You may get Restricted User warning after a database restore if source database is MSSQL Server 2005.
You can remove that warning by this SQL query:

ALTER DATABASE Your_Database SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE Your_Database SET MULTI_USER
GO

After that, there will be no warning on your database.