I have a request as below for auditing purpose on Microsoft Dynamic GP database.
- Database files are required as .mdf and .ldf files for certain companies
- Only need the certain period time of data, not entire database from day 1 till now
Is this even possible to provide only certain period time of activities from database as .mdf file? I mean if the .mdf file is required, it must be the entire database right?
If it is possible, how? Query the database for everything happened in that period of time and save it as .mdf file and .ldf file? Or somehow somewhat cut the .mdf file? I don't think so...
or if I provide entire database with only that period of transaction log?
I posted this question on overflow, It should be posted here.