A naukri.com initiative
Dbi-Services
1w
281
Image Credit: Dbi-Services
Random permission denied when backing up SQL Server databases to AWS Storage Gateway
- When hosting SQL Server on AWS EC2 instances, a backup strategy is crucial.
- AWS S3 is a reliable option for persisting and archiving backups securely.
- Using AWS Storage Gateway with File Gateway as an intermediary service is necessary for backing up to S3.
- To address the 'Access is denied' error during backups, enabling Trace Flag 3042 can be a workaround.
Read Full Article
16 Likes
For uninterrupted reading, download the app