standby server

[linea]

Hi

Could you suggest me some of the ways to have standby database server?

All of a sudden my company is in a need for standby database server in sync upto the 10 minutes. Main production database is about 8 GB. It serves almost 6 main sites for the company. No body in my group has worked with standby server issue before.

Any suggestion would help.

Thanks,

Linea

[Jim Steiner]

Try using log shipping. It is not built in like it is in 2000, but it can be done. Check out the SQL Server Magazine web site (www.sqlmag.com). They had an article on setting it up in the 2000 Dec. issue.


------------
linea at 12/28/2001 12:36:02 PM


Hi

Could you suggest me some of the ways to have standby database server?

All of a sudden my company is in a need for standby database server in sync upto the 10 minutes. Main production database is about 8 GB. It serves almost 6 main sites for the company. No body in my group has worked with standby server issue before.

Any suggestion would help.

Thanks,

Linea

[TimS]

We use Legato Co-Standby server...
Versions for UNIX(various flavours) or NT or 2000
http://portal1.legato.com/products/costandbyserver/

Hope this helps

TimS


------------
linea at 12/28/2001 12:36:02 PM


Hi

Could you suggest me some of the ways to have standby database server?

All of a sudden my company is in a need for standby database server in sync upto the 10 minutes. Main production database is about 8 GB. It serves almost 6 main sites for the company. No body in my group has worked with standby server issue before.

Any suggestion would help.

Thanks,

Linea