We help IT Professionals succeed at work.

SQL 2005 securables cant see  after restore to another server

546 Views
Last Modified: 2012-05-11
After restoring a SQL 2005 database to another server using restore database master from disk=d:\master.bak with replace then using symantec exec 12.5 to restore rest of databases from tape all looks ok except that no user has any securables viewable . I log on as system admin or sa in sql managemnet studio express.
How can I restore the securables ?
Comment
Watch Question

Database Analyst
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
It seems that users can log on ok . I can see them listed under security in the main security section and under each database, But when double clicking on a user name there is no securables listed for them. The users are domain users or groups.

Author

Commented:
ok no interest here.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.