Questions tagged [restore]
Reloading a database from a backup, typically for disaster recovery, or to make a copy of a database onto another server.
1,439
questions
0
votes
0
answers
13
views
How can I identify the correct restore technology and then restore the database?
We have a vendor who is shutting down their operations. As part of the shutdown they have provided us with a backup of our database, and an init.ora file. (Database system is Oracle; version is ...
0
votes
1
answer
50
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 ...
0
votes
1
answer
19
views
What is quicker - restore with replace or deleting DB and then making restore - for DB with simple recovery mode? [closed]
What is quicker - restore with replace or deleting DB and then making restore (for DB with simple recovery model (log file = 0) and size of data file of 2Tb)?
0
votes
1
answer
18
views
Restore from database snapshot
When I do a restore of a database from a database_snapshot on a filestream enabled database, I am getting the error:
The database cannot be reverted because FILESTREAM BLOBs are present.
Is it just ...
0
votes
1
answer
35
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 '...
0
votes
0
answers
18
views
How does pg_restore detect missing depending entities?
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 ...
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 [...
0
votes
1
answer
37
views
MySQL services fails to start successfully after copying MySQL Data Directory from another server
Purpose 1 - The running application should not be stopped and run 24*7 while backup or copy MySQL data directory (/var/lib/mysql).
Purpose 2 - To backup MySQL files directly and copy on another server ...
0
votes
1
answer
75
views
SQL Server - moving databases to an earlier version - options
I have inherited a vendor product. It’s currently very old, having been installed in 2013 and never updated in the 11 years since. The database server it’s using for its 3 database is SQL Server 2008 ...
1
vote
1
answer
65
views
How to Filter and Restore Specific SQL Database Backups Using dbatools in PowerShell
I'm working with a directory of mixed SQL Server backup files and need to restore a specific database using dbatools in PowerShell. Below is the directory structure of my backup folder:
PS C:\Users\...
-1
votes
2
answers
92
views
Why does restoring a database on a different server bring in the backup info into the msdb db of new server?
I restored a db to a different SQL server but interestingly the msdb backupset tables on this server are showing the db backup history from the source server.
Is this expected?
Note: I have not ...
2
votes
1
answer
101
views
RESTORE DATABASE - The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time
While doing a restore of a big database 1.8 TB into a different server
I came across this error message when the restore was about 90% completed:
90 percent processed.
Msg 3013, Level 16, State 1, ...
0
votes
1
answer
28
views
How can I restore everything except stored procedures, functions, users from SQL Server 2019 native backup into another DB Server.?
How can I restore everything except stored procedures, functions, users from SQL Server 2019 native backup into another DB Server?
We are planning to setup a QA environment from clone of PROD SQL ...
0
votes
1
answer
54
views
what to do when database is not synchronizing in availability groups?
I am using
Jonathan Kehayias - Monitoring Availability Group Replica Synchronization
SELECT
ar.replica_server_name,
adc.database_name,
ag.name AS ag_name,
drs.is_local,
drs....
0
votes
0
answers
30
views
MSSQL backup file does not list any databases within it
A customer sent us a .bak file from a 2019 instance. I was running 2014 (other customers are) and knew that 2019 would not restore to it. So I installed 2022Dev, went into SQLMS, and created a new DB ...
0
votes
0
answers
50
views
what to do before restoring a database that is involved in TDE (transparent data encryption)?
I use the following script from John Eisbrener to get the chain of backups, in order to restore them:
WITH BackupHist
AS
(
SELECT
s.server_name
, d.name AS ...
-1
votes
2
answers
23
views
Oracle 10g On Windows Hard-Disk Crash
We had a hard-disk crash of our legacy application on Oracle 10g database server. We were later able to recover all the files in oradata directory. We do not have any recent export files. I had ...
0
votes
0
answers
71
views
FIX: mysqldump: Couldn't execute '/*!80000 SET SESSION information_schema_stats_expiry=0 */
I've already asked this question in the "Stack overflow" website.
I don't understand why they closed my question even if I didn't get a working solution for my setup.
Why did I submit it?
I'...
0
votes
1
answer
60
views
How to force checkpoint before backup is executed in IBM Db2?
In my company coworkers are creating several tests per day on database. After group of changes are performed that take few hours, they request to perform database backup of this test database, before ...
0
votes
0
answers
13
views
Restore Postgres Server from Backup Plain File with PG_Admin or somethin else?
I have created a Backup for the Postgres server via PG Admin 6.17. I would now like to import this plain sql file again on a new server, but there is no button for Restore Server Backup similar to the ...
0
votes
0
answers
52
views
Getting error '87 when trying to restore database SQL Server 2019
I'm running into an issue when trying to restore my database from a local .bak file, with the .mdf & .ldf files being located in my blob storage account in Azure Storage. The following is the ...
0
votes
1
answer
58
views
sql server backup restore multiple require disk space
I took a full backup file of a live system, approximately 210 GB. It's in the downloads folder with the .bak extension. I'm trying to install it locally with the restore database in SQL Server on my ...
1
vote
1
answer
33
views
MySQL tables randomly dropped but .ibd files still exists
I have a database server for a side project and one day between a period of the server being off - three tables been randomly been dropped. But the .ibd files for those tables still exist. There's ...
1
vote
0
answers
67
views
How to restart SQL Server Instance after restore master
At work we have a productive SQL Server working, and we create backups of each database periodically, including system databases master, msdb and model.
I'm trying to restore the whole datawarehouse ...
0
votes
1
answer
207
views
Unable to import constraints using IMPDP in Oracle 19c
I am using
impdp user/password@PDB directory=data_pump_dir tables=tablename dumpfile=DP_3.dmp logfile=card.log parallel=6
there are 2 tables: Table A and Table B
the tables are restored correctly, ...
-1
votes
1
answer
34
views
Backup and Restore Disaster Recovery
I am using PowerShell to write a script for DR, assuming that we only have backup files of all the databases. If i have a latest sql server version and i want to restore some database from backup ...
0
votes
1
answer
65
views
MariaDB restore error - ERROR 1556 (HY000) at line 2562: You can't use locks with log tables
MariaDB Restore fails
mysql --host mydbhost --port 5500 --user root --password < /var/tmp/dump.sql
Enter password:
ERROR 1556 (HY000) at line 2562: You can't use locks with log tables
Dump ...
1
vote
2
answers
96
views
how to change the database create_date after a restore?
I just restored a database, but then I noticed the create_date remains from previous to the restore.
is there a way I can change the create_date to be as the new database (after the restore)?
this is ...
1
vote
0
answers
143
views
How to perform point-in-time recovery in PostgreSQL with PgBackRest and repmgr
I have such setup:
2 VM with Rocky Linux 8 for PostgreSQL Primary + Standby setup
PostgreSQL 15 from official rpm repo
repmgr for replication
PgBackRest for backups to S3 (minio instance)
My goal is ...
1
vote
2
answers
78
views
last backup - how many backup files and where they are?
I am restoring a database, this database is very big and it has 6 backup files (meaning the backup is split into 6 smaller files)
I can see an indication of that using the restore labelonly
...
1
vote
2
answers
78
views
The recovery model cannot be changed to SIMPLE when any files are subject to a RESTORE PAGE operation
One of my pages in database needed restore. so I did a restoration by this command:
USE master RESTORE DATABASE myDB PAGE = '1:4171728'FROM DISK = 'D:\Backups\Database\myDB.bak 'WITH NORECOVERY"
...
0
votes
1
answer
48
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 ...
0
votes
0
answers
43
views
LSRestore job is taking more than 1 hr to complete. Threshold time is 45min
LSCopy and LSRestore job has been scheduled for every 10 mins. I got a trn file on my secondary server after every 6 min from Primary server. LSCopy is synced with LSBackup. The problem is that ...
1
vote
1
answer
192
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 ...
0
votes
1
answer
95
views
How to make sure that all required wal files are availables before starting a standby server?
Im writing a script to restore a postgres standby server that was out of sync with the master node for a while.
I would like the following behavior
Check if i can go with pg_rewind
If pg_rewind fails,...
1
vote
0
answers
52
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 (...
0
votes
1
answer
101
views
When restoring database, why would zeroing log file take a long time?
I am building a new development server that will get weekly automated restores of production backups. This server will be replacing an existing development server where I have this process running ...
0
votes
1
answer
137
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 ...
0
votes
2
answers
52
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 ...
0
votes
0
answers
66
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 ...
0
votes
0
answers
43
views
Cassandra compact executor exception
When I try to load the SStable in through sstableloader, I am getting this following error:
ERROR [CompactionExecutor:28] 2023-09-26 10:48:37,680 JVMStabilityInspector.java:68 - Exception in thread ...
0
votes
1
answer
886
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?
1
vote
1
answer
68
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 ...
0
votes
1
answer
81
views
T-SQL restore database restores old data only
I had a migration from SQL Server 2014 to SQL Server 2022.
I first created FULL backups from the SQL Server 2014 instance, and then ran RESTORE DATABASE script shown below to do a test migration. ...
3
votes
2
answers
311
views
pg_cron: "policy ... for table ... already exists" error while restore postgres database from dump
I'm trying to restore postgresql database from dump on fresh new server. Source database uses pgcron extension, target server have pgcron extension installed.
This is how I create dumps on "...
1
vote
1
answer
48
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 ...
0
votes
1
answer
86
views
Is this enough/proper data to restore an Oracle database?
I was handed some data and was told it was a backup of an Oracle database created by RMAN and stored using Avamar. The owner would like access to the data. It is a folder named like a date, and it ...
0
votes
1
answer
105
views
Is it possible to query Oracle system tables (DBA_USERS,dba_role_privs,dba_tab_privs) Using Db_link?
Is it possible to query Oracle system tables (DBA_USERS,dba_role_privs,dba_tab_privs) Using Db_link?
I am getting ORA-00942: table or view does not exist when tried to query the same.
0
votes
0
answers
105
views
Mongodb setup replica set in parallel on same server
I would like to know how to proceed to deploy a mongodb replica set environment on my servers where, in turn, other mongodb instances are already running, the following happens:
I have a mongodb ...
1
vote
1
answer
593
views
Restoring old raw backup in MariaDB 10.8.1+ without ib_logfile0
I tried to restore an old raw backup of databases (whole datadir) in MariaDB 10.11.5 but it didn't booted up. After that I found following lines in log:
[ERROR] InnoDB: File ./ib_logfile0 was not ...