Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Moving databases to another instance using Service Broker? Expand / Collapse
Author
Message
Posted Monday, December 2, 2013 2:29 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 2:08 PM
Points: 30, Visits: 387
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
Post #1519024
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse