Skip to main content
1 of 3

"I could use a tranlog backup, and then roll it to 12:01am"

Do that. You can restore a the last full backup, then apply log backups with NORECOVERY in the days or hours before the first of the month, then apply the last log backup with STOPAT and RECOVERY or STANDBY.

Or you could create a Database Snapshot at midnight.