Skip to main content

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 votes
0 answers
17 views

Best Practices for Migrating 2TB MSSQL Databases with High Availability to PostgreSQL

I'm planning to migrate a large-scale MSSQL environment to PostgreSQL and would appreciate some advice and best practices. Here are the details of our current setup: Current Environment: Two servers ...
Obada Bakfalonui's user avatar
-3 votes
0 answers
17 views

Cant taking Backup showing ERROR: could not read block 56 in file "base/16393/11908": Invalid argument [closed]

Cant Taking Backup: pg_dump: [archiver (db)] query failed: ERROR: could not read block 56 in file "base/16393/11908": Invalid argument pg_dump: [archiver (db)] query was: SELECT t.tableoid, ...
FUAD SPINNING MILLS LTD's user avatar
4 votes
1 answer
104 views

Backups/CHECKDB errors - "Cannot find server certificate"

I have been exchanging TDE certificates on various servers to make restores easier - some had the wrong name, the wrong thumbprint, or even both. This involves transferring databases to a temporary ...
ImperviousInclemency's user avatar
0 votes
0 answers
20 views

SQL server is already part of a cluster error; cannot re-add after removing offline SQL node

I'm new here but I've run out of options for my search on this issue my team is having. To give a relatively short backstory; I know almost nothing about SQL beside what I've learned from a short time ...
Anthony Schwab's user avatar
1 vote
2 answers
96 views

Understanding Recovery Forks in SQL Server: Meaning and Significance

I'm trying to understand the concept of recovery forks in SQL Server, particularly in relation to the sys.database_recovery_status view. The documentation mentions several columns related to recovery ...
Just a learner's user avatar
0 votes
0 answers
11 views

Crunchydata - PGO - Postgres(v 14.x) restore not working as expected

We have set up PostgreSQL, including its backup and recovery processes based on crunchy data Postgres Operator, as per the documentation. The backups are occurring as expected. However, when we ...
Neeraj Bhatewara's user avatar
0 votes
0 answers
29 views

Error Delete Distributor on sql Server 2019

I can't delete Distributor. The system shoew message error "Could not drop the Distributor 'Dis_name'. This Distributor has associated distribution database"
WP JLK's user avatar
  • 1
0 votes
0 answers
12 views

DB2 backup from Data Studio throws sqlcode=-22212

When I try to back up a database, the process fails with the error: Attempt to connect to DAS failed with the following error: sqlcode=SQL22212N db2dasrrm.exe runs under the PID from the netstat ...
Betty Liv's user avatar
0 votes
2 answers
55 views

How to Restore RMAN Backup at Specific Date

I have daily backups of my test system which is taken daily full backups and also hourly arch backups. I need to restore one of these backups to another linux server. I've completed all steps until ...
postgresnewbie's user avatar
0 votes
0 answers
53 views

Do newer .trn files contain the transactions of older .trn files as well as the new ones? [closed]

I have a sql server database that runs a log-shipping backup job every day at 2am. When I look at the folder where the .trn files generated from this job are stored, I see a .bak which seems to be ...
Sean Harricharan's user avatar
0 votes
1 answer
46 views

Oracle database backup recovery

Just startet to study Oracle, i need to restore database backup. Log file said it was made in Oracle Database 10g Enterprise. I have Oracle XE 18, is it even possible to make it for XE version usind ...
Артем Павлов's user avatar
-1 votes
3 answers
145 views

Does it make sense to Full Back up weekly or Back up Transaction Log every 15 min?

I have to make a decision (at work) to choose which option is more feasible using SQL Server 2019: Option 1: Full backups sent once per week and differential backups sent between weekly backups. ...
Java's user avatar
  • 233
0 votes
1 answer
26 views

How do I restore a PostgreSQL/TimescaleDB pg_basebackup tar on Windows? postgresql-x64-15 immediately stops on start

I'm going thru the various online processes to expand the pg_basebackup tar file into the C:\Program Files\PostgreSQL\15\data, such as Restore data from tar file for unix, but when restoring on ...
Scott's user avatar
  • 101
1 vote
0 answers
48 views

SQL server suddenly backups are slow

I've an older SQL 2008R2 server that will dismissed and upgraded this year. Unfortunately server needs to remain up and running until then. Problem is since a few days ago, backups are really slow (...
Miguel's user avatar
  • 11
1 vote
1 answer
21 views

Is there a full copy of data on each node if RF=3 and DC has 3 nodes?

When backing up a Scylla cluster (or cassandra for that matter) I understand that its best practice to take a snapshot of every node. However if I have a 6 node distributed cluster spanning 2 ...
imbrian21's user avatar
1 vote
0 answers
24 views

Taking full and incremental backups with authentication in MongoDB

We have a multi-tenant micro-service (it's basically kafka with some bells and whistles). We are using Mongodb to store multi-tenant credentials and kafka data so the authentication is really tight. ...
DarkDead's user avatar
0 votes
0 answers
36 views

Mariabackup incremental backup and prepare process

I want to start using Mariabackup to backup a fairly large MariaDB database (v 10.6, 250GB) - current backup is taken using VMWare snapshots but they are crash consistent. So far I have taken a weekly ...
bhttoan's user avatar
  • 111
0 votes
1 answer
34 views

MySQL Backup (.cfk) file to Microsoft SQL Server

.cfk file is a backup from a MySQL database => Microsoft SQL Server I am currently working on transferring a MySQL database backup file with the extension .cfk to Microsoft SQL Server. I tried the ...
Hossam Fid's user avatar
0 votes
2 answers
40 views

unknown database backup file extension *.gbk

I have a database backup from an old desktop application, and the backup file has the extension *.gbk. Could you please help me identify which database uses this extension?
freesniper's user avatar
2 votes
1 answer
38 views

Can we take a copy-only backup for filegroups on the SQL Server from a secondary HA replica?

I am getting the below error while executing the script for taking filegroup backups from a secondary replica. Msg 3059, Level 16, State 1, Line 18 This BACKUP or RESTORE command is not supported on ...
user avatar
0 votes
1 answer
78 views

Telling SQL Server about moving the backup files

I moved some backup files to new destination. However, the SQL Server seem to think they are still in their old place. (That is, when I use the SSMS Restore Database wizard, it it still comes up with ...
Yano_of_Queenscastle's user avatar
0 votes
1 answer
56 views

Multiples full backup from MS SQL Server all day long

I think this is not the best practice, but on a server I am administering, there is a PowerShell script doing full backups of a Microsoft SQL Server Express Edition instance every X minutes. What ...
Le  Mngr's user avatar
0 votes
1 answer
52 views

Preferred seconday backup in AG - what about the primary ? Shows no backups taken

I did setup the Ola Scripts sticking to https://www.brentozar.com/archive/2015/06/how-to-configure-alwayson-ag-backups-with-ola-hallengrens-scripts/ Options are: @Databases = 'USER_DATABASES', @...
Thomas D's user avatar
0 votes
0 answers
37 views

PDB restoration on other server

I want to restore only 1 pdb to another server, how can I do that? the rman backup which i have taken from another server has a different control file, and the server on which i am restoring the pdb ...
datascinalyst's user avatar
1 vote
1 answer
150 views

postgres backup start stop from psql and linux cli

I want to perform below steps Put DB in backup mode Take snapshot of volume Stop backup mode But when I try as below, at #3 I get "Did you call pg_backup_start()?" error. Looks like start ...
Manoranjan Reddy's user avatar
0 votes
1 answer
36 views

Point-in-Time-Recovery of Postgres at an arbitrary time for audit purposes [closed]

TL;DR Would you recommend using CDC or pg_wal-based recovery to reproduce the state of the database in an arbitrary time, or stick with joining SCD2 tables (with start end end date for every record) ...
Mr Arkadin's user avatar
0 votes
0 answers
30 views

Postgresql 16.2: ERROR: could not find hash function for hash operator 607

I've problem with my database running on postgresql 16.2. My application is running fine, it can query data, but I'm not able to create a backup using pg_dump or inspect database via psql. Running ...
Dan's user avatar
  • 1
0 votes
4 answers
216 views

how to transfer data from Prod environment to Dev environment?

My database in the prod environment is very large and I backup this database every day and restore it to the dev environment. This process takes 4 hours, which is actually too long. What else can I do ...
Merve's user avatar
  • 57
0 votes
0 answers
41 views

MSSQL logs are not being rotated in AG setup

I have an MSSQL setup primary-secondary configured through availability group. I see the logs do not get rotated even after the full backup is executed daily and logs backup is taken after each hour ...
Makhshif Tanvir's user avatar
0 votes
0 answers
106 views

SQL Backups with SQL 2022 Contained Availability Group

We have a SQL 2022 Always On Availabilty Group with Contained databases; a new feature in this version of SQL. The master and msdb databases are now also in the Avalability Group. We like this setup, ...
Jeroen Bleeker's user avatar
0 votes
0 answers
25 views

Percona Xtra backup -File ./ib_logfile0: 'open' returned OS error 71. Cannot continue operation

Is there any way to solve this error? xtrabackup --backup --user=backupuser2 --password='pass' --target-dir=/u02/backup/ xtrabackup: recognized server arguments: --server-id=1 --log_bin=mysql-bin.log -...
datascinalyst's user avatar
0 votes
1 answer
78 views

Why does data compression not affect backups?

The documentation is very clear on this point Compression doesn't affect backup and restore. but how is that possible? Surely, if my table is smaller (due to compression), then that should have some ...
J. Mini's user avatar
  • 537
0 votes
0 answers
14 views

pgBackRest - optimal policy / setup for RPO of 1 hour

I need a bit of advice. I have a postgres 14 database and a requirement for the DB, to be to recovered with RPO of 1 hour (acceptable data loss is max of 1 hour). Database size is 300 GB, backup size ...
Wojtas.Zet's user avatar
0 votes
1 answer
24 views

Network utilization maxed out during backup. Is it bad in itself?

We have a cluster of two Oracle DBs. Monitoring software agent is installed on both of the machines and overnight, when backups are happening, we get warnings that network interface utilisation on the ...
Tony Sepia's user avatar
0 votes
1 answer
35 views

Missing user-defined type on importing a backup with PGAdmin

I have a strange error when importing a backuped database from my prod environment to my dev environment. the scenario is as follows: Postgres 13.x PGAdmin 4 migration files are generated by dbmate ...
robkuz's user avatar
  • 103
0 votes
0 answers
48 views

Intermittent Error On SQLServer Hourly Database Backup Maintenance Plan

Some of our SQLServer machines' hourly maintenance plan with Back Up Database Tasks are failing intermittently, around once or twice per week. The next hourly execution runs without any issue. Each ...
JieLong's user avatar
  • 167
0 votes
0 answers
25 views

LogBACKUPFull, error description :-2147217900 [duplicate]

When I'm going to Configure a new Proximity Sensor Access Card through the Netxs control software in My SQL Server, I get this error error found in 'frmEmployee.cmdSave_Click' routine at line number:...
user avatar
0 votes
1 answer
45 views

Does Azure automated backup for SQL database on Azure VM have way to detect log chain?

I have SQL server on Azure VM. If I enable Azure automated backups for the SQL server on Azure VM to backup the dbs (full/diff/log), and suppose if an admin performs a manual log backup (which ...
variable's user avatar
  • 3,468
0 votes
1 answer
226 views

RMAN: restore not done; all files read only, offline, excluded, or already restored

I did a hot RMAN backup of a server running Oracle 19c database, then moved the backup to a new server. This is the backupscript BACKUP AS compressed BACKUPSET INCREMENTAL LEVEL=0 FORMAT '...
datascinalyst's user avatar
0 votes
0 answers
18 views

Subsequent WALs only work if I include a base backup

I'm trying to replicate a primary PostgreSQL database to a replica through the use of base backups and WALs. The basic idea is something like: Day 1: base backup + WALs Day 2: new WALs Day 3: new WALs ...
dokgu's user avatar
  • 123
0 votes
1 answer
37 views

Command pg_restore does not import / restore any data, printing "depends on"

A database origin was dumped in postgres "custom" format using: pg_dump -d origin --data-only -Fc > file.dump. The dump was then used to restore all data in a different database with the ...
FireEmerald's user avatar
0 votes
1 answer
50 views

What is the SQL Server behaviour if an AG node is restored from a VM snapshot?

I'm looking at 2 node synchronous AG hosted on Azure VMs. SQL server version is 2022 enterprise edition. There is file share witness as well. Each VM has a VM level nightly backup configured so that ...
variable's user avatar
  • 3,468
0 votes
1 answer
62 views

Automatically create full backups every 7 days

I have a postgresql database configured with pgbackrest for backups. It retains full backups for 7 days: [global] repo1-retention-full-type=time repo1-retention-full=7 I've set up cron to create a ...
GammaGames's user avatar
0 votes
2 answers
67 views

MS SQL Differential Backup: how to locate full backup source

This morning I have perform a differential backup of my database, named "MW". Now I need to restore the backup (full+differential) on another database, named "bak_MW". I got an ...
Radioleao's user avatar
  • 127
0 votes
0 answers
7 views

How to restore a backup and incremental backup of scyllaDB

I am working on incremental backup and restore. When I am trying to restore the incremental backup, after restoration, I am getting an error on cqlsh shell. ReadFailure: Error from server: code=1300 [...
MANJESH H S's user avatar
0 votes
0 answers
40 views

PostgreSQL Failure To Reinitialise Replica With pg_basebackup [duplicate]

I have a master-replica PostgreSQL 9.5 setup. I'm trying to reinitialize the replica by doing the following: Stop replica service ( /etc/init.d/postgresql stop ) Clear data directory ( rm -rf /path/...
Aaron Ullal's user avatar
0 votes
1 answer
120 views

What are recommended values for block size, buffercount and maxtransfer size for Ola backups to Azure?

I have SQL servers running on onprem and Azure VM hardware. The backups write to a file share located on a network VM. I am wanting to change the backup destination to Azure blob storage. For this I ...
variable's user avatar
  • 3,468
0 votes
1 answer
508 views

Encountering an Issue with Oracle ORA-39405 Error

I've been researching and testing for days now, and so far, I haven't been able to solve my problem. I'd like to know if any of you have ever encountered this. I'm facing a challenge with a client's ...
Thiago Roque's user avatar
0 votes
1 answer
111 views

Cannot do a backup of a read_only database

I'm facing a strange issue where my backup fail with the message : Msg 3906, Level 16, State 1, Line 5 Failed to update database "MyDBB" because the database is read-only. Msg 3013, Level ...
Dominique Boucher's user avatar
0 votes
0 answers
33 views

Percona XtraBackup questions about full and incremental backups

I had a few questions on the Percona forum, and I'm unsure if I was being clear in my questions or not, however I'm curious how full and incremental backups work with XtraBackup. When doing ...
alturic's user avatar

1
2 3 4 5
55