August 3, 2011 at 3:02 am
HI, I have enabled the mirroing for my user databases.
I need a procedure which can take care of :-
1. Any new login / drop login / modify login at primary should replicate to DR every day.
2. System database permmissions trasnfer to DR
3. System roles permmissions transfer to DR.
4. Trasfer of any new DTS/ modify at primary to DR
5. Any change in mail profiles / operators at primary to DR.
Thanks
Namit Sehgal
August 3, 2011 at 4:07 am
Assuming you are using sql 2008.
RightClick on your database--Tasks--GenerateScripts for users.
Take this script in a file and schedule it as per your requirement. It will not affect the existing one but will add new users with permission.
----------
Ashish
August 18, 2011 at 12:43 am
I dont thin your solution will work.
I am looking for for trasferring all metadata to my DR server everyday which includes linked servers, logins, system roles, system databases access etc...sql server jobs.
August 18, 2011 at 12:47 am
I am looking for for trasferring all metadata to my DR server everyday which includes linked servers, logins, system roles, system databases access etc...sql server jobs.
in short master database
----------
Ashish
August 18, 2011 at 7:21 am
jobs, ssis exists in msdb.
August 18, 2011 at 9:14 pm
sehgalnamit (8/18/2011)
jobs, ssis exists in msdb.
ohhh thanks, at least you know that.
----------
Ashish
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply