Home Forums SQL Server 2008 SQL Server 2008 - General Archieving Data RE: Archieving Data

  • May 6, 2015 at 6:06 pm

    #1796089

    Lynn Pettis (5/6/2015)

    ramana3327 (5/6/2015)

    We are using Sql 20082 Standard edition. Data drive has enough free space but that table stores the errors that we don't required to store more than 3 months.

    To do this data archiving we need to have linked server otherwise we can't able to do that process b/n servers

    Going between servers I would use SSIS to archive the data on another server. Wouldn't require the use of linked servers.

    Jeff, I know, you would not use SSIS as you have trouble even spelling it. 😀 😉

    I might not know how to spell it but I do know that it's a 4 letter word in my book. 😉 I also love it when folks say they would use SSIS to do such-and-such but don't show how to do it. "It's easy to get to the Moon... just build a rocket ship!" :hehe:

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)