After looking at your setup, I would make Instance 2 and 3 reporting databases as Subscriber db's for transactional replication. You have more flexibility with what to replicate or not....

• This reply was modified 5 years, 6 months ago by  Rohan Joackhim.

Did you use the activity monitor in SQL Server SSMS to see what processes are running within the SQLOS. It can give you some insight what is running.Also "Recent Expensive...

Confirm the fallowing:

1) Has Snapshot been completed?Bulk copy and insert both needs to be completed.I have noticed sometimes it takes more than 2-3 hours(500GB Publisher) to complete and, then you...

There has to be something inside the SQL server error log.

--Rohan Joackhim

I tested this in my test environment with a 468GB principal database/High safety with automatic failover (synchronous)-Mirroring, and worked like a charm.It took 10 seconds to create the snapshot...

well written article and kudos for organizing Net meeting!! It was a great success.

Rohan

It's possible using Policy Based Management feature in SQL 2008.This article(http://www.mssqltips.com/tip.asp?tip=2192&home) will give you a scratch on the surface, you will have to dig more deeper to...

Tools-->Options-->SQL Server Object Explorer-->Scripting-->Delimit individual statements

or can be one of the options in there.

Thanks,

Rohan

Hope this might help!!!

http://seer.entsupport.symantec.com/docs/198240.htm

Thanks,

Rohan

If you have transactional replication set up in your enviorment, it uses Microsoft Distributed Transaction Coordinator (MSDTC) component included with SQL Server 2000, to execute transactions.

Thanks,

Rohan

I have done this few years ago.It's not hard as everyone thinks.I used SQL compare from redgate.

"First, create a new database on the SQL Server 2000 instance using Enterprise Manager,...

USE distribution

GO

SELECT * FROM dbo.MSsubscriptions

subscription_type Column;

0 = Push.

1 = Pull.

2 = Anonymous.

Just to refine the previous snippet;

UPDATE #TABLE

SET #TABLE.Field1 = (SELECT emp_id-1 as emp_id, emp_birth_date as Field1

from table)