Disaster Recovery

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Disaster Recovery

Disaster Recovery

Rate Topic

Display Mode

Topic Options

Author

Message

rmcintire

Posted Friday, November 07, 2008 7:45 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, July 08, 2011 1:59 PM
Points: 9, Visits: 127

I am new to SRSS and SQL and I am looking into setting up our disaster recovery. i know enough to get around and do some of the basics so i am OK there. We currently run SQL 2005 on an active passive cluster. our SRSS databases are
on the cluster but not clustered. we have a web server users connect to to
pull reports. what i am trying to plan in disaster recovery is the failure
of the front end server and not the cluster (as of yet). I have read some
MSDN articles with some general guide lines on what to back up etc... I am
looking for something similar to what I have to give me a good starting
point. Basically I want to simulate the failure of my front end server and
replace it.

Also, I am looking for the physical location of the .rdl report files, etc to make sure they are backed up but can't find them.

Any leads in the right direction would be greately appreciated.

Post #598950

« Prev Topic | Next Topic »

Permissions