First off thank you all for your patience as I am not a DB Guy. I am an Infrastructure Engineer.
I have been given a problem to find a solution for and I'd love to get your input on this.
My client has on a physical server (A), the following:
- MS SQL Server 2008R2
- MS SQL Server (Reporting Server)
The data base is backed up fully daily to another physical server (B).
What the client would like to do is:
- Backup just the Raw SQL Data with Tables and Views to Server B every 10 mins
Point to be noted is, there isn't any dedicated storage (NAS or SAN) just local disk storage on the server.
The reason for this is they want to run reports against this data every 10-15 mins...
How and what do I need to do to facilitate this? Can someone please point me in the right direction?