June 19, 2014 at 4:42 am
Hello,
If I restore a backup file to another server, then does it also copy across the tableTypes, table permissions, storedProcs permissions, etc?
Thanks
June 19, 2014 at 5:14 am
It copies everything that is in the database. Table types and permissions are in the database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 19, 2014 at 5:58 am
When you restore to another server, you'll have to look at your logins. Both the SQL and Windows logins have to exist on the destination server in order for the user to have any permissions. Also, the SQL logins will have to be fixed because the SIDs in the restored sys.database_principals won't match the SIDs from the source system.
June 19, 2014 at 6:53 am
Thank you
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply