Category: MSSQL


Clear mssql cache

If you for example need to test a query against two SQL servers hardware, its a good idea to clear the cache first.This query can do this:


MSSQL Backup History Query

To see MSSQL history Query, run this SQL query. It will show all backups between the 1 january 2021 and 1 february 2021, order by Database and then Last backup time. It will also...


mssql get the backup information with copy_only information.

I need to find a way to see if the backup chain where broken. On my search I found this could script, created by “hot2use”I have found this script on a forum. The script...