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
0answers
72 views

Standby restore still causing error after source instance is same version as destination instance [closed]

This is follow up question after this one. I have installed SQL Server 2012 on my Azure VM machine in order to restore BAK file with Standby mode. SQL Sever 2012 is what the source instance has, so I ...
0
votes
1answer
8 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 ...
1
vote
2answers
60 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....
-1
votes
0answers
23 views

SQL1643C The database manager failed to allocate shared memory because the database manager instance memory limit has been reached [closed]

I'm about to restore my database with this command db2 restore database sampleDB from /home/db2inst1/backup taken at 20210505181158 without rolling forward And I got an error message like this: ...
3
votes
1answer
232 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 ...
0
votes
1answer
70 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 ...
0
votes
2answers
53 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 ...
1
vote
1answer
68 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; ...
1
vote
1answer
62 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 ...
0
votes
0answers
11 views

Oracle 11gR2 => Oracle Data Pump (expdp, impdp) => can backup be safely taken during runtime

until now I create a daily Logical backup backup of my Oracle 11gR2 Database at midnight while the database is running but the client application is in an idle state so that no queries are executed on ...
0
votes
2answers
27 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 ...
2
votes
2answers
48 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 ...
1
vote
1answer
37 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- ...
1
vote
1answer
28 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.
0
votes
1answer
59 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) ...
0
votes
1answer
7 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 ...
0
votes
1answer
36 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 ...
1
vote
1answer
420 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....
0
votes
0answers
57 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 ...
1
vote
0answers
11 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, ...
1
vote
1answer
22 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 ...
0
votes
1answer
63 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 ...
1
vote
2answers
50 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 ...
1
vote
0answers
26 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 = ...
0
votes
0answers
38 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 ...
0
votes
0answers
21 views

TimescaleDB restore is not working properly

I did the docker volume restore from a tar file, that worked fine. The data size is around 50GB. When we run docker I was getting below error: 2021-03-19 07:07:17.117 UTC [1] LOG: listening on IPv4 ...
-1
votes
1answer
30 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 ...
0
votes
1answer
45 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 ...
1
vote
1answer
97 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 ...
0
votes
0answers
26 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. ...
2
votes
1answer
65 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: ...
0
votes
1answer
17 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 ...
2
votes
1answer
66 views

Restore from local disk vs SAN on physical machine (SQL Server Linux)

I am new to Linux and our client decided to use SQL Server on Linux. As soon as we started testing, we ran into performance issues. The server in question is a physical machine configured with a SSD ...
0
votes
3answers
112 views

Backup sqlserver 2019 and restore to Sqlserver 2017

I have only 1 table in SqlServer 2019 that I want to backup and restore into SqlServer 2017 in different server. To SqlServer 2019 I have access to server and with SSMS but to SqlServer2017 I have ...
0
votes
0answers
15 views

Mysql backup- restore on multiple host in live replication

MySQL database has 1 primary host which is replicating to 2 Read replicas RR1 RR2 RR1 is master of RR11 RR12 RR13 RR2 is master of RR21 RR22 RR23 I have to make a schema change so I started schema ...
5
votes
3answers
927 views

Size Requirement of SQL Database

I have been asked this question in an interview that how much would be the DB size for a standalone SQL server if 650MB of data is processed every month. I couldn't give any answer to this question in ...
1
vote
2answers
68 views

Can you update a database with transaction logs only, without having to do a full restore?

Initial note I am not a DBA, I am learning on the job. Where I work we have an antiquated third-party system that sends us a .bak file once a week and log files every hour. To get the previous day's ...
0
votes
1answer
17 views

pg_restore using PostGIS/PostgreSQL Dump Changes Data in Geography Column

Two PostGIS databases (PostGIS 3.0, PostgreSQL 13.1) were setup on two separate machines to be as close to each other as possible using Docker images. A dump of the database was taken from the first ...
2
votes
1answer
125 views

Can't restore database with (apparently) same version

I'm trying to restore a SQL Server database instance in my local machine I've backed up from an Azure Cloud environment but I'm getting the following message: System.Data.SqlClient.SqlError: The ...
0
votes
1answer
47 views

SQL Server Data Refresh

I need to be able to restore around 6TB of data from one MS SQL 2008 instance into another SQL Instance. DBA's and backup folk are estimating between 36 and 48 hours for the restore. I can't afford ...
0
votes
1answer
21 views

MySQL import silently failing

I'm trying to import a large (30GB) SQL file (generated using mysqldump) into an RDS instance MySQL 5.7 database, from an EC2 instance on the same VPC. It's importing most without a problem, but ...
0
votes
0answers
13 views

Partial (selective) restore from physical backup of a MySQL instance, possible in version 8+?

I need to perform the restore of some selected tables of my MySQL 8.2 database. I was wondering if it's possible to shutdown the service, replace the related files (from the physical cold backup) in ...
0
votes
0answers
30 views

MySQL faster after restore

I have a table with ~300k records, and query with join other table. A query executed about 2 minutes. But! Yesterday I was backup and restore this database and saw, my query faster 10 times! From >...
5
votes
3answers
368 views

Which factors impact the time for SQL Server Recovery to complete

In a recent planning AWS RDS failover we experienced long recovery times of around 20 minutes. AWS provides some hints around why. large transactions or a lengthy recovery process can increase ...
0
votes
0answers
102 views

Failed (exit code: 1) when trying to restore DB from a .tar file in pgAdmin4

I'm been trying to restore my database and I'm getting an Exit error code 1. The database I'm trying to restore is SuperMart_DB.tar, but every time I get the same error message. I have seen previous ...
0
votes
1answer
46 views

How to restore SQL Server database to a particular time? [duplicate]

Is it possible for me to restore a SQL Server 2019 database up to a particular datetime? The database backup is full backup. The database is full recovery mode, and only one transaction log backup ...
0
votes
2answers
61 views

The media family on device incorrectly formed for read only file group restore

Yes the databases (source and destination) are the same version. I have checked 3 times. Both are "Microsoft SQL Server 2019 (RTM-CU8-GDR) (KB4583459) - 15.0.4083.2 (X64)" The database ...
0
votes
0answers
15 views

Recover old backup with barman

I have setup barman that allows me to backup my database. I have several backup, and I would like to recover an old backup. because I need to check the state of the database at a given time, two month ...
0
votes
1answer
288 views

ORA-31626: job does not exist during schema export

I'm exporting schema with following command - expdp system/system@xxx.xxx.xxx.xxx:1521/orcl schemas=schema-name directory=test_dir dumpfile=Schema.dmp logfile=SchemaLog.log but it results into ...
1
vote
1answer
46 views

Target server is not communicating(polling) with master SQL Server

We set up multi-server administration to create a job on the master which are executed on target servers, and we had this issue because the target server was shut down after a virus attack and we set ...

1
2 3 4 5
25