Question Is there a way to force all database and log backups run on the server to be encrypted? If encryption is not specified, the query will be terminated. asked 2021-09-12 by Avi Answer Not in SQL Server There is no option to force BACKUP … [Read More]
Question For example, I had a database and I want to see which physical backup file was used to restore into it. The problem is that the database was deleted. How can I see the record? asked 2019-11-23 by sql-noob Answer Depending on how the … [Read More]
If you restore a database, what does that do to the plan cache? Well, let’s start by looking at the documentation for RESTORE. (Emphasis mine) Restoring a database clears the plan cache for the instance of SQL Server. Clearing the plan cache causes a recompilation … [Read More]
Copyright © 2025 | Andy Mallon | am2.co