Moving databases to another instance using Service Broker?

  • Hi,

    We have a couple of production instances with many databases on SQL Server 2008 Std.

    I want to implement an automated process to move inactive databases on multiple instances to a dedicated instance for inactive databases, back and forth. A trigger on a status column on a user table will initiate the move out/in process.

    Do you think Service Broker can be used for this purpose?

    Thanks,

    Kuzey

Viewing 0 posts

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