troubleshooting Question

MS SQL /cognos Backup and DR solution

Avatar of ChitagB
ChitagB asked on
Microsoft Legacy OSMicrosoft SQL ServerDB Reporting Tools
3 Comments1 Solution490 ViewsLast Modified:

We come across interesting request from one of our client.

Requirement : Provide Backup and DR(offline) solution for their mssql/cognos server with minimum cost

Possible solution : step 1) Take backup of prd server in to san/nas
                                      2) copy data from local san/nas to remote nas/san
                                      3) restore automatic data from remote san/nas in to remote server(Dr)

Questions : 1) Will it work for sql and congonos?
                   2) what will happen to sql permission?
                   3) Suggestion for specific tool/software?
                    4) What should be copied from sql and cognos?

Note: No scope for create fail over  . Do not require to have real time data repletion. client can afford to loss 1-2 hours of data

Any input are most welcome :)


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros