Hi,

What's your goal with the Disaster Recovery Plan? Do you want to have a general one or a specific one for your environment?

There's no point to create a general one...

Hi,

Just a quick question to avoid a pitfall: Do you use uncommitted read in your query? I yes, this error message can be quite normal (if not pointing to the...

Jeremy,

The size of the transaction log (of the app db) won't grow faster because of replication.

One question: how are you going to implement the pull replication on SQL 2005...

John,

Aren't you going to upgrade to SQL 2005? There you can use peer-to-peer (bidirectional multimaster) replication which can give you the required result.

Agree with Paul. You can use also log shipping for business continuity, with which you can quite easily bring your lost database up-to-date. Read this series: http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx

Hi Mike,

Microsoft is your friend, they've almost done it Check http://www.microsoft.com/technet/prodtechnol/sql/2005/mirroringevents.mspx and download the word document. As you'll see, you can catch WMI...

Hi,

It looks like a disk bottleneck. Check it, and if it is, then try to lower the number of virtual devices in LiteSpeed (I don't know how they call it...

Hi Pavan,

Next time if it happens, find what causes the blocking, this way you may modify your script to avoid this situation. Here's a quite simple script for this task,...

Hi,

Check this:

http://technet.microsoft.com/en-us/library/ms152572.aspx

This is for SQL 2005, but may help you.

SQL ORACLE,

You should be nicer to a new guy

Hank,

You can do this with transactional replication and with some trick

Hi Simon,

There's no difference until you add more articles to your publications. So you can decide which one is the better for you. I would choose the 'all' instead of...

Hi Mike,

1-Firewalls are a very good arguments for push replication. This case you need to open only one port: your SQL server for your customers. First, this way you risk...

Sure, you can do it, but it won't take into effect until you restart your job if it's set to run continuously. In this case, you can easily stop and...

Hi Mike,

If I were you, I'd set up continuous push replication. My reasons:

Continuous: If you set up a scheduled replication, then from time to time it starts up, hitting your...

JP,

Here's the URL, it was posted to another forum (hopefully I won't be banned for this ).

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=69430

If you can migrate to 2005, then you...