Okay I have a backup of an entire VM which runs SQL 2000.
For the particular database of interest:
- I have an MDF modified 3/13
- I have an LDF modified 4/1
Now I am not a SQL master by any means, unless you count being able to make sense of queries lol
For my objective I need to take these files and either:
Roll back the database to 3/13 essentially purging all these uncommitted transactions from the log bring the database back to where it was on 3/13 when that MDF was last modified.
Or second some how attach just the MDF alone so SQL doesn't even know the transactions in the LDF even exist because it doesn't have access to those logs.
I could be wrong but I'm thinking the first is easier except I don't know how to do it.
My endless searching gives me nothing but instructions on how to force SQL to commit all transactions currently sitting in the logs. That's one of the few things I already know how to do if I had to.
And in any case is certainly the reverse of what I'm trying to achieve with these logs.
Any help is appreciated.