[c-nsp] easy way to re-route sql traffic down alternate link? - verify commands

[Matt Bazan]

Here's how I plan to set this up.  Looks very straightforward.  If
anyone would have a sec to point out problems I'd be very appreciative:

SanRafael#(config) access-list 110 permit tcp any any eq 1433 //ACL for
sql traffic
SanRafael#(config) route-map SQL-Traffic permit
SanRafael#(config-route-map) match ip address 110
SanRafael#(config-route-map) set ip next hop <address of 'C' router> 
	//should I use an interface instead of IP here to insure proper
route?
SanRafael#(config) int fa0/0 
SanRafael#(config-if) ip policy route map SQL-Traffic 
	//if i understand correctly, policy map needs to be applied to
interface that policy traffic enters on.

then setup reverse on the 'A' router.  anything else?  thanks again.

  Matt
  
> 
> 
> On Tue, Apr 12, 2005 at 10:21:37AM -0700, Matt Bazan wrote:
> > here's the goods:
> >                        /1  
> >                       /
> >             A--------B--2
> >              \      / \
> >               \    /   \3 
> >                \  / 
> >                 C
> > 
> > this is a partial diagram of our network showing 3 of our 4 
> hubs (A, 
> > B,
> > C) and some of the spoke branches (1, 2, 3).  In reality 
> there is one
> > more hub office and several more T1s connecting the hubs in 
> full mesh.
> > For simplicity sake I've diagramed as such to illustrate 
> what I need.
> > I'd like sql traffic from branch 3 to get to the sql 
> servers in branch A
> > by going through branch C (link between A and B is 
> completely stuffed).
> >