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,409
questions
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 ...
- 1
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?
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 ...
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. ...
shaolinmonk
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 "...
- 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 ...
- 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 ...
- 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.
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.
- 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 ...
- 149
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 ...
- 103
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
- 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 ...
- 151
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 ...
- 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 ...
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 ...
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 ...
- 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 ...
walyzfan1
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 ...
- 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, ...
- 1,041
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 ;
...
- 103
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
- 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, ...
- 101
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 ...
- 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 ...
- 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 ...
- 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
...
- 21
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 ...
- 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 ...
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 ...
- 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 ...
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 ...
- 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 ...
- 111
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" ...
- 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 ...
- 83
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. ...
- 202
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 ...
- 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 ...
- 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 ...
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 ...
- 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 ...
- 105
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 ...
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 ...
- 123
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 ...
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 ...
- 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 ...
- 33
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 ...
Fardeen Khan
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 ...
- 177
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 ...
- 181
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 ...
