Scenario:
Database consists of these file groups:
PRIMARY
xxTEST2
xxTEST3
xxTEST4
Database consists of the following files in those file groups:
xxTEST_RESTORE - Rows Data - PRIMARY - xxTEST_RESTORE.mdf
xxTEST_RESTORE2 - Rows Data - xxTEST2 - xxTEST_RESTORE2.ndf
xxTEST_RESTORE3 - Rows Data - xxTEST3 - xxTEST_RESTORE3.ndf
xxTEST_RESTORE4 - Rows Data - xxTEST4 - xxTEST_RESTORE4.ndf
xxTEST_RESTORE_log - Log - N/A - xxTEST_RESTORE_log.ldf
2 tables are created with row:
dbo.COUNTRIES
dbo.CUSTOMERS
Then a full database backup is performed, and rows are added to the Customers
table.
Question:
Want to add 1 record and have a backup of this
Want to add a 2nd record and have a backup of that
Want to roll back to the previous time when the 1st record was added (Q #1 above)
Should I perform a TRANS LOG backup after adding the 1st record or a FileGroup backup?
What order of backups should I perform to ensure I can roll back properly as I keep getting errors that either the database is in restore mode, doesn't like the trans log I pick, etc....
Looking for the proper sequence for backup and then restore
INSERT
s. If so, then using backups seems like a very awkward solution, you might consider using row versioning or timestamps instead. But your aim here isn't totally clear, so I may have misunderstood.