Hi Steve, our enviroment is very OLTP intensive. Several clustered SQL boxes etc. No window during the week from production for optimizations etc etc. Loads of project work including bringing...

Hi, Buy ISBN 0-9749736-0-2 A Guide to SQL Server 2000 Transactional & Snapshot Replication by Hilary Cotter. I highly recommend it. We have 4 cluster SQL2K servers using a central...

Thanks Steve. I may as well take the exam and as you say proceed with the 2005 study at home. Our Polish site may be coming up on 2005 at the...

I agree. No tape backups is nuts ! We backup remotely to disk and then to tape. Tapes are stored off site. We also log ship to a DR site....

Excellent article. I must admit I'd be pretty OK and on top of things. However I am still printing you article and pinning it to my wall as a 'little...

Hello All. First of all thank you Jambu for your article. Certainly got the yeah's and nay's going. A little experience I have had in the past on not so...

We are running SQL Server 2000 (sp3a) on Windows 2003 clustered. We are just starting to use Log Shipping for Disaster Recovery. Basically shipping the logs across the MAN to...

Claudia, Your primer is excellent. Very informative etc. One issue which I have been trying to overcome is, I have an archive database on the subscriber receiving transactions from a...

Thanks Greg. No I hadn't seen it. I did muck around with TargetServerRole and the App Support team now can view job history and start/stop jobs but not modify them....

Hi, I'm not saying this is the answer to your problem, however due to SOX compliance I had a similar issue here. What I did was I added our Application...

Hi just a guess but, Click on the Filters tab of the trace properties. Scroll down to ObjectId or ObjectName. Can you enter the object id from sysobjects or table name...

Hi Mkumari, I was wondering have you made any progess connecting between publisher and subscriber. Thanks Derek

Hi Mkumari, first of all have you set up a Linked Server between the Publisher and Subscriber. Also using query analyser, can you connect to the subscriber and query any...

I found your article excellent. I suppose to a degree it has taken away my 'no go' attitude towards the master database. Now having said that - your comments on...

Apologies in late reponse. Homebrew01 has answered the question on how to specifiy the UNC path. Our snapshot folder is on a different server (Distributor) than the publisher and we...