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

Managed Instance Failover Group Not Replicating New Databases

I have setup a managed instance failover group in Azure, but when I restore my databases onto it (small databases) they don't replicate across to the secondary. I did the restores yesterday and they ...
Matthew's user avatar
  • 31
0 votes
0 answers
38 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
42 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
34 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
50 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
36 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
  • 329
0 votes
2 answers
40 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
35 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
31 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
196 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
56 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
37 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
2 votes
1 answer
115 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
  • 123
1 vote
1 answer
34 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
55 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
54 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
62 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
0 votes
1 answer
211 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
49 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
Potter's user avatar
  • 630
-1 votes
1 answer
27 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
317 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
29 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
19 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
0 votes
0 answers
58 views

Is it possible deleted partially?

I executed delete query delete from [table_name] After execution, I found that 'where clause' is wrong so I cancelled the query using cancel buttion in SSMS. and then I counted the table record. I ...
gnc's user avatar
  • 1
5 votes
1 answer
575 views

How to restore transactions after full backup

I am moving my SQL Server database to a new windows machine, however, I do not want to lose any transactions during this process. I have been unable to find anything around this anywhere which this ...
user avatar
2 votes
2 answers
82 views

Are SQL Server stored procedures backed up by default?

We have two servers running SQL Server 2019 (15.0.x). When we do a full database backup (by right-clicking the data base, then Tasks, then Backup), does that include backing up the all items under ...
FreeMan's user avatar
  • 221
-1 votes
1 answer
37 views

Understanding "Size" Column in RESTORE FILELISTONLY for Differential and Log Backups in SQL Server

I'm trying to understand the meaning of the "Size" column in the output of the RESTORE FILELISTONLY command in SQL Server when it's used with differential and log backups. For full backups, ...
Fajela Tajkiya's user avatar
0 votes
0 answers
48 views

after restroring tablespace table or view not exists

I've Oracle CDB with PDB In the PDB I created a tablespace then I created a table over this tablespace after that, I login into RMAN for the CDB database then I make a backup using backup database ; ...
Tariq Hajeer's user avatar
0 votes
1 answer
132 views

Restore backup global using pgadmin

I created backup global by rightclicking Postgres 15 in pgadmin It generates .sql file. How do i restore the backup global in pgadmin ? I tried searching on google but didnt found the answer
LLL's user avatar
  • 101
0 votes
1 answer
36 views

SSISDB rename for maintenance

We have an SSISDB database that has become too large and we wanted to do some maintenance on it. I've read that you shouldn't rename the SSISDB database as it would break links to existing packages, ...
Nolan St. Martin's user avatar
0 votes
0 answers
51 views

can I recovery specific table from .DBF files in oracle?

I have oracle 19c on windows10, I accidentally corrupted my System TABLESPACE file(Description). But my USERS tablespace Not damaged, Can I recovery my tables from this file on windows? I haven't any ...
henrry's user avatar
  • 111
0 votes
1 answer
320 views

Mysqld won't start although lower_case_table_names is 0 and match the data dictionnary

I copied a mysql 8.0.26 database from a Linux server to my Windows box but mysqld won't start. Either it's this (with lower_case_table_names=1): [ERROR] [MY-011087] [Server] Different ...
Micromega's user avatar
  • 111
0 votes
1 answer
46 views

How does sql server derive the `Restore As` value?

When I'm restoring a database, it is auto populating the original file name and restore as. The check box (relocate all files to folder) is to change the destination path. No matter if this checkbox ...
variable's user avatar
  • 3,430
2 votes
2 answers
239 views

Why recover database request archived log from the future

It suddenly throw error when I trying to do our monthly backup verification, it failed on recover database command with : ORA-00279: change 26378396150 generated at 05/31/2023 03:52:48 needed for ...
Agung SV's user avatar
0 votes
1 answer
145 views

While restoring from mysqldump file, how do I write the table names to a log file?

Sometimes I've run into situations where developers have changed structures, added/removed columns on different DB servers, environments, etc for the same table and this causes errors such as ERROR ...
site80443's user avatar
  • 119
0 votes
0 answers
99 views

postgresql with timescaledb backup/restore and upgrade issue

My customer is using TimescaleDB 2.3.1 at PostgreSQL 11.20. We are trying to upgrade PostgreSQL and Timescaledb currently I installed PostgreSQL 13.11 and and TimescaleDB 2.11.0 I backedup the ...
Murat Suluhan's user avatar
0 votes
1 answer
47 views

Unable to use data pump utility in Oracle to import data to another server

I am using this command: impdp atif/[email protected]:1521/serv1 DIRECTORY=DATA_PUMP_DIR DUMPFILE=mltpltblbkp.dmp LOGFILE=mltpltblbkp.log to import data from one server to another. this is my ...
dbafix's user avatar
  • 54
1 vote
1 answer
77 views

Worst performance multiple left join big tables after restore DB

Problem Database: PostgreSQL 13.8 (Debian 13.8-0+deb11u1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit After migrate from DigitalOcean to strong Dedicated Servers ...
M. Garbarczyk's user avatar
0 votes
1 answer
102 views

SQL Server database not able to update after restoration

We are migrating an application's database between servers and we have used the Attach method to attach the database files to the new location. After re-pointing the application to the new database ...
ETA's user avatar
  • 1
1 vote
0 answers
225 views

Mariadb large live database dump/restore fails when using recommended options

I have a 58Gb database that is live, using InnoDB engine and I want to dump restore it to a development machine for test purposes. I'm using mariadb 10.4 client and servers on Debian 11 Buster. I've ...
Eamonn Kenny's user avatar
0 votes
1 answer
246 views

This backup set cannot be applied because it is on a recovery path that is inconsistent with the database

I am trying to insert hourly log files after a database has been changed from: "Standby / Read-Only" mode to regular (online) mode to "Read-Only" mode to "Restoring" ...
Java's user avatar
  • 213
3 votes
1 answer
261 views

Keep smaller databases out of an availability group (and recover via backup) to avoid cluster/AG issues taking the db offline?

We have several availability groups and each one has a mix of large databases and small databases, all critical. They're all asynchronous commit because their secondaries are in a different data ...
Bobogator's user avatar
0 votes
0 answers
81 views

Stuck in Rollback of restore operation

I have started a restore operation, in which backup file is in Backup Server. After an hour I cancelled the operation; in order to copy the file into the local server and start the operation again. ...
Meyssam Toluie's user avatar
4 votes
1 answer
203 views

Unable to restore database with datetime2(0) in Partition Function

I have a SQL-Server database with large table that partition by a datetime2(2) column. Some (old) filegroups marked as READ_ONLY. Periodically I make the backup with READ_WRITE_FILEGROUPS option. I ...
Oleg's user avatar
  • 43
1 vote
1 answer
223 views

How to move mdf file to other disk drive when it is "Standby / Read-Only" mode?

I am trying to change the location of mdf and ldf file from one disk drive to other disk drive due to storage limit. Currently, the database that I am trying to move to other drive is in "Standby ...
Java's user avatar
  • 213
0 votes
0 answers
78 views

install database backup from SQL Server 2017 to local PC with SQL Express 2022

I am assisting a client who has recently retired from his original business and is setting up a smaller professional property management partnership. He has been instrumental in setting up a tailored ...
Frank Kay's user avatar
0 votes
0 answers
124 views

Import error 31 on SQL Server RESTORE

Background I'm attempting to build a vagrant box to share amongst the dev team who use a variety of different languages and systems. One of the databases is SQL Server. I have successfully set this up ...
elb98rm's user avatar
  • 133
0 votes
1 answer
93 views

Would MySQL Replication (master-slave) have prevented this problem?

I'm new to the idea of MySQL Replication (mainly because I've never really had data important enough to have redundancy until recently). Today I had a random crash of my MySQL 8 database with the ...
Ethan Allen's user avatar
0 votes
0 answers
228 views

MySQL 8.0 - Recover data from .IBD files after server failure (with files backup)

Recently the MySQL server I was using crashed (8.0), motherboard failure and NTFS corruption on the drive (Windows Server). I had all the files backed up fortunately, so I thought I would be able to ...
Dyr Fenrir's user avatar

1
2 3 4 5
29