search
Categories
Archive
Blogroll

Badges

Microsoft PowerShell MVP
MCSE
Sponsors

VirtualMetric
Cozumpark Bilisim Portali
How to remove Restricted User warning after MSSQL database restore
Posted in Windows Server | No Comment | 1,017 views | 10/04/2013 21:33

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.



Leave a Reply