I am totally clueless as to the workings of SQL. In spite that I have been using a program the "uses" SQL 2008 - I don't really understand how it works.
To wit: I recently found I was backing up ALL WRONG.
In 10/18/2018 I did a substantial update (merge/purge) of my DB and found - too late - that I had done it wrong and discovered I was not able to restore to the previous date.
I've been able (after much research and struggle) didn't to find the 10/17/2018 version of my data and I'm hoping I can' "restore" or otherwise get my data back to that version.
BELOW are the Directories of my DATA folder for 11/7/2018 and 10/17/2018 respectively.
It APPEARS only data in file GOLDMINE.mdf and file modellog.mdf have been altered (judging by size)
Can I simply copy the older GOLDMINE.mdf and modellog.mdf to resore my database to the earlier position?
I suspect it can't POSSIBLY be that easy.
TIA for helping my to screw this up anymore than I already have. Jim Gunther
|File=Microsoft SQL SERVER\MSSQL10_50.MSSQLSERVER\MSSQL\DATA||older DB Size||Current DB||Size|