troubleshooting Question

MS SQL /cognos Backup and DR solution

Avatar of ChitagB
ChitagB asked on
Microsoft SQL ServerDB Reporting ToolsMicrosoft Legacy OS
3 Comments1 Solution490 ViewsLast Modified:
Hello,

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 :)

Thanks,
prod-dr.PNG
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
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