We have many blackbox MS-SQL Databases which means the databases acts as a backend to some payed applications we acquired. And unfortunately we also have inhouse developers who would really really like to read data from the production databases but because of locking and blocking mechanisms of SQL-Server I would like to avoid that situation by not grating them access to the live databases.
Please tell me if I go the right direction here and how you would solve such situation.
My thinking was that we should have either a clone of the databases by telling the application frontend to write the data seperately to 2 databases one used for reporting while one is used for live production system.
This works for applications which do support that approach however not all do support it on application level.
I heared about log shipping which would be a method SQL-Server itself could provide the tools.…