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
15 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
60 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 votes
0 answers
13 views

Detailed steps for taking backup from Enterprisedb and restore to Community version Postgresql

Could you please provide detailed steps for taking a backup from EnterpriseDB(V 11.13.23) and restoring to the Community version (V 12.18) Postgresql
Cassandra Thrift's user avatar
1 vote
1 answer
53 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
82 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,541
2 votes
1 answer
85 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
20 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
28 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
-1 votes
0 answers
48 views

Restore of database overwriting existing database even though `with replace` isn't set

SQL Server 2022, Standard Edition I have a database on one server (Server 1) called TestDb. I restored it on another server (Server 2) as TestDb_CORS. Users did some testing on the restored database, ...
variable's user avatar
  • 3,541
0 votes
0 answers
25 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
48 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
20 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
37 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
42 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
11 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
34 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
55 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
26 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
56 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
74 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
33 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
30 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
92 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
113 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
71 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
73 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
34 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
122 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
78 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
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
1 answer
80 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
87 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
45 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
0 answers
53 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
38 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
635 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
66 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
60 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
228 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
45 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
78 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
92 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
88 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
418 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
62 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
  • 703
-1 votes
1 answer
47 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 vote
2 answers
709 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
1 answer
30 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
1 vote
0 answers
23 views

Restore oracle database on a new machine with only datafiles and control files?

I lost my laptop and I had an oracle database 11g r2 in it but I still have all the data files, create control files script and nothing else now I bought new laptop and I want to get my data back with ...
Hussein Sarea's user avatar

1
2 3 4 5
29