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.

Filter by
Sorted by
Tagged with
1 vote
4 answers
400 views

Difference between Backup and Snapshot

I've been reading article after article about the difference between a Database Backup and a Snapshot and they just don't make any sense, so please help me undersand "A snapshot is an image of ...
Juan Perez's user avatar
0 votes
1 answer
16 views

Reading data from PostgreSQL backup directory

Let's say I have a backup directory containing PostgreSQL data from some other system. By default, the data is stored at /var/lib/postgresql. After changing the default data directory to the path of ...
0xD4rky's user avatar
0 votes
1 answer
27 views

Merging old backup in current database mysql

I have a backup database that contains data up to the specific date 27-11-2023. Currently, I have the latest version of the database with updated records. However, the issue arises when I consider ...
Muhammad Faizan Khan's user avatar
2 votes
1 answer
52 views

how percona hot backup works / innodb crash recovery works?

I am trying to understand the process of how percona does hot backup. from what in understand is, they use innodb crash recovery mechanism and execute the following steps. store/remember start LSN ...
Rajat Aggarwal's user avatar
1 vote
1 answer
50 views

RMAN backup restoration

I am trying to restore a RMAN backup to a different server. I needed some clarifications/guidance. This is the location for datafiles in database 1: /u01/app/oracle/oradata/db1/datafile This is the ...
datascinalyst's user avatar
0 votes
0 answers
35 views

Problem restoring partial mariabackup

I follow this method to perform a partial and incremental backup of my database on two servers, bskpserver and devserver. Everything works fine except for some tables. When I try to restore them on ...
elarichi.y's user avatar
0 votes
2 answers
27 views

maintaing backup log sequence after executing BACKUP DATABASE databasename command manually [duplicate]

I am new to database admin role and I have to configure backups for a new client. I want an advice on how to handle below scenario. I want to configure a weekly full backup along with incremental ...
user avatar
0 votes
2 answers
33 views

What sql statements is mysqldump executing and how does it affect database performance?

I noticed a SELECT * FROM query running on a big table from time to time and i wonder if this could be, because of mysqldump. We have mysqldump backups running for some tables. Does somebody know what ...
Lorem ipsum's user avatar
0 votes
1 answer
26 views

Error message when running a SQL maintenance plan backup

I'm receiving the following error message when my daily maintenance backup plans execute: Error Message 1: [298] SQLServer Error: 407, Internal error. The string routine in file e:\sql11_main_t\sql\...
Mike Gomes's user avatar
0 votes
0 answers
23 views

mysqldump on replica for backup and GTID

I use replica instead source database for backups. After enabling GTID mode I am not sure how I should use mysqldump to make correct dump. This backup is for source recovery of course. mysqldump --...
deem's user avatar
  • 113
1 vote
0 answers
78 views

Why does msdb of dev server show the backup history from another server after I perform a restore?

Observed a strange thing today. I have full/diff/log backups configured on prod server. I restored one of the prob db onto the dev server. Backupset, backupmediafamily msdb tables on the dev server ...
variable's user avatar
  • 3,442
-1 votes
2 answers
67 views

Database tenancy model

I'm redoing a legacy system, and currently, I have a database with the same structure for each client. I'm really unsure whether I should maintain it this way for the new system or if I should create ...
flvsouza's user avatar
1 vote
3 answers
87 views

Does a SQL Server Log Backup Include Log Records Backed Up in a Previous Full or Differential Backup?

I've been reading the Microsoft documentation on log backups in SQL Server and came across the following statement: (Log Backup) Specifies a backup of the transaction log only. The log is backed up ...
Fajela Tajkiya's user avatar
0 votes
1 answer
38 views

Modeling a data processing system for consigned employees

I'm currently in the process of developing a payroll system using SQL Server and PHP. However, the system involves a multitude of processing rules. During this processing, I may receive files ranging ...
Flavio's user avatar
  • 1
1 vote
0 answers
51 views

Restore Job in MSSQL failing [duplicate]

The backup job of being completed, however, the restoring job is failing. //EDIT I am trying to perform logshipping Getting the following errors: Date 10/25/2023 4:45:00 PM Log Job History (...
datascinalyst's user avatar
0 votes
0 answers
31 views

ERROR 4078 (HY000) at line 167956: Illegal parameter data types uuid and int for operation '='

I'm using this command to backup all of my MariaDB databases and gzip them all: mariadb-dump -pPassword --all-databases --routines --events --single-transaction | gzip -c > dump.sql.gz Then I copy ...
Saeed Neamati's user avatar
0 votes
0 answers
57 views

Sql server database restoring from backup, sql users without login

After restoring a database from another SQL server, set database comes with database users without login. Do these users have any actual functionality or they are practically dead users? I've looked ...
Peter's user avatar
  • 79
0 votes
1 answer
39 views

TablePlus: backup and restore DB with circular FK contraints/references

After a backup on TablePlus (documentation) with only the --format=custom option, I got the following: Backup database 'postgres' Dumping... warning: there are circular foreign-key constraints on this ...
CPHPython's user avatar
  • 329
0 votes
2 answers
40 views

Create backup of Postgres DB schemas

I have two servers and 5 schemes in Postgres, one server is in production and the other is in the background. Windows server 2019 Postgres 12.7 I have these schemas in the postgres database which is ...
fah81's user avatar
  • 3
0 votes
1 answer
63 views

batch script to get all the tables in postgres database as csv

I have a remote postgresql database with a lot of schemas. I want to dump the tables that is specific schema as .CSV file for each table. I'm aware of the COPY command but I'm not sure how to write a ...
new_developer's user avatar
0 votes
1 answer
271 views

ORA-19914: unable to encrypt backup and ORA-28365: wallet is not open

I have been taking backup of my database daily, and for some reason, I suddenly got this error ORA-19914: unable to encrypt backup ORA-28365: wallet is not open this is my databases's current ...
datascinalyst's user avatar
0 votes
0 answers
13 views

Restoring PDBs on a new server

I am trying to restore a 19c database on a new server using RMAN. What are the prerequisites? Do I have to first create PDBs which are supposed to be restored? Or should I just restore from ...
datascinalyst's user avatar
0 votes
0 answers
74 views

How to Optimize SQL Restore Performance with MySQL Dump [closed]

I'm currently working on a cron job that involves masking and modifying specific columns in a MariaDB 10.6 database. The process includes taking a dump of the production database using mysqldump and ...
Yusuf Sameh's user avatar
0 votes
0 answers
27 views

Restore SQLServer Encrypted Backup on a server with higher version

I want to implement Backup Encryption. I have tested in Test server this process with success. Before implementing on production I want to make sure that I am considering all risk. The only thing that ...
Meyssam Toluie's user avatar
0 votes
1 answer
35 views

Can we do restoration using full backup on secondary and , differential and log backup on primary?

i have strange requirement in my environment but i need to ask this question to meet the business objective. Can we do restoration using full backup on secondary and differential and log backup on ...
zul nasir's user avatar
0 votes
0 answers
37 views

Restore issue with Pgbackrest

I am using Pgbackrest to backup and restore postgresql databases. Backup is okay, but when I want to restore database to point in time or last backup, although database files are located in data ...
Farid Zahidov's user avatar
0 votes
1 answer
30 views

pg_archivecleanup

I need to use the pg_archivecleanup command to delete log generated in a primary node from a cluster postgresql but I see that running the next line does not delete anything. pg_archievecleanup -d /...
Carolina's user avatar
1 vote
0 answers
30 views

Is there any tool that can be used to backup and restore individual schemas and not the entire database?

Can someone help me with any tool that can be used to incrementally back up the individual schemas and restore them instead of backing up the entire DB? We need this for the Aurora MySQL DB RDS ...
Omkar's user avatar
  • 11
0 votes
0 answers
21 views

Is it possible to backup AWS RDS Aurora MySQL per database by any AWS services?

I have several AWS RDS Aurora clusters, and user data is stored in different database. Currently I have my own script to backup per database, but I am considering to backup through AWS provided ...
Yuk Chan's user avatar
0 votes
1 answer
53 views

mysql hot backup with upgrade support

I perform a hot backup of a production mysql database using an LVM snapshot, and then I attempt to restore said backup on a development machine. However, the dev mysql database will not start, and ...
Isaac Sutherland's user avatar
0 votes
1 answer
45 views

Whether to run integrity check before or after backups (Ola H FAQ)?

Going through Ola H FAQ's, https://ola.hallengren.com/frequently-asked-questions.html, I see that I also recommend that you perform the full backup after the integrity check. Isn't the opposite true?...
variable's user avatar
  • 3,442
0 votes
1 answer
36 views

Understanding Full Backup Process in SQL Server: Do All Allocated Extents Get Backed Up?

I've been reading a blog post by Paul Randal on the SQL Server backup process, where he outlines the main phases of a full backup. One point he mentions is that during a full backup, the process reads ...
Fajela Tajkiya's user avatar
0 votes
1 answer
27 views

Mariabackup flush and delete bin log

I'm using Mariabackup and I'd like to know if there is an option to allow me to rotate the binary log when running mariabackup. I can't seem to find anything in the documentation.
Ror's user avatar
  • 131
0 votes
0 answers
90 views

Use PowerShell script to backup SQL Server 2019 Express database to a network destination

I've got a SQL database server (SQL Server 2019 Express) and a application server connected by a simple switch. Now I'd like to back up a SQL database to the application server. Since its an SQL ...
TeemoBiceps's user avatar
1 vote
1 answer
127 views

VSSSQLwriter error

I've a SQl server 2019 on a Windows Server 2019 standard core, I manage two typer of backup, one with mantainance plans and one with Veeam Backup. The mantainance plans it's ok, the backup with Veeam ...
Stefano Ambrogi's user avatar
0 votes
1 answer
238 views

Trying to restore data from new Postgres version to old Postgres version

I took a backup of the Postgres database version 15, and now I want to restore that data to Postgres version 13.1.2? is it possible?
datascinalyst's user avatar
1 vote
1 answer
58 views

Failed MSSQL Backup Restoration Due to Defunct State in a File: How to Resolve?

I'm having trouble restoring an MSSQL backup because one of the files is in a defunct state. I need help fixing this to complete the restoration. Thank you! Additionally, my MSSQL backup restoration ...
Seyed Jafar Mousawi's user avatar
-1 votes
1 answer
30 views

How do database snapshots work?

How do database engines take consistent snapshots when writes could be happening at any time? (A) Does the database engine block writes one table at a time while taking snapshots? (B) Does the ...
AlfaZulu's user avatar
1 vote
1 answer
36 views

MySQL to MariaDB migration - user view breaks compatibility with backup-restores and replication

I am trying to migrate an Ubuntu 18.04-Server with Oracle's MySQL to a Ubuntu 22.04-Server with MariaDB 10.6.12. I've established a replication between the databases, which worked. Alone, the User ...
t2m's user avatar
  • 11
0 votes
1 answer
45 views

Manage archive logs on DBCS

We are testing an Oracle OCI DBCS and I have enabled automatic backup. I saw that the archive logs have been accumulating since I enabled automatic backup and I would like to know if OCI also deletes ...
MarcioElizeu's user avatar
0 votes
1 answer
40 views

do log backup on secondary node (sync or async) can truncate transaction log on primary?

i have 4 nodes. 2 nodes in sync mode, 2 nodes in asyn mode. Can i relocate all backup jobs (full, tlog) on any secondary? does the backup truncate the transaction log on primary?
zul nasir's user avatar
0 votes
1 answer
59 views

db2 prune command procudes "DIA8701C Access denied for resource" error

On Db2 v11.5.8.0 on Linux/x86-64 couple of mouths ago we have moved our database from one Linux to another. Every night at the time of backup error is written in db2diag.log file. 2023-08-16-02.14.13....
folow's user avatar
  • 327
1 vote
2 answers
353 views

Oracle: how to specify non-default backup location during RMAN restore

Oracle 19c on Windows. RMAN scheduled backups go to FRA here: D:\oracle\recovery. I have another backup in D:\backup\ which I want to restore. I need to be able to "tell" Rman to look into ...
epipko's user avatar
  • 113
0 votes
0 answers
18 views

Microsoft.Sql/servers/databases/backupLongTermRetentionPolicies

I am trying to add long term retention policy on the SQL DB using azure policy with Microsoft.Sql/servers/databases/backupLongTermRetentionPolicies. Seems like there is an issue with my current policy ...
user avatar
0 votes
1 answer
29 views

What is the correct value (GB) to shrink a DB?

My database has an MDF file of 56 GB and an LDF file of 263 GB, recovery model is setting to Full. So, I would like to shrink the LDF file because we are out of space. What specific size should I ...
luis.huallpa's user avatar
0 votes
1 answer
48 views

Huge Transaction Log File - Full Database backup, but no Transaction log backups

I hope someone can help. Please be gentle, this type of admin is not what I usually do. I have inherited a database which is set up to do a FULL database backup at 02:00 every day. The transaction log ...
Jubs666's user avatar
0 votes
2 answers
99 views

MS SQL full backup by partition, can be done without log?

The matter is that I really don't need t-tlog and i wish to avoid it. I'have looked in many topics but I haven't seek out the answer I need (the topic of MSSQL backup is very tricky to understand well ...
Radioleao's user avatar
  • 125
2 votes
2 answers
84 views

Are SQL Server stored procedures backed up by default?

We have two servers running SQL Server 2019 (15.0.x). When we do a full database backup (by right-clicking the data base, then Tasks, then Backup), does that include backing up the all items under ...
FreeMan's user avatar
  • 221
0 votes
1 answer
102 views

Backup Full of a database on a standby node in Cluster Postgresql

I am trying to get a full backup from a standby node in a postgresql cluster but when I run the script I get the following error pg_dump -U userbackup -W databasename > databasename.sql pg_dump: ...
Carolina's user avatar
1 vote
1 answer
129 views

How do I manage Cassandra/Scylla snapshots?

I am new to Scylla, and I'm looking to setup a proper Backup & Restore solution. I've just tested running nodetool snapshot -t my_backup, and see that what it does is create a snapshot folder ...
Nuno's user avatar
  • 809

1
2 3 4 5
53