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,414
questions
-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 ...
- 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 ...
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 ...
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,...
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 (...
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 ...
- 19
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 ...
- 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 ...
- 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 ...
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 ...
- 1
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?
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 ...
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. ...
shaolinmonk
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 "...
- 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 ...
- 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 ...
- 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.
- 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 ...
- 149
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 ...
- 103
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
- 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 ...
- 151
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 ...
- 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 ...
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 ...
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 ...
- 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 ...
walyzfan1
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 ...
- 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, ...
- 1,149
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 ;
...
- 103
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
- 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, ...
- 101
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 ...
- 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 ...
- 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 ...
- 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
...
- 21
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 ...
- 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 ...
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 ...
- 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 ...
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 ...
- 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 ...
- 111
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" ...
- 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 ...
- 83
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. ...
- 210
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 ...
- 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 ...
- 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 ...
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 ...
- 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 ...
- 105
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 ...
