Copying Production Data to Test Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cheryl - 16 Jun 2008 21:51 GMT

I need to copy the data from my queues that are on my Production
Server to my Test Server which is setup exactly like my Production
Server. I have been looking at Routing to get a copy of the data sent
to Production to my Test Server, but upon further reading I am sure if
this is what I really want to do. Can someone tell the best way to
get a copy of what is in my Production queues to my Test Server.

Thank you,

Reply to this Message

Roger Wolter[MSFT] - 28 Jun 2008 20:50 GMT

Backup and restore is the easiest and most reliable way to create a copy of
your queues and other SSB structures. It's not clear to me why you would
want to transfer messages. You can't transfer the messages exactly because
that could cause the same message to be sent from two different systems
resulting in possible data loss. A safer course would probably be change
the logic that send the messages to send two copies on two different dialogs
to the production and test systems - if that's what you're trying to do.

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

>I need to copy the data from my queues that are on my Production
> Server to my Test Server which is setup exactly like my Production
[quoted text clipped - 4 lines]
>
> Thank you,

Reply to this Message