|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
log shippingHi guys can anyone give me some pointers on how to set up log shipping with
SQL server 2000 sp4 standard edition. I was reading the following article but it seems the standard edition doesn't have the 'ship the transaction logs to other SQL serve(log shipping)' option? Any help would be much appreciated. Thank in advance. Geo The built-in logshipping is only available in SQL Server 2000 Enterprise
Edition. In other editions, you have to roll your own solutoins. Here's one example: http://www.sql-server-performance.com/sql_server_log_shipping.asp "Geo" <no@spam.com> wrote in message Hi guys can anyone give me some pointers on how to set up log shipping withnews:e8nKHowiGHA.3752@TK2MSFTNGP02.phx.gbl... SQL server 2000 sp4 standard edition. I was reading the following article but it seems the standard edition doesn't have the 'ship the transaction logs to other SQL serve(log shipping)' option? Any help would be much appreciated. Thank in advance. Geo Thanks Narayana I'll have a play about with that.
Geo Show quote "Narayana Vyas Kondreddi" <answer***@hotmail.com> wrote in message news:ubmXVswiGHA.3496@TK2MSFTNGP02.phx.gbl... > The built-in logshipping is only available in SQL Server 2000 Enterprise > Edition. In other editions, you have to roll your own solutoins. Here's > one > example: http://www.sql-server-performance.com/sql_server_log_shipping.asp > -- > HTH, > Vyas, MVP (SQL Server) > SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/ > > > "Geo" <no@spam.com> wrote in message > news:e8nKHowiGHA.3752@TK2MSFTNGP02.phx.gbl... > Hi guys can anyone give me some pointers on how to set up log shipping > with > SQL server 2000 sp4 standard edition. > I was reading the following article but it seems the standard edition > doesn't have the 'ship the transaction logs to other SQL serve(log > shipping)' option? > Any help would be much appreciated. > Thank in advance. > Geo > > > Geo,
there's also a utility called the Simple Log Shipper which was included in the SQL Server 2000 Resource Kit, which works with the standard edition. I've never used it in production, dut if you have access to the resource kit you might have a look at it. Markus Cheers Markus I'll check that out.
Thanks again guys for the help. Geo <m.bo***@quest-consultants.com> wrote in message Show quote news:1149790815.448887.174790@f6g2000cwb.googlegroups.com... > Geo, > > there's also a utility called the Simple Log Shipper which was included > in the SQL Server 2000 Resource Kit, which works with the standard > edition. I've never used it in production, dut if you have access to > the resource kit you might have a look at it. > > Markus >  |
|||||||||||||||||||||||
Other interesting topics