Resilience Options

Hi,
I have two new servers with a view to consolidating all our databases on one
server. We intend to use the other server for resilience. We do not have
enterprise licenses so Log Shipping is not an option
What would be the best practice - using replication (what method etc.) or
backup and restore
SActually log shipping is an option... You would simply have to write some
stored procedures to do the work yourself... Since replication does NOT
replicate system tables, in my opinion it is not the best option for a warm
stand-by...There were some stored procedures included in the Resource Kit
for SQL 7 you might try to find and enhance, or maybe you could find
something posted on one of the web sites to get you started... But this is
definitely something you could do ...
"BigSi" <webmaster@.shine.net> wrote in message
news:O#Q1O4gIEHA.308@.tk2msftngp13.phx.gbl...
> Hi,
> I have two new servers with a view to consolidating all our databases on
one
> server. We intend to use the other server for resilience. We do not have
> enterprise licenses so Log Shipping is not an option
> What would be the best practice - using replication (what method etc.) or
> backup and restore
> S
>|||Thanks for that Wayne,
I am aware of the facts that you can develop your own log shipping, my only
concern is that it is not support by MS
S
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:ujbctXhIEHA.1220@.tk2msftngp13.phx.gbl...
> Actually log shipping is an option... You would simply have to write some
> stored procedures to do the work yourself... Since replication does NOT
> replicate system tables, in my opinion it is not the best option for a
warm
> stand-by...There were some stored procedures included in the Resource Kit
> for SQL 7 you might try to find and enhance, or maybe you could find
> something posted on one of the web sites to get you started... But this
is
> definitely something you could do ...
> "BigSi" <webmaster@.shine.net> wrote in message
> news:O#Q1O4gIEHA.308@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > I have two new servers with a view to consolidating all our databases on
> one
> > server. We intend to use the other server for resilience. We do not have
> > enterprise licenses so Log Shipping is not an option
> >
> > What would be the best practice - using replication (what method etc.)
or
> > backup and restore
> >
> > S
> >
> >
>|||Yeah that's true...
"BigSi" <webmaster@.shine.net> wrote in message
news:etJQzlhIEHA.2908@.TK2MSFTNGP09.phx.gbl...
> Thanks for that Wayne,
> I am aware of the facts that you can develop your own log shipping, my
only
> concern is that it is not support by MS
> S
> "Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
> news:ujbctXhIEHA.1220@.tk2msftngp13.phx.gbl...
> > Actually log shipping is an option... You would simply have to write
some
> > stored procedures to do the work yourself... Since replication does NOT
> > replicate system tables, in my opinion it is not the best option for a
> warm
> > stand-by...There were some stored procedures included in the Resource
Kit
> > for SQL 7 you might try to find and enhance, or maybe you could find
> > something posted on one of the web sites to get you started... But this
> is
> > definitely something you could do ...
> >
> > "BigSi" <webmaster@.shine.net> wrote in message
> > news:O#Q1O4gIEHA.308@.tk2msftngp13.phx.gbl...
> > > Hi,
> > >
> > > I have two new servers with a view to consolidating all our databases
on
> > one
> > > server. We intend to use the other server for resilience. We do not
have
> > > enterprise licenses so Log Shipping is not an option
> > >
> > > What would be the best practice - using replication (what method etc.)
> or
> > > backup and restore
> > >
> > > S
> > >
> > >
> >
> >
>|||Maybe someone from MS can answer that for me''?/
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:%23u%2370ajIEHA.3144@.TK2MSFTNGP10.phx.gbl...
> Yeah that's true...
> "BigSi" <webmaster@.shine.net> wrote in message
> news:etJQzlhIEHA.2908@.TK2MSFTNGP09.phx.gbl...
> > Thanks for that Wayne,
> >
> > I am aware of the facts that you can develop your own log shipping, my
> only
> > concern is that it is not support by MS
> >
> > S
> > "Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
> > news:ujbctXhIEHA.1220@.tk2msftngp13.phx.gbl...
> > > Actually log shipping is an option... You would simply have to write
> some
> > > stored procedures to do the work yourself... Since replication does
NOT
> > > replicate system tables, in my opinion it is not the best option for a
> > warm
> > > stand-by...There were some stored procedures included in the Resource
> Kit
> > > for SQL 7 you might try to find and enhance, or maybe you could find
> > > something posted on one of the web sites to get you started... But
this
> > is
> > > definitely something you could do ...
> > >
> > > "BigSi" <webmaster@.shine.net> wrote in message
> > > news:O#Q1O4gIEHA.308@.tk2msftngp13.phx.gbl...
> > > > Hi,
> > > >
> > > > I have two new servers with a view to consolidating all our
databases
> on
> > > one
> > > > server. We intend to use the other server for resilience. We do not
> have
> > > > enterprise licenses so Log Shipping is not an option
> > > >
> > > > What would be the best practice - using replication (what method
etc.)
> > or
> > > > backup and restore
> > > >
> > > > S
> > > >
> > > >
> > >
> > >
> >
> >
>