Questions tagged [restore]

Reloading a database from a backup, typically for disaster recovery, or to make a copy of a database onto another server.

Filter by
Sorted by
Tagged with
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)?
Maria Benich's user avatar
0 votes
1 answer
17 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 ...
Ludo's user avatar
  • 11
0 votes
1 answer
33 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
17 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 ...
FireEmerald's user avatar
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
1 answer
36 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 ...
Vijay Singh's user avatar
0 votes
1 answer
74 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 ...
fiveeuros's user avatar
1 vote
1 answer
63 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\...
Just a learner's user avatar
-1 votes
2 answers
89 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 ...
variable's user avatar
  • 3,591
2 votes
1 answer
100 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, ...
Marcello Miorelli's user avatar
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 ...
Sunil Bopanna's user avatar
0 votes
1 answer
51 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....
Marcello Miorelli's user avatar
0 votes
0 answers
29 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 ...
Maury Markowitz's user avatar
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 ...
Marcello Miorelli's user avatar
-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 ...
Ade's user avatar
  • 1
0 votes
0 answers
68 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'...
Edo Meloni's user avatar
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 ...
folow's user avatar
  • 339
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 ...
Omegon's user avatar
  • 101
0 votes
0 answers
50 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 ...
Tscott's user avatar
  • 101
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 ...
Kadir Çolak's user avatar
1 vote
1 answer
30 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 ...
DarkLlama's user avatar
1 vote
0 answers
66 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 ...
santiago arnesano's user avatar
0 votes
1 answer
197 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, ...
datascinalyst's user avatar
-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 ...
LearningSQL's user avatar
0 votes
1 answer
63 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 ...
fizwit's user avatar
  • 11
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 ...
Marcello Miorelli's user avatar
1 vote
0 answers
138 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 ...
0e39bf7b's user avatar
1 vote
2 answers
76 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 ...
Marcello Miorelli's user avatar
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" ...
mmrz1360's user avatar
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 ...
0xD4rky's user avatar
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 ...
Ajit23jss9's user avatar
1 vote
1 answer
187 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
1 answer
91 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,...
meilleureVie's user avatar
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 (...
datascinalyst's user avatar
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 ...
camaro322hp's user avatar
0 votes
1 answer
134 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
  • 339
0 votes
2 answers
51 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
  • 13
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 ...
Farid Zahidov's user avatar
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 ...
prasanna's user avatar
0 votes
1 answer
863 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
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 ...
Seyed Jafar Mousawi's user avatar
0 votes
1 answer
80 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. ...
user avatar
3 votes
2 answers
293 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 "...
AntonioK's user avatar
  • 133
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 ...
t2m's user avatar
  • 11
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 ...
mikato's user avatar
  • 101
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.
Arun's user avatar
  • 13
0 votes
0 answers
103 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 ...
miguel ramires's user avatar
1 vote
1 answer
575 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 ...
VirtualVoid's user avatar
0 votes
1 answer
74 views

How to corrupt a SQL Server page for test purpose? [duplicate]

I'd like to corrupt a page of any table from AdventureWorks Database. How to do it? I'd like to test page level restore and, also, bring a suspect database online again using dbcc checkdb
Astora's user avatar
  • 713
-1 votes
1 answer
60 views

SQL Server: attach database with filestream error 5

I'm trying to attach a database with full text catalog and filestream, but I'm having some issues with the file stream part. Here's the SQL I'm using (according to this article, this should work): use ...
Luis Abreu's user avatar

1
2 3 4 5
29