Encrypt backup files and send them to AWS S3

I have a backup routine via crontab on Ubuntu. This routine generates a compressed tar.gz file and sends it to AWS S3.

But I want to encrypt these files and be able to decrypt them when necessary on another machine only if I have the private key.

While searching I found gpg, and I execute the command below to compress the backup file:

gpg --output my-backup-file.tar.gz.gpg --encrypt --recipient secret-key-mail-address@example.com my-backup-file.tar.gz 

Is this a safe and good way to encrypt these files?

A Wayback Machine Backup Of My Old GSA SER Tutorials.

I need my personal blog for my new project and YouTube channel and I’m going to start it over from scratch next month so here is a Wayback machine backup for all of my old GSA SER Tutorials if anyone needs them.

The Importance Of Using Naming Conventions In SER! – https://web.archive.org/web/20200520204634/http://shaunmarrs.com/naming-conventions-ser/
My Opinion On Reverse Proxies And How To Use Them In GSA Search Engine Ranker! – https://web.archive.org/save/http://shaunmarrs.com/opinion-reverse-proxies-using-gsa-search-engine-ranker/
How To Build The Ultimate Auto Accept List For SEO Tools! – https://web.archive.org/web/20200520205025/http://shaunmarrs.com/ultimate-auto-accept-list/
How To Build Your Own Auto Accept List With GSA Search Engine Ranker! – https://web.archive.org/web/20200520205113/http://shaunmarrs.com/auto-accept-list-ser/
How I Choose, Setup And Optimise My VPS’ And Servers! – https://web.archive.org/web/20200520205209/http://shaunmarrs.com/setup-and-optimise-vps/
An Introduction To Building Your Own Auto Accept List! – https://web.archive.org/web/*/http://shaunmarrs.com/introduction-building-own-list/
Transforming Profile and Forum Engines In To Contextuals In Less Than 30 Seconds! – https://web.archive.org/web/2019*/http://shaunmarrs.com/profile-and-forum-contextual/
The True Indexing Potential Of The GSA SER Platforms! – https://web.archive.org/web/2019*/http://shaunmarrs.com/indexing-ser-platforms/
The Difference Between Getting 1% Or 98% Of Your Links Indexed! – https://web.archive.org/web/2019*/http://shaunmarrs.com/1-and-98-of-your-links-indexed/
The Kitchen Sink Tier And How 97% Of Their Links Maybe Useless To You! – https://web.archive.org/web/2019*/http://shaunmarrs.com/why-i-hate-kitchen-sink/
The Increasing Problem Of Link Retention When Using Auto Generated Content! – https://web.archive.org/web/2019*/http://shaunmarrs.com/link-retention-auto-generated-content/
How To Filter Out Useless Footprints To Massively Improve Your Target Scraping Speed! – https://web.archive.org/web/2019*/http://shaunmarrs.com/footprints-in-gsa-search-engine-ranker/
How To Easily Post To Self Hosted Domains With GSA Search Engine Ranker – https://web.archive.org/web/2019*/http://shaunmarrs.com/post-to-self-hosted-domains/
607 Links Per Minute With Free Public Proxies! – https://web.archive.org/web/2019*/http://shaunmarrs.com/case-study-public-proxies/
How To Easily Manage All Your Backlinks In One Place! – https://web.archive.org/web/2019*/http://shaunmarrs.com/how-to-easily-manage-all-your-backlinks-in-one-place/
A 5 Second Task To Strengthen Your Contextual Tiers In GSA Search Engine Ranker. – https://web.archive.org/web/2019*/http://shaunmarrs.com/contextual-engine-selection-in-gsa-search-engine-ranker/
How To Build Tier Three Projects That Run At Over 900 Links Per Minute! – https://web.archive.org/web/2019*/http://shaunmarrs.com/944-links-per-minute/
Stop Wasting Your Time With The Built In GSA Search Engine Ranker No Follow Filter – https://web.archive.org/web/2019*/http://shaunmarrs.com/gsa-search-engine-ranker-no-follow-filter/
How To Increase The Quality Of The Targets On Your GSA Search Engine Ranker List! – https://web.archive.org/web/2019*/http://shaunmarrs.com/increasing-the-domain-quality/
An Increase Of 223% In Contextual Verified Links Per Minute With GSA Search Engine Ranker! – https://web.archive.org/web/2019*/http://shaunmarrs.com/increase-in-contextual-verifieds-per-minute/
Why The Native GSA Search Engine Ranker Web 2.0 Engines Are A Waste Of Time! – https://web.archive.org/web/2019*/http://shaunmarrs.com/gsa-search-engine-ranker-web-2-0-engines/
GSA Search Engine Ranker, The Ultimate Metrics Per Minute Breakdown! – https://web.archive.org/web/2019*/http://shaunmarrs.com/metrics-per-minute-showdown/
Essential GSA Search Engine Ranker Maintenance To Keep Your Rig Running Smoothly! – https://web.archive.org/web/2019*/http://shaunmarrs.com/gsa-search-engine-ranker-maintenance/
From 76 LPM to 763 LPM With GSA Search Engine Ranker Using A Simple 12 Hours Process! – https://web.archive.org/web/2019*/http://shaunmarrs.com/from-75-77-lpm-to-763-33-lpm-in-gsa-search-engine-ranker/
How To Filter Your GSA Search Engine Ranker Lists For A Potential 963% Increase In LPM! – https://web.archive.org/web/2019*/http://shaunmarrs.com/how-to-filter-your-gsa-search-engine-ranker-lists/
A Little Role Play To Explain Why You Should Filter Your GSA SER Verified Lists. – https://web.archive.org/web/2019*/http://shaunmarrs.com/a-little-role-play-to-explain-why-you-should-filter-your-gsa-ser-verified-lists/
The Ultimate Guide To GSA Search Engine Ranker! – https://web.archive.org/web/2019*/http://shaunmarrs.com/the-ultimate-guide-to-gsa-search-engine-ranker/

Unable to open default database after delete and restore it with a backup from another computer

I’m using SQL Server 13.0.4259.

I have created an user for my database with this script:

— Create TRZF db user.

USE [master] GO  if not exists(SELECT name                  FROM [master].[sys].[server_principals]                WHERE name = N'trzf_user') begin     CREATE LOGIN [trzf_user] WITH PASSWORD = '**********', DEFAULT_DATABASE=[$  (DatabaseName)], DEFAULT_LANGUAGE=[Español] end  USE [$  (DatabaseName)] GO  IF NOT EXISTS (SELECT name                  FROM [sys].[database_principals]                 WHERE name = N'trzf_user') Begin     CREATE USER [trzf_user] FOR LOGIN [trzf_user] WITH DEFAULT_SCHEMA=[dbo] end ALTER ROLE [db_datareader] ADD MEMBER [trzf_user] ALTER ROLE [db_datawriter] ADD MEMBER [trzf_user]  GRANT EXECUTE TO [trzf_user]  GO 

But I have had to delete it and restore it from another client’s database. After doing that, I have tried to login with the user trzf_user, using Management Studio, but I get this error message:

Unable to open user default database. Login error. Login failed for user 'trzf_user'. (.Net SqlClient Data Provider) 

I have tried this script:

USE [master] GO  ALTER LOGIN [trzf_user] WITH DEFAULT_DATABASE=[TRZIC-F] GO  USE [TRZIC-F] GO  IF NOT EXISTS (SELECT name                  FROM [sys].[database_principals]                 WHERE name = N'trzf_user') Begin     CREATE USER [trzf_user] FOR LOGIN [trzf_user] WITH DEFAULT_SCHEMA=[dbo] end ALTER ROLE [db_datareader] ADD MEMBER [trzf_user] ALTER ROLE [db_datawriter] ADD MEMBER [trzf_user]  GRANT EXECUTE TO [trzf_user]  GO 

But I’m can’t login.

How can I fix this problem?

I have run all the scripts and restored the database using sa user.

Before deleting the database, I can login with user trzf_user.

sp_AllNightLog – Not restoring differential backup at the start of the process

I have setup [sp_AllNightLog] and running backups in production site with no issues. I have FULL, DIFF and LOG backups happening.

Using version 3.5 and sql 2014 build 12.0.5659.1

When I run [sp_AllNightLog] @restore = 1, @debug= 1 I see that it finds the FULL the backup and restores that. I do not see it restoring the DIFF file. Right after the FULL backup is done it goes right to the LOG files but doesn’t actually restore them. I see messages like this: EXEC (‘RESTORE HEADERONLY FROM DISK=”\sqlbackups\sqlbackups\CASANDB04$ DB04\CentralAuthentication\LOG\CASANDB04$ DB04_CentralAuthentication_LOG_20200413_140002.trn”’) No Log to Restore

Should backup jobs be partitioned by type and applicable regulations of data?

Looking at how Microsoft categorizes data, customer data can be broken into a few different categories:

  • Customer Data
  • Customer Content
  • Personal Data

Should backup jobs be configured in a way to support special needs, such as

  • retention
  • deletion (partial or impartial for right to be forgotten)
  • access control (catalog, or metadata)

What things SQL Server takes backup of when we run a full backup

Like I am trying to ask that, suppose we run a full backup using GUI or T-SQL, which file SQL Server takes backup of i.e, only data file or log file as well.

I have read that it takes active transaction portion (Log File) of SQL Server as well. please confirm.

If yes, then what will happen to a transaction that was running at that time, and committed next, logs of the transaction will there on backup or not.

how will sql server revert back to it, if the database fails.