Transactional Logs Restore

Testing Transaction Logs restore

Assigning Result Set Column Names

Delete Change Tracking table data sys.syscommittab

With high transactions table the sys.syscommittab table does not gets deleted properly. Millions of backdated row remains. To delete the sys.syscommittab table below is the script.

Delete Files in Shared Location/SAN

Delete files via TSQL procedure in shared location

Restore Redgate Transaction logs files via SQL

The script will restore the all the transaction logs files generated by Red Gate after extracting into .trn files.

TSQL