Forum Replies Created

Viewing 15 posts - 451 through 465 (of 1,790 total)

  • RE: Replicating and Recovery Model

    Pei Zhu-415513 (12/20/2010)


    If the database is simple/or bulk logged database, will the minimally logged activities such as rebuild indexes be replicated to subscribers?

    Those activities are not replicated. It would be...

  • RE: Slow transactional replication reinitialize

    Elliott Whitlow (12/17/2010)


    That 14hours is probably better than it would be if it was 32-32..

    Are the database files pre-sized? If not then it will spend a lot of time...

  • RE: Slow transactional replication reinitialize

    If it is busy and you have memory limitations already then that would certainly impact things. Do you know how long the copy process is taking vs the applying of...

  • RE: 3rd Party Auditing Tool

    Would Change Data Capture work? Curious.

  • RE: Are the posted questions getting worse?

    Jack Corbett (12/17/2010)


    Side note. Anyone ever had an MRI? I was scheduled to have one yesterday afternoon and, being a bit claustrophobic, the doctor prescribed Xanax for...

  • RE: 3rd Party Auditing Tool

    Couldn't you just query their data and pull the most recent record prior to the event you are interested in?

  • RE: cant see to find whats causing this error in my 2005 cluster

    Oh, you would run that query on the distribution database on the distributor. You would also find the job there.

  • RE: cant see to find whats causing this error in my 2005 cluster

    ron morgan (12/17/2010)


    Message

    Error: 14151, Severity: 18, State: 1.

    Message

    Replication-Replication Distribution Subsystem: agent (null) failed. The publication 'Temp_Report_Requirements_DM01' does not exist.

    It looks like you have a distribution agent that is running against...

  • RE: Under Appreciated Features

    As Andy already mentioned, missing indexes in the graphical plan is a huge plus. They are usually pretty accurate or pretty close making it pretty helpful.

    I will have to...

  • RE: Help Required regarding Merge replication

    Unfortunately no I don't. Merge replication is by nature more expensive than other types of replication. Still viable is using transactional with updateable subscriptions. That however doesn't allow for the...

  • RE: SPLITTING A STRING

    Yeah, I will have to play with it a bit more as well. Also want to play with a tally table version to see what it does.

    One other thing...

  • RE: Help Required regarding Merge replication

    sharad-1144828 (12/16/2010)


    Hi All,

    I have 3 servers and want to apply merge replication for this as A to B to C to A.

    Can some one please guide me how to implement...

  • RE: Slow transactional replication reinitialize

    Great! If you have time reply back with what you find helpful as it may be good information for the future.

  • RE: SPLITTING A STRING

    Hey Jeff - I certainly like that function better than most that I have seen and used. One question I do have though; have you noticed that it always seems...

  • RE: Slight Problem :(

    If you do have a tape backup you can still take a log backup and do a point in time restore. Again, all hinging on the full backup existing.

    Honestly...

Viewing 15 posts - 451 through 465 (of 1,790 total)