Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Multi Server Admin Log

Author  Topic 

Westley
Posting Yak Master

229 Posts

Posted - 2005-08-14 : 22:08:32
Hi,
I asked a question about Multi-server admin before, was trying to set it up in UAT, and I got an issue, hopefully someone can help me with this.
I have setup 2 target servers point to that master server, I setup a job to backup sys tables and the issue was, when I try to forward the text log back to master server, since both target job is running at the same time, and when the text log file get generated, it uses the timestamp, so I only got 1 file out of the 2 target jobs. I though about changing it so the text log files generate locally, but the 2 target server are running on the same server with different sql instance, and on it will have the same issue where the text file trying to generate in the same folder...so does anyone come across this and have a solution for it? Would like to forward all the text log files back to the master server, so everything is keep in 1 place.

Thanks

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2005-08-15 : 12:52:58
What's UAT? User Acceptence Testing environment (QA servers)? University of Arizona at Tucson (Stuff for your school work)?

Go to Top of Page

Westley
Posting Yak Master

229 Posts

Posted - 2005-08-15 : 19:53:42
UAT - User Acceptence Testing, its the testing environment, as I better get this issue sorted before I put the change in production.
Go to Top of Page
   

- Advertisement -