Thanks, Dude! I Didn't know, i am still new to this forum.:-)

EnjoY!

Leo.Miller (11/15/2009)

---

I've built a SQL 2008 Cluster but SSRS only installed on the first node. When I added the 2nd node it didn't install SSRS on this node AND I...

Other 3 instances are also 2008 SQL?

EnjoY!

Yes, You should have clean up job running on distributor, and check the retention time for the old files.

EnjoY!

ToddJames (2/21/2010)

---

Our company is getting ready to implement EMC's Replication Manger. Are there any 'Gotcha's' we need to know about (from a SQL prespective) before our kickoff meeting tomorrow?...

Check this out.

http://support.microsoft.com/kb/110139

EnjoY!

san-1015392 (2/19/2010)

---

hi ..i have one domain called x and there is a db over there..but i want to take a backup and it has to be stored in diff. domain...

Turn of the agents before shut down.

EnjoY!

ziangij (2/19/2010)

---

thanks...

i just checked it out.. without indexes, update query takes 30 sec.

with the indexes in places, it takes 2 min !

RBarryYoung (2/17/2010)

---

I think that it depends on a number...

May be all the transactions are not completely copied to subscribers from distribution database.

Check Clean up job running on distributor. Is this database in simple recovery model?

You should be...

Check this out.

http://msdn.microsoft.com/en-us/library/cc949109.aspx

EnjoY!

dba_neo (2/18/2010)

---

Team,

My Maintenanceplan had failed stating the error as

SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting...

Here is the preferred order we do in our environment.

Distributor, Publisher and Subscriber.

When bringing up.

Distributor, Subscriber, and Publisher.

EnjoY!

There is not point in running both backups same time, why don't you schedule t log after full backup? Yes, i think you will miss the updates, it will also...

Can you please run this, i believe this SQL 2005 instance.

select name, is_read_only, state_desc from sis.databases.

If you see is_ready_only column value as '1' for the DB you have issue,...