Post reply

sql2000 restore (MOM 2005 DB)

  • June 9, 2009 at 2:48 am

    #210349

    Hi all,

    Did a search to no avail.

    I have a MOM 2005 onepoint database that resides on sql2000 sp4, or at least I did until it was groomed from 42gb to 1.5gb.

    I have a full backup from a week ago.. is there a way to restore the backup into the live database without loosing the 5 days since the groom?

    thanks for your time, I am by no means proficient with sql so any help is greatly appreciated.

  • June 9, 2009 at 4:14 am

    #1006559

    Could you please clarify your question: your database has grown from 42GB to 1.5GB????:w00t:

    You can approach the following way:

    1. Restore the backup to a new database, say TestDB.

    2. Run a tablediff on both the DBs.

    3. Then you can copy the required tables to TestDB, using DTS.

    4. Run the 'tablediff' once again.

    If there is no differences between the tables in both the DBs, you are done!:-)

    Thanks & Regards,
    Sudeepta.
    http://twitter.com/skganguly

  • June 9, 2009 at 4:25 am

    #1006566

    sorry...

    the mom db was 42gb on the 1st

    the mom db was groomed down to 1.5gb on the 5th

    please excuse my ignormace but could you be more specific on what I need to do... and what the actions actually do.. even something you consider simple like "copy tables" is beyond me. I am more platform based as opposed to db.

Viewing 3 posts - 1 through 2 (of 2 total)

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