Browse the archive
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 DATABASE & …
Continue readingQuestion 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?
Continue readingIf 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 …
Continue reading
