Post reply

Create New Server from Existing Dev Server

  • February 4, 2005 at 7:22 am

    #87390

    I have a situation where I need to build a duplicate server, not for replication, just need to migrate the existing databases to the new server. Is there an automated way, if so how. Using backup & restore seems is currently our method, but surely there is another way.

  • February 4, 2005 at 7:36 am

    #540675

    you can use dts packages and schedule the same. you can also detach your existing databases, copy them over and  then attach the same. But this would be more a manual process.

  • February 4, 2005 at 7:43 am

    #540679

    I am aware of the DTS - Copy Sql Objects task, but first they must be define on the target server, correct?

  • February 4, 2005 at 8:59 am

    #540701

    Nope, you can use the copy database wizard and that would be helpful

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

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