Backing up Security Info 2

[donutman]

Does a backup automatically all of the security info for each database user? How do you backup the Login accounts?
-Karl

 

[hmckillop]

I generally would script them out to a file, using enterprise manager scripting option, but I am sure there are other ways.


"I'm living so far beyond my income that we may almost be said to be living apart

 

[JamesLean]

Logins are stored in the master database - backing up the master db should be part of your server backup strategy.

--James

 

[donutman]

Ahh, thanks James. Does backing up the other databases back up the permission settings for each object/each user?
-Karl

 

[Corran007]

Yea

Backing up the Master covers the logins for the system. Backing up each database covers the permissions a user has in that specific database