Questions tagged [database-restore]
The database-restore tag has no usage guidance, but it has a tag wiki.
database-restore
710
questions
0
votes
1
answer
11
views
Backup and restore metadata of PieCloudDB
I am using the cloud edition, and the overall usage of the database is relatively light, about 1GB. I want to know how to backup and restore the metadata of PieCloudDB Database management and control ...
- 55
-1
votes
0
answers
21
views
Automate restoring external .sql dump file on Azure MySQL flexible server
I have a zipped MySQL dump file that I am receiving from one of my company's vendors. I need to unzip it and use the .sql file to restore a database in Azure Database for MySQL flexible server. I am ...
0
votes
0
answers
32
views
How to restore external table
I created an external table by importing a Google Sheet link in BigQuery.
However, I accidentally deleted this table.
I tried to recover the table by checking the table creation and deletion logs ...
- 1
0
votes
3
answers
80
views
restore an ibm db2 from a savf file
I have a .savf file that someone created from an IBM DB2 S400 server to transmit a database to me.
I installed db2 server community edition on Ubuntu. My install works, as I was able to create a test ...
- 59
0
votes
1
answer
242
views
Backup Dbeaver with postgres
I'm tring to apply backup using DBeaver with postgres:
1: Create backup:
2:
3: I try apply restore on another database and get this:
this is the error pg_restore: error: did not find magic string ...
- 289
0
votes
0
answers
20
views
Restore of backup db failed.(Microsoft.SqlServer. Management.RelationalEngingeTasks)
System. Data.Sqlclient.SqlError:This backup set cannot be applied because it is on a recovery path that is inconsistent with the database. The recovery path is the sequence of data and log backup ...
0
votes
0
answers
53
views
Unable to restore sqlite from backup
I have this application for years and after updating the application I found that I could no longer restore the data. I'm able to backup and I can see all data in DB Browser for SQLite on my desktop. ...
- 1,191
0
votes
1
answer
100
views
Preserve restrictive flag when restoring Db2 database
Is there any way to preserve the Db2 restrictive mode setting during a database restore?
Problem: The restrictive flag is overwritten when restoring a backup of a non-restrictive Db2 database into an ...
- 100
0
votes
1
answer
41
views
Greenplum gprestore - cannot find file (gpfmt_gpss.so)
I'm performing a gprestore on Linux RHEL 7 and I'm getting the following error:
Greenplum Database Restore Report
timestamp key: 20231207163727
gpdb version: 6.25.3 build commit:...
- 37
0
votes
0
answers
28
views
Replicate RDS instance into a DEV instance
I have two RDS instances, one for PROD and other one for DEV. I want make daily backups of prod instance and replicate into a dev instance. The problem is that when I take a snapshot of prod instance, ...
0
votes
0
answers
193
views
Cannot start PostgreSQL database: Invalid primary and secondary checkpoints
My specific problem is that we are unable to restart our postgreSQL database.
We have an ubuntu server (release 18.04) with PostgreSQL 10 installed. I commonly revise my IP address in the pg_hba.conf ...
- 1
0
votes
0
answers
138
views
Why `\connect mydb` prevents error `function unaccent(text) does not exists`?
I restored my database successfully on one cluster, but when I try to do same on different cluster with same custom PostgreSQL database image I got errors:
ERROR: function unaccent(text) does not ...
- 24.1k
0
votes
1
answer
102
views
Oracle DB - Database backup without any data [closed]
I have a situation where I need:
to import the latest structure of my prod database (everything including business logic but without any data) into a lower environment - because my web app refers to ...
- 3
0
votes
0
answers
420
views
TLS Connection Request Failure: Mismatched Server Certificate Name (server_name) During Database Restoration
i'm a newbie please be patient:(
I'm trying to restore a database using a specific script that works perfectly fine and I get this error WARNING: [16:44:51][New-DbaDatabase] Failure | The target ...
- 1
1
vote
0
answers
1k
views
Restore the source database changes using RMAN Incremental backup in Oracle 19C where Target Database also changes
Need to upgrade the Oracle database from 12C to 19C in different Servers using RMAN backup and restore method. DB Size is approx. 10TB and increasing on a daily basis.
Below would be the steps:
...
