Dear SQL Server experts,
Our client is hosting an application for many users, each user has its own database (stored at the server of our client). In this application there is an audit functionality integrated; all the changes that are done or logged in to two tables in the same
(user)database. When there is a problem the client copies the production database to the acceptance server, where we can investigate. Because the databases are over 5GB, the transfer can take a bit of time. A huge part of the data is stored in the audit tables,
so if we can split-up the audit this process could be a lot faster.
I’m trying to figure out the possible solutions, I already proposed to split the database into two different databases but the client wants to keep all the data in the same database.
Or there any other solutions (with minimal impact) that I should consider?
All databases or currently hosted on a sql 2000 server.
Thanks in advance,
View Complete Post