Questions tagged [backup]
Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.
2,378
questions
0
votes
0answers
38 views
sqlcmd command doesnt work in bat file [closed]
I have a strange problem.
I want to do backup of my data bases via sqlcmd command.
If I write all command directly at cmd, everything works properly.
If I save it as bat file and run I have error. Why?...
-3
votes
0answers
22 views
Can a specific table be made immune to backups? [closed]
Can a specific table in a database be flagged as immune to backups so that an attacker who has compromised not only your database and web server application source code, except also all of your on-...
2
votes
1answer
42 views
How does Automatic Seeding work - Always On Availability Group
I found only these two statements from BOL regarding this Initial Data Synchronization method:
Link 1
Automatic seeding uses the log stream transport to stream the backup
using VDI to the secondary ...
0
votes
2answers
44 views
Transaction log backup after full backup is too big
Our current production database performs a full backup daily at 7AM. The transaction log backup takes place every 15 minutes (24/7).
Database version: Microsoft SQL Server 2014 - 12.0.4100.1 (X64)
...
0
votes
1answer
50 views
Analyse differential backup to see why it is so big
We quickly have very big diff files. Although the database is a highly transactional database, there is also a lot of data at rest.
1 or 2 days after a full backup was taken, the diff backup is bigger ...
-1
votes
0answers
22 views
Slow backup for RDS Postgres
We have an event processing system based on Postgres (RDS) that sees a very high number of writes. We noticed that scheduled backups for it take over 8 hours on average. We run the backups once every ...
1
vote
2answers
21 views
PostgreSQL - Base Backups and PITR
According to the PostgreSQL documentation for producing Standalone Hot Backups:
These are backups that cannot be used for point-in-time recovery, yet
are typically much faster to backup and restore ...
1
vote
0answers
12 views
Xtrabackup 8.0 Error
I'm using Percona MySQL 8.0.20 running on Ubuntu 18.04 on an AWS ec2 m5.2xlarge instance. The Xtrabackup version being used is 8.0.14.
While testing the restore process, I'm getting the error as ...
0
votes
1answer
30 views
Need for backup with Active Dataguard
When exploring the features of Oracle Active Dataguard, I found that one of them is block change tracking to allow the standby db to take the load of backups instead of the primary database doing them....
0
votes
1answer
11 views
Restore rman backup on another server with a higher Oracle release
I would like to know if it is possible to restore a full backup made with rman of an Oracle9i Enterprise Edition Release 9.2.0.6.0 on another server with Oracle9i Enterprise Edition Release 9.2.0.8.0, ...
0
votes
0answers
22 views
Corrupted tables after restoring base backups
I have a task of upgrading the current DB in the server from version 8.2.4 to version 12.4.
I am testing it out in the DEV staging server first.
The steps I have done :
1)Copy the base backup for the ...
0
votes
0answers
23 views
Cross-account backup RDS PostgreSQL to S3
I have a RDS PostgreSQL multi-AZ instance (in the "production" aws account). The database size is 43Gb.
I want to create a backup to a S3 bucket located in another account (the "backup&...
0
votes
1answer
15 views
Restoring schemas with the sequences
This evening a developer asked to restore only schemas from a database into another database.
A colleague of mine did this, but after that the developer came to me saying that the sequences are ...
0
votes
1answer
24 views
Proper way of restoring base backups
We have daily backups of a postgres db and it is in the form of a tarred (gz) base backup.
I need to restore this into another db of the same version. However, I am confused with the article that I am ...
1
vote
1answer
35 views
MYSQL Huge Data migration (5TB) from old server to new server
We have an old MYSQL server contains huge data ~5TB and wanted to migrate to the new server in order to minimize the costs and get rid of very old hardware.
My one and only idea in my mind is using ...
0
votes
0answers
16 views
Oracle Filter Full Transportable Backup for Schema
I need to use DBMS_DATAPUMP to make a full and transportable backup from my oracle DB for all objects related to a specific schema.
I was looking for something like INCLUDE=SCHEMA:"LIKE 'SCHEMA_1%...
0
votes
0answers
14 views
How to do incremental backup with limited privilege in mysql?
Envļ¼MySql Community v5.7 @AWS RDS
User Privs: Select_Priv, Create_View, Show_View, Show_Db, Execute, Create_tmp_table
binary_log: ON
Currently I can do full backup using mysqldump --single-...
3
votes
1answer
50 views
Incremental backups: MySQL Enterprise Backup vs Percona XtraBackup?
We're evaluating two tools incremental backup: MySQL Enterprise Backup and Percona XtraBackup. The only comparison I found is by Percona which has obvious cause for bias From this comparison, Percona ...
0
votes
1answer
17 views
Logical Backup strategy in large Oracle Databases
in Oracle databases, I would like to know if it is advisable to make logical backups with exp or expdp in large databases with large volumes of data, greater than terabyte, I have seen several systems ...
0
votes
0answers
47 views
SQL Server Differential Backup Size
The setup is SQL Server 2008 R2:
Full Backup - Weekly ~1.1TB
Differential - Every 4 hours ~66GB
Transactional - Every hour
What I want to know is why is the very first differential backup about 60GB,...
0
votes
0answers
29 views
EMC Legato NSR_DATA_VOLUME_POOL in Rman script
How to put the NSR_DATA_VOLUME_POOL parameter in rman in case this parameter has spaces, I mean that I need to put NSR_DATA_VOLUME_POOL = Pool Oracle but it throws an error however with PoolOra it ...
0
votes
2answers
54 views
SQL Server native log backup running every 5 minutes
What will happen if SQL Server native log backup is running ever 5 minutes and due to high active transaction the backup was not able to complete in 5 minutes ?
Will the next log backup be initiated ...
0
votes
0answers
28 views
Ola Backup scripts, How do you specify a different filename for the mirrored set?
I'm using the backup script below as a test. I want to use a different file name for the mirror. The format should be @FileName = '{ServerName}-DEFAULT-{DatabaseName}-{BackupType}-MIRROR_{FileNumber}....
1
vote
1answer
31 views
SQL Server Application paths to include in server backup?
I have an instance of SQL Server 2017 Standard installed on a physical server running Windows Server 2019. I'm currently working with our server administrator to configure the server backup, which he ...
0
votes
0answers
12 views
Transaction backup plan and size
I am using SQL Server 2016.
I have setup SQL Agent for Full backup (Weekly) and Transaction Log backup (Daily).
Backup transaction log into a single file using:
BACKUP LOG [XXX] TO DISK = N'E:\SQLDB\...
0
votes
1answer
42 views
T-SQL Query to retrieve the last full backup (Including split and copy only), Size and Location
I am using the following query answered by Marcello Miorelli. This query serves the purpose for normal backups but fails to determine the actual backup size of all the split backups and copy only ...
0
votes
1answer
25 views
Storage accounts not showing up when creating Azure Storage Credential
I'm trying to setup a Back Up Database Task in a Maintenance Plan on SQL Server 2017 (Web Edition) using SSMS 18.6 and when I get to the step to create an Azure credential I select my management ...
0
votes
1answer
15 views
PostgreSQL Backup Information
How do you get the Backup History for a PostgreSQL database from within the database?
for example:
in SQL Server you look into msdb.dbo.backupset
in Oracle you check v$rman_output
is there a similar ...
0
votes
1answer
42 views
Ola Hallengren's backups scripts, cleanup only mode
Is it possible to run Ola Hallengren's backup scripts in cleanup only mode? I have a couple of servers where the cleanup time was set too long, and I now have to clean up hundreds of databases worth ...
1
vote
0answers
71 views
SQL server backup fail “A system assertion check has failed”
I just installed SQL Server 2017 EVAL in a Windows Server 2012 R2 VM. Most default options.
Default installation folder. SYSTEM databases in default folder. User databases in the D:\ drive.
Created ...
0
votes
1answer
118 views
ERROR 1064 (42000) You have an error in your SQL syntax during import
New to MySql.
I have an export file from server version 5.6.34. I am importing this on a server with the same version. I get an error like:
ERROR 1064 (42000) at line 4343: You have an error in your ...
0
votes
0answers
16 views
Quick Backup/Restore of Aurora Database
We're getting slow performance (hours for a couple GB database) when trying to do a backup/restore of an aurora database. We essentially want to clone the database so we've got two side-by-side copies ...
0
votes
1answer
29 views
SQL Backup routine regarding DB Logs
I recently had an incident that got me rethinking my backup plan: One of our MSSQL driven aplications stalled because the log fle had grown too big on the filesystem (it was 50 GBs IIRC).
It turned ...
0
votes
1answer
31 views
RMAN Backups - Can more than one media management software solution be used?
Does anyone know if it's possible for two different backup utilities to be used to backup the same Oracle database? Both utilities would use RMAN.
So, for example, take an Oracle 11g standby DB with a ...
1
vote
1answer
47 views
mariabackup crashing, help
Hi I'm using mariabackup on one of my MariaDB 10.5.4 nodes from my Galera Cluster and whenever I run it i get this from my output logs:
[00] 2020-08-05 11:26:40 Connecting to MySQL server host: ...
0
votes
0answers
16 views
Do Sql Server backups contain transacitons during backup? [duplicate]
I have a database that automatically takes full backup weekly, differential backup daily, and transaction log backup every 5 minutes. The full backup takes about half an hour so its runtime often ...
0
votes
2answers
26 views
Backup Restore, CPU usage and Extended Events
I'm working on measuring the performance impact of Backups on CPU. I would like to capture all the backup operations and CPU usage. I'm running a weekly full backup, daily diff, and 15 min log backup. ...
0
votes
1answer
27 views
PostgreSQL WAL Archival Best Practices?
The postgresql documentation gives an example archive_command of
archive_command = 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f' # Unix
but adds the disclaimer ...
0
votes
1answer
35 views
MariaDB Galera + Remote Backup
I'm using CentOS 8 and I have a MariaDB 10.5.4 Galera set up with three nodes. Now, I want it to create a backup to my central server from time to time. I'm thinking of mysqldump but restoration would ...
0
votes
1answer
9 views
Encrypt backup in 2008 R2
Is it possible to encrypt 2008 R2 backups like TDE for instance?
What I've read is encrypting the whole database and that way the backups will be encrypted. But can you have TDE encrypted backups ...
1
vote
1answer
25 views
Why did full backup file size grow after data movement for Availability Group replica was suspended?
Found an error log informing that data movement to a secondary availability replica was suspended. I'm not sure whether the cause of the suspension is relevant to answering my question, but the cause ...
1
vote
2answers
38 views
SQL Server 2017 Backup strategy
RTO is 8 hours
RPO is 24 hours
Retention Period: 5 days
Based on above values I have plan to configure below backup stratgey for Production. Please suggest if there is any changes required in below ...
0
votes
2answers
38 views
Fast Backup and Restore of Growing Databases
I work in Tech Support and the some of the products I support are heavily database dependent (PostgreSQL and MySQL, but most of the big ones are MySQL). Before we do an upgrade, we always take a full ...
0
votes
0answers
35 views
Is safe to make backups of vm that contain Oracle databases using veeam backup or another similar tool?
I would like to know if it is advisable or safe to make backups of vm that contain Oracle databases using veeam backup or another similar tool, my doubt is caused because I have several vm with Oracle ...
0
votes
0answers
8 views
MongoDB : Log failing DB backups
is it possible with Java Script to capture the errors of MongoDB backup failer and send this message to Windows event logs
Best regards
0
votes
1answer
17 views
Event and mysqldump
I am trying to create an event for automatic backup using this code
DELIMITER $$
CREATE EVENT IF NOT EXISTS e_AutomaticBackUp1Day
ON SCHEDULE AT 1 Day STARTS '2020-07-06 10:13:00'
DO
BEGIN
mysqldump -...
1
vote
2answers
36 views
backup using gzip slow
We are currently backing up some schemas in Postgres using this command:
pg_dump -h localhost -n test_schema mydb | gzip > /data1/backup/test_chema.dmp.gz
And we are getting a rate of 50 Megabytes ...
0
votes
1answer
62 views
TRY/CATCH only reports the last (and most useless) error
(This is SQL Server 2016 SP2-CU12.)
When running this command interactively, I see the quite useful Msg 3035, Level 16, State 1.
BACKUP DATABASE @DB TO DISK = @targetfile
WITH DIFFERENTIAL, RETAINDAYS ...
0
votes
1answer
32 views
SQL Server and ASP.NET - Backup Log database with Application Pool in Always Running
I have a database on SQL Server Express used for 3 Asp.net applications. The Recovery Model is Full.
Every day I execute a backup database and log with this code
BACKUP DATABASE @databaseName TO DISK =...
-1
votes
1answer
37 views
Ola Hallengren Database Backup keeps failing (for both SYSTEM and USER databases) [closed]
Both USER and SYSTEM backup database jobs have been running fine until some weeks back when I checked my alerts (bearing in mind that this is on DEV where I do my own testing etc).
I am just confused ...
