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
649 views

Oracle database 12C restore script

i'm trying to create backup restore script . in short my backup script creating new directory every day from the operating system level and then backup the database using the directory created i tried ...
Seif Hassan's user avatar
6 votes
3 answers
925 views

Restore database of 90GB to computer of only 100GB

How do I restore a huge Microsoft SQL Server database that is 6GB as a zip file and 90GB as a bak file to a computer that only has 100GB free space? When I uncompress the zip file I get a bak file ...
Gilboot's user avatar
  • 173
0 votes
1 answer
603 views

How to Ensure all Log backups are restored on secondary server in log shipping

I have some concerns regarding the restore job on secondary server in log shipping in Microsoft SQL Server 2016 for below scenario : I have two servers, primary and secondary. The backup, copy and ...
chetan kathote's user avatar
0 votes
0 answers
312 views

MongoDB restore. Recover after failure

Is it possible to resume mongo backup restoration after failure? I'm getting an error 2021-07-01T23:35:01.944+0200 Failed: dbname.collectionname_backup: error restoring from archive 'mongodb-db-...
Alexey  Usharovski's user avatar
0 votes
2 answers
2k views

Restore oracle database 12C incremental backup on daily basis

i need to restore my backup at different database server with following sequence on daily basis level 0 incremental only once level 1 incremental everyday i did the level 0 restore successfully ...
Seif Hassan's user avatar
0 votes
0 answers
521 views

Changed RMAN backup location, but still seeing the FULL DB backup going to the old location?

I just recently changed the db_recovery_file_dest value to our new directory location. I can see the archive logs going to the new location and the backupsets. However, our FULL DB backup is still ...
Phillip's user avatar
  • 11
0 votes
0 answers
294 views

Database users are lost after restore - how to fix

We had many facilities that operate in areas where there is poor/no internet connection; the facility staff sent us monthly a backup of the facility database for us to restore it on our data center. ...
Anas Tina's user avatar
  • 101
1 vote
1 answer
715 views

mysqlbinlog - Binlog has bad magic number error when reading dumped file

I am learning MySQL and performing a test point in time restore using MySQL Server 8.0 on Windows 10. I am having an issue re-playing the binary log as follows. First, set up the test database mysql -...
SE1986's user avatar
  • 1,950
1 vote
1 answer
1k views

postgresql vacuum analyze on restored snapshot

Frequently we restore a Postgres DB from a RDS snapshot to an entirely new RDS instance. We notice that queries on certain tables perform really slowly but improve by a huge magnitude after running ...
sumit's user avatar
  • 143
0 votes
1 answer
736 views

Error: relation doesn't exist on self referencing check constraint when restoring database

I'm trying to take a database dump from a PostgreSQL 9.4 database and restore it into a 9.6 database. It works, but in the error output I see the following error: ERROR: relation "my_tbl" ...
Primordial_Hamster's user avatar
5 votes
1 answer
281 views

Corrupt a database page in a certain table then restore it

I want to corrupt a page inside a certain table and restore it. How do I do that on SQL Server?
michele 's user avatar
1 vote
1 answer
171 views

Oracle Linux 6.10 - Changing the Oracle user's ID & GID

OS: Oracle Linux 6.10 DB vers: 12cR1 I will backup and restore from NFS shared disk for a preprod server. However, the ID and GID of the oracle user on the production server (shared disk on ...
jrdba123's user avatar
2 votes
2 answers
2k views

SQL Server 2016 database backup fails to restore on SQL Server 2019

We were trying to restore the database from SQL Server 2016 Developer Edition to SQL Server 2019 Developer Edition and it was failing with an exception. Details about this DB: It has in-memory ...
S.D.'s user avatar
  • 746
0 votes
2 answers
2k views

Force database open after incomplete restore (without archive/redo)

For example, let's assume we need to restore the database, but we also have lost all archive logs. So we issue the following command in RMAN (just restore, without recover). RMAN> run{ 2> set ...
Astora's user avatar
  • 701
0 votes
0 answers
1k views

Insufficient system memory in resource pool 'default' when attaching a database

There is a website which uses an MSSQL database, from which the master.mdf and master.ldf files were copied and sent to me, so I can create a local copy of that database. I put these files in a ...
Frankie D's user avatar
-3 votes
1 answer
3k views

The media set has 2 media families but only 1 are provided. All members must be provided

Restore database Currency from disk = 'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Backup\Currency.bak' go
muhammad ayyaz's user avatar
0 votes
2 answers
382 views

How to replicate from Standby mode database

I have set up a pipeline which brings transactional logs each hour from a FTP site, and this newly created database is in Standby mode all the time because I need to read data during an office hour. ...
Java's user avatar
  • 223
-2 votes
1 answer
184 views

Strategy of restoring database with multiple logging files (24 total) at once

I am trying to see whether it is safe and efficient approach if I run a multiple line of SQL command to restore multiple (total 24) logging files at once. These files are formatted in bak file format, ...
Java's user avatar
  • 223
1 vote
1 answer
384 views

Can we do PITR of one specific PostgreSQL database [duplicate]

I am new to PostgreSQL, so please ignore if my question sounds stupid. Imagine we have three databases in PostgreSQL and someone mistakenly ran a TRUNCATE command an hour ago on one of the databases. ...
sachin-SQLServernewbiee's user avatar
0 votes
0 answers
11 views

Restore mysql database from files [duplicate]

Consider the following scenario. I have MySQL installed on a Windows Server. All files in this server are backed up to a NAS drive by Acronis. My server is broken down. I re-installed operating system ...
user avatar
0 votes
2 answers
63 views

Spinning multiple environments from single backup file

I am having a unique situation where my production database size 5TB (SQLSrv) which needs to be replicated across 4 servers daily. I am looking for an option where all 4 environments can use a single ...
Jassi's user avatar
  • 1
2 votes
1 answer
2k views

Strategy on Standby restore option for hourly log shipping file

I am trying to come up with a strategy of keeping up with daily database update process using "standby" restore mode. I am getting 24 log shipping files (for the previous day's each hour ...
Java's user avatar
  • 223
0 votes
1 answer
234 views

How to restore percona database from kubernetes?

I got the backup works by setting these on the helm chart values (it works according to the documentation): google-cloud-storage-s3: type: s3 s3: bucket: gcp_bucket ...
Kokizzu's user avatar
  • 1,363
1 vote
2 answers
314 views

Strategy for standby reporting with different database versions

I am trying to come up with solution for restoring database with one full backup file and then with hourly transaction logs that are going to be created each hour thru FTP site. So, here is a scenario....
Java's user avatar
  • 223
3 votes
1 answer
267 views

Hourly Transaction Log files size not consistent - is this Differential backup file?

I am new to DBA task here. I am trying to restore database with transactional logs (in SQB file format) that our company get 24 times each hour daily thru FTP site, and then I have to convert them to ...
Java's user avatar
  • 223
1 vote
1 answer
207 views

Restoring full back up taking forever

I am new to DB Admin in SQL Server. I am more of a SQL Developer. I am trying to restore 95GB size of BAK file to SQL Server (in Azure VM). The issue is that it is taking more than 24 hours now.. I ...
Java's user avatar
  • 223
0 votes
2 answers
595 views

Database status "restoring..."

I have opened SSMS today, and went to open my database ADMINISTRATOR (in the picture) but this option is unavailable: What's this problem, how can I cancel this restore? I have just added a new ...
developer's user avatar
1 vote
1 answer
122 views

Fixing a Mistake in SQL

While troubleshooting an issue in my company I updated all the files in the table instead of the specific file that needed to be tested using. create table _file_*date*_BAK as select * from _file; ...
RiskSQLCommit's user avatar
4 votes
1 answer
6k views

How do I recover data from the postgres data directory on my hard drive?

I had an old iMac which stopped working a while ago I take weekly backups of the database I was updating which contains feed items from several rss feeds I am still missing the data for the last week ...
PirateApp's user avatar
  • 296
0 votes
2 answers
2k views

Restore database with only ibdata1 file

I need to analyze the client's data and for that requirement client has provided us only ibdata1 file having size around 150MB. I am not aware of table structure and number of tables as of now. After ...
Sushrut Paranjape's user avatar
2 votes
2 answers
1k views

Need help merging multiple full SQL Server Backups into single database

Got a really strange issue with SQL Server database backup files I am getting backup files from the state of California for petroleum production. Each year a database with the same name is created ...
Bart T.'s user avatar
  • 41
1 vote
1 answer
1k views

How Restore backup as overwrite on a database in use in SQL Server? [closed]

I Want to restore a backup with overwriting on a database in use for this problem I want to create a query base on these steps : 1- Remove All Connections [MyDB] 2- Create a backup from [MyDB] 3- ...
Mojtabah's user avatar
1 vote
1 answer
330 views

How is data of multi valued attribute say phone number of person relation is stored in table?

I have searched for the answers referencing my books as well as web but i could not find one. So here i am. I am not sure what this question is trying to ask so help if anyone could.
Nishan's user avatar
  • 19
0 votes
1 answer
244 views

What is the fastest way to make a copy of a 5TB SQL Server DB on the same server without having to fully reinitialize the DB to add it to the AG

I have a 3 node Always On AG that hosts a 5TB database. Due to business requirements, at 12:01am on the first day of every month, I need to create a copy of that database on the 3rd node (replica) ...
Jobs_Done's user avatar
0 votes
1 answer
105 views

Mongodb migration and appending data to existing database

I have two databases in two different machines containing data in same schema. Both have relational mappings in form of ObjectIDs as it is done in NoSQL database. The task at hand is to pick one ...
Ritik Saxena's user avatar
0 votes
1 answer
340 views

Oracle 12cR1 - Duplicate Database With No Resetlogs

Database version: Oracle 12cR1 Operating system: Oracle Linux 7.x ASM: yes Duplicate script: cat duplicatetodisaster.sh ORACLE_UNQNAME=xxx ORACLE_SID=xxx ORACLE_HOME=xxx rman target sys/***@PROD ...
jrdba123's user avatar
14 votes
1 answer
20k views

Clone a database from SQL Server 2019 to 2017 [duplicate]

I try to clone a database from an Sql Server on my local machine v15 (2019) to a server machine v14(2017). I did a .bak file and when I tried to import on the server side it says: System.Data....
serge's user avatar
  • 421
0 votes
0 answers
302 views

Restore backup of SQL Server database results in an error

I want to restore my backup that I get it before has no extension. It's filename is: mssdp-dd-dump-75b5264f8e294595b462ec13a212f225 that has no extension; I don't know how to change extension to .bak ...
taher's user avatar
  • 1
1 vote
0 answers
80 views

Informix onunload/onload between different arch

I have some necro-project using Informix Dynamic Server Version 7.31.UD1. I need to backup-restore database between servers. The thing is, the onload just silently exits and doesn't create a database, ...
drookie's user avatar
  • 228
1 vote
1 answer
39 views

MySQL Like for Like - 100% accurate Backup/ Restore

I've struggled to find the answer to get a perfect backup and restore for MySQL. I need to do performance test on a database so I need to make sure that the page files, indexes, fragmentation - the ...
Adam's user avatar
  • 113
1 vote
1 answer
7k views

Restoring mysql data from *.IBD file

Unfortunately I have recently lost my VPS and the provider restore it after 1 week, then the only things that I had was the raw files on my server which were accessible in recovery mode. so by moving ...
Amin Eshtiaghi's user avatar
2 votes
2 answers
2k views

SQL Server - Restore only primary Filegroup but bring the database online

I'm trying to find out if it's possible to bring a SQL Server 2016 Enterprise database online by restoring only the primary Filegroup. My scenario is, we have a fairly large OLTP database, of around ...
FrugalShaun's user avatar
2 votes
0 answers
327 views

Faster way to restore MySQL innoDB dump

I have a below MySQL configuration. # The MySQL server [mysqld] .... key_buffer = 384M max_allowed_packet = 5M table_open_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = ...
RobinHood's user avatar
-1 votes
1 answer
411 views

import .dmp in Toad : Invalid format of Import utility name Verify that ORACLE_HOME is properly set

When I tried to import a DMP file using TOAD (9.0.1) Import Utility Wizard I get an error Invalid format of Import utility name Verify that ORACLE_HOME is properly set Any suggestions please? I ...
developer's user avatar
-1 votes
1 answer
47 views

Allow users to restore prior days DB to view [closed]

Our application backs up DB at end of day to save End Of Day picture. We need to allow users ( Windows domain users) to restore these prior days backups using our app. This needs to done through a ...
Jask's user avatar
  • 1
0 votes
1 answer
66 views

backup and restore app for databases [closed]

I'm looking for an open source app to backup sql server / mariadb / postgres. Do you know which app can do that ? I want to schedule backups with the app. yes it's possible with only one app . I used ...
Lucas Rasolofoniaina's user avatar
1 vote
1 answer
266 views

Restore of copy_only backup of encrypted database made without FORMAT but with INIT fails

I have a task of making periodical copy of the database, twice a day, and I should not break any backup chain niether accumulate these temporary backups. So I tried to take a copy_only backup with ...
sepupic's user avatar
  • 10.7k
0 votes
0 answers
455 views

ORA-7445 kills PMON instance

I restored an Oracle 12.1.0.2 database using RMAN full backup from a RAC+ASM enviroment to single instance enviroment with less memory and cpu (for test purposes) using this document Doc ID 1338193.1. ...
scH's user avatar
  • 3
3 votes
2 answers
1k views

On docker volume restore: could not access file "$libdir/timescaledb-1.6.0": No such file or directory

I am trying to restore TimescaleDB data from one ubuntu machine to another ubuntu machine. On the both machines we have deployed TimescaleDB through docker and using the same tag. Docker image used: ...
Onkar Janwa's user avatar
0 votes
1 answer
21 views

What is the name of the process for creating a new DB from an exported snapshot? [closed]

I need to set up an automated process that: creates a snapshot of an AWS RDS (MySQL) DB uses that snapshot to create a new RDS instance that will be used as an "analytics playground" I'm ...
hotmeatballsoup's user avatar

1
3 4
5
6 7
29