Skip to main content

New answers tagged

0 votes

Restore issue with Pgbackrest

Wild guess here, check the filesystem type. We had trouble restoring the Postgres cluster on Kubernetes platform using the pgbackrest tool, if the persistent volumes (disks) for Postgres and ...
Martin's user avatar
  • 1
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
0 votes

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

Charlieface's anwer is the one I am going to accept, it is very good. The only reason I am posting here, it is because his query did not work on my environment mostly due to COLLATE issues,and I love ...
Marcello Miorelli's user avatar
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

Top 50 recent answers are included