I am a server administrator with some knowledge of SQL Server. I usually only support SQL configuration and performance and the maintenance of the underlying OS.
We are testing a backup strategy and I would like to set up a script that inserts records while we are doing the testing. Preferably one of the columns would be a date/time stamp so we can see what occurs during the backup and also once we try a restore, to determine if extra steps are needed to recover to a point in time.
Any help or links would be appreciated.