Post reply

Transaction log is created for all..DBs

  • July 7, 2009 at 2:23 am

    #132488

    Dear All,

    I have 2 servers and I want to do:

    1.Read Transaction log continuosly schedule it and apply it to another server.

    2. I want to do it for particular DB

    Issues:

    3.I have not the permission of log shipping.

    4.Transaction log is created for all..DBs

    CAN I EXECUTE TRANSACTION LOG FROM ONE SERVER TO ANOTHER??????

    Thanks

  • July 7, 2009 at 2:36 am

    #1020922

    Log shipping really is the way to do this. The only other way I can think of (other than DB mirroring) is to use a 3rd part log reader. However as far as I know they aren't automated.

    What are you trying to achieve here?

    What do you mean by "Transaction log is created for all..DBs"

    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

  • July 7, 2009 at 2:46 am

    #1020926

    "Transaction log is created for all..DBs"

    This line is my mistake but I was not able to edit it....Sorry for this..

    Gail...I have only the port 1433 open between client and server and I want to copy-paste the entire database to server.So replication,log shipping,mirroring is not possible.

    Either I will create DTS or SSIS package but I can't create it very fine.TSQL is also not known for this processes...Linked server is a possibility.

    Is there any other option....

    Thanks

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

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