Post reply

Transactions deleted in production and stage table only populating new data

  • January 23, 2012 at 5:02 am

    #267012

    Please help?

  • January 23, 2012 at 5:14 am

    #1437026

    Not enough information to help you.

  • January 23, 2012 at 8:54 am

    #1437180

    Help with what?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 23, 2012 at 9:08 am

    #1437183

    Thread title ‘Transactions deleted in production and stage table only populating new data’ suggests few things but not sufficient to help you.

    I assume you lost few transaction records in PROD server. You want to restore them from STAGING (or some other) server. You might not be having backups (yup... we hear it a lot) for restore. If you don’t have sufficient backups & lost transactions are not captured in another server properly, it would be difficult to restore lost transactions.

    If you correct my assumption, I will try to help you.

  • January 23, 2012 at 9:36 pm

    #1437459

    Hi,

    I have another table in production I can work with. Some data gets purged in production and then my staging tables goes out of sync. Just thought there might be a way to compare production to staging but without truncating the whole table. Anyway, I will use the other table in production to create a fact table and join in my cube.

    Thanks

    Sue

  • January 24, 2012 at 1:33 am

    #1437495

    Sure, tonnes of ways to compare tables.

    There's an exe that's part of the SQL Server installation called TableDiff (http://msdn.microsoft.com/en-us/library/ms162843.aspx), if you have linked servers you could use EXCEPT, or OUTER JOINs or IN/EXISTS. You could also buy a tool that specifically does data comparisons (Redgate's SQLDataCompare)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 24, 2012 at 11:20 pm

    #1438090

    Thank you so much for the info! Much appreciated.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply