Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Database Replication

I am currently in the process of planning an Orion implementation. I will have 2 servers that will be running SQL server. One will serve as the primary, the other as backup.

I've been told by Solarwinds support that there is no real-time replication of the database at this point. With that being the case, I'm wondering if I can schedule a nightly backup of the primary database and then a restore to the backup database. The Orion database mananager does include scheduling for the database but not for a restore. does anyone know if there's a way to do it within SQL server itself? Has anyone ever set up a failover scenario before? Thanks for the help.

Find more posts tagged with

Accepted answers

All comments

Network_Guru

I'm not an SQL expert, but have you looked at clustering?

-=Cheers=-
NG

HINT:

HOW TO: Use Replication with SQL Server 2000 Desktop Engine (MSDE 2000)
support.microsoft.com/default.aspx

BK
Nobody Special