Can I query Microsoft GP database and save the result as MDF file?

58 Views Asked by Root Loop At 31 January 2019 at 20:57

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

My questions:

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?

There are 0 best solutions below