Skip to main content
2 votes
Accepted

error when re-applying the permissions script into the original database - sql server

You need to exclude internal tables using is_ms_shipped = 0. You also need to quote names correctly using QUOTENAME. You need to handle WITH GRANT OPTION correctly. You probably want to add AS ...
Charlieface's user avatar
  • 13.7k
2 votes
Accepted

Understanding Recovery Forks in SQL Server: Meaning and Significance

From the information I have gathered, I understand those GUID are kind of the DNA of the database and no matter how far on the kin line the database is, it shares info to identify itself and the first ...
Ronaldo's user avatar
  • 5,636
1 vote

Understanding Recovery Forks in SQL Server: Meaning and Significance

This article goes some way to answer some of your questions - albeit indirectly: https://stuart-moore.com/please-clean-down-your-sql-server-backup-history/ If you understand the Backup and Recovery ...
MHSQLDBA's user avatar
  • 234

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