5
votes
Accepted
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 ...
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 ...
1
vote
Accepted
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 ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
backup × 2860sql-server × 1155
mysql × 541
restore × 496
postgresql × 330
mysqldump × 227
sql-server-2012 × 163
transaction-log × 161
oracle × 157
sql-server-2008-r2 × 124
sql-server-2008 × 106
sql-server-2014 × 102
replication × 100
rman × 99
sql-server-2016 × 84
recovery × 73
percona × 73
innodb × 71
mariadb × 68
availability-groups × 67
ola-hallengren × 66
mongodb × 56
sql-server-2005 × 56
pg-dump × 43
maintenance-plans × 41