Post reply

Back up

  • May 29, 2009 at 2:30 am

    #132703

    Hi,

    iam new to DB back ups, but i need to work for it.

    we have a live DB and need to push data for every 2 hrs to test DB(which is on same server) and test DB is used for reporting.

    Here tables of DB don't have PK's and not suitable for transactional replication.

    There is limited space available on system so snap shot is not feasible as it locks up much resources.

    Log shipping will not work based upon our requirements . Do i considered using procedures or SSIS ?If so please advise me the process.

    thanks

    --Ravi

  • May 29, 2009 at 3:03 am

    #1001940

    SSIS will do, but when you say that the tables havent got a Primary key it will be process intensive to get the last 2 hours of data and transfer them to the next one, you can also use a bulk insert ( well an older form of DTS or SSIS) 🙂

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

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