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
0 answers
22 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
21 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
0 votes
1 answer
44 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
20 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
51 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
20 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
35 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
-2 votes
0 answers
9 views

Restore Odoo V7 database under postgreSQL 9.2 from hard copy of the database directory

I want to restore a 9.2 version of postgresql database, for odoo 7.0, from a windows backup of the database directory. Restore from a directory is not a standard function allowed with PGADMIN III.
Automotive Dedax's user avatar
0 votes
1 answer
28 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
  • 1
0 votes
0 answers
22 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
84 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
44 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
  • 550
-1 votes
1 answer
18 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
85 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
25 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
18 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
53 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
556 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
73 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
30 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
43 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
80 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
28 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
40 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
145 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
38 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,360
2 votes
2 answers
164 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
108 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
63 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
26 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
76 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
72 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
178 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
174 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
259 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
63 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
189 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
148 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
57 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
107 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
72 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
191 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
2 votes
1 answer
183 views

SQL Server - Restoring backup with SQL Server Management Studio restores another database than running a 'restore backup' query

These are the steps I have performed: I have run a 'restore backup' query for an old database backup Then, I restore a backup with SQL Server Management Studio. I changed the type of some columns and ...
Guido Passage's user avatar
0 votes
1 answer
326 views

Cannot open backup device 'D:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\‪D:\DB_backup\uni.bak'

I have 2 database backup files casa.bak (25 GB) and uni.bak (176 GB) in the same folder. I'm using the same script to restore the database for both files previously both were working successfully. Now ...
Muzammal arshad's user avatar
0 votes
1 answer
289 views

Postgresql Sequence Hopping

I have recently migrated (dump and restore) my database from AWS RDS PostgreSQL v12 to Aurora Serverless v2 PostgreSQL v14.6. The issue is we have setup sequencing in a table on old RDS, now in the ...
sam's user avatar
  • 11
3 votes
1 answer
171 views

During an online piecemeal restore, is it possible to restore to a point-in-time?

I have a database (full recovery model) with multiple filegroups, that each have full and diff backups. I am able to replicate an online piecemeal restore (SQL Server 2019 Enterprise Edition) as it is ...
Matthias L's user avatar
0 votes
1 answer
72 views

SQL Server 2019 - Take backup of a single table from a secondary filegroup using SSMS

I am working a database with a size of 325 GB total. Out of this a single table Documents is occupying 321 GB storage and the rest of the 84 table occupy the remaining space. As the database is ...
user avatar
0 votes
1 answer
148 views

Exporting via Phpmyadmin Charset

MySQL 5.7 I am exporting my db from my web host using phpmyadmin. This produces a single .sql file. When I check the export with Notepad+, there are special characters in the file. e.g. in my source ...
TheOrdinaryGeek's user avatar
0 votes
0 answers
116 views

Dealing with Corruption

I started getting Error 823 alerts from my SQL Server. When I checked SQL Server error log, I found lots of this: A read of the file 'path\to\my\file.ndf' at offset 0x00000d5f850000 succeeded after ...
Sicilian-Najdorf's user avatar
0 votes
1 answer
90 views

Unable to restore a restore a MSSQL db from .bak file because of size unavailablity in disk

I need to restore a database from a .bak backup. When i tried it is showing insufficient disk space becuase the mdf and ldf files are also moving and in those ldf is aroud 100GB. Is there a way to do ...
Nidal K I's user avatar

1
2 3 4 5
29