HI there I would like to ask the experts about the following:
We have a SQL 2005 server, running a Dynamics Axapta database. Understandibly uptime and continuity is crucial. The databse is roughly about 300GB.
I need to do the following:
1: Implement a high availability sollution for the database. For this I decided to do log shipping as we have had some problems in the past with mirroring. I am hoping to test this every week lets say on Fridays. 2: This same database for this scenario sake I will call it the "Live" database, needs to be backed up every night onto removable storage. I also need to have the significant transaction logs just incase we missed something on the transaction logs. 3: Again this same database will be used as a reports database (crystal reports) so a daily update will be required to keep this up to date.
Any suggestions will be much appreciated.