Post reply

data file migration..

  • May 7, 2012 at 8:55 am

    #255460

    Hi,

    As i face one interview question in my call that is If i create one data file in primary server then how it will replicate in Secondary server ?

    How can we troubleshoot it..

    I can appreciate if any one give sol....

  • May 7, 2012 at 9:03 am

    #1484093

    Question doesn't make sense.

    Data files don't 'replicate', databases do and only if there's something set up to copy the database to another server.

    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

  • May 7, 2012 at 9:09 am

    #1484096

    Thanks for your reply .... I meant to say that the servers are configured logshipping and one of the server has introduced one new data file added. So how it will be replicated to secondary server.

    Please let me know...

  • May 7, 2012 at 9:22 am

    #1484102

    Why don't you test it out and see? That's a very easy thing to try out on a local instance of SQL and you'll learn far more from trying it than you will from someone telling you the answer.

    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

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

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