October 25, 2011 at 12:22 am
Hi,
I have daily Wednesday task that includes copy of .bak full backup files of three databases from one server to another server & restore on target server. Checking the permissions on target restored databases finding orphan users and fixing them. And copy one folder also from one server to another and replace on target server. I do it on every Wednesday manually. And it takes around 2-3 hrs to complete the process. How can I automate this task ?
Thanks in advance.
October 25, 2011 at 12:40 am
You could create a job on the target server and include the steps one by one as desired.
For copying the backup files, you could set up a shared drive and perform the copy.
All what you described could be set up in a step by step job configuration.
M&M
October 25, 2011 at 1:17 am
How the job will find the .bak file of Wednesday since there are many other files are also located. And what about orphan users? Will I be able to find the orphan users and fix them by using job ? If yes please let me know how ?
Thanks in advance.
October 25, 2011 at 3:25 am
beejug1983 (10/25/2011)
How the job will find the .bak file of Wednesday since there are many other files are also located. And what about orphan users? Will I be able to find the orphan users and fix them by using job ?
You would need to prepare scripts for this. Eg. regarding .BAK file you could get the information from the backupset system table present in msdb database.
M&M
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply