troubleshooting Question
MS SQL /cognos Backup and DR solution
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
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
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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.