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...
> one
or
>|||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...
some
> warm
Kit
> is
on
have
> or
>|||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...
> only
> some
NOT
> Kit
this
databases
> on
> have
etc.)
>