Hot answers tagged

5 votes

Understanding Full Backup Process in SQL Server: Do All Allocated Extents Get Backed Up?

Specifically, does the backup process include all allocated extents, even if not all pages within these extents are in use? Yes. Extents are the lowest unit of object allocation (technically since ...
Sean Gallardy's user avatar
4 votes

Whether to run integrity check before or after backups (Ola H FAQ)?

It really doesn't matter, either way, to be honest. If you run the backup first and then run the integrity check, you don't know if the backup is good - you know it ran. If you run the integrity check ...
Sean Gallardy's user avatar
1 vote

Failed MSSQL Backup Restoration Due to Defunct State in a File: How to Resolve?

I successfully resolved it by following these steps: Initially, I accessed the attached database and copied its physical files to another server. When attempting to attach the database to the new ...
Seyed Jafar Mousawi's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible