Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2003
    Location
    BANGALORE, INDIA
    Posts
    8

    Unanswered: Differential backup!!!!!!!!!!!!

    I want to take differential backup from server and transfer to other server. both having same data structure.

    but only differential could not possible to restore.

    is there any other way to pdate only the todays updates

    prince

  2. #2
    Join Date
    Apr 2003
    Location
    SC, USA
    Posts
    51
    Sounds like you need to consider replication.

  3. #3
    Join Date
    Nov 2003
    Location
    BANGALORE, INDIA
    Posts
    8
    Originally posted by loach
    Sounds like you need to consider replication.
    but i don't know nothing about Replication
    could u plz explain, and what about DTS , can u suggest the optimized solution for the above

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Getting an optimized solution will be a bit difficult from a forum. We have no access to what is required, what your resources are, how much data is involved, etc., etc.. In order to set up two separate servers with the same data you will need to look up a couple of topics in the Books Online (installed with SQL Server), so you can understand the basic concepts, limitations of both. Look for Log Shipping and Replication. Both of these (when properly set up) can give you the desired result of a backup or reporting server, but replication (for instance) does not replicate stored procedures, and has trouble replicating other schema changes. Log shipping will give you a read-only copy of the database, but requires enterprise edition of SQL Server.

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    You can use either replication (transactional or snapshot), log shipping, or full db restore. With DTS, unless you want to wipe everything prior to re-populating your data, it may require quite a bit of coding.

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    149
    If you decide to use Log Shipping, let me know. I compiled a document that outlines every step you need to do when setting up log shipping

    Originally posted by rdjabarov
    You can use either replication (transactional or snapshot), log shipping, or full db restore. With DTS, unless you want to wipe everything prior to re-populating your data, it may require quite a bit of coding.

  7. #7
    Join Date
    Nov 2003
    Location
    BANGALORE, INDIA
    Posts
    8
    i am using SQL Server 7(standard). One server in US and other server in Bangalore. I just want to update each days transactions only.

    and daily tranc. is max 1000 in one server. I went through both DTS and Replication. one doubt in DTS, is it possible to trasfer only each days transactions?.

    and how complicated for setting up the replication.

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •