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
3answers
52 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
10 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 ...
0
votes
1answer
94 views

how to upgrade postgresql 9.0.4 to latest with minimum downtime

I have master-slave-slave setup for postgresql 9.0.4 in our production setup. We need to upgrade it to latest (11.X), so my question is what would be the procedure to do so with as little downtime as ...
0
votes
1answer
24 views

How to take single database backup using mysqlbackup command in Mysql 8.0.18 version DB

I have a mysql instance(8.0.18-commercial MySQL enterprise server) with 8 databases in it and out of those I only need to take the backup of DB named 'Test1'. Please note that its 300 GB sized DB ...
1
vote
2answers
2k views

Powershell Restore Azure SQL Database to local with Restore-Database

I have written a powershell script that uses Start-AzureSqlDatabaseExport & Get-AzureStorageBlob to export my Azure DB to a bacpac and download it locally, the next step is to restore the bacpac ...
2
votes
1answer
28k views

Oracle 11g Rman restore with another database name from backup in windows platform

Can anyone share the proper method of RMAN restore to another server with another database name in oracle 11g(Windows platform). I'm totally confused with all the RMAN restore methods which I've found....
5
votes
3answers
882 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
2answers
546 views

Cannot recover Database from ibdata file

My Server recently had a Kernel-Panic and I downloaded all the mysql data using the rescue mode. Now when I upload the ibdata1 file and table folders to a local XAMPP Server and click on a table to ...
0
votes
1answer
128 views

Point in time restore fails - backup file from before the restore point not available (why does this matter)

I have tried to do a point-in-time restore of a database through the management studio gui, the point-in-time being yesterday morning (2016-04-12). This fails with the error "...cannot open ...
0
votes
1answer
14 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 ...
0
votes
1answer
18 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 ...
2
votes
1answer
104 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
183 views

End of file reached. Error 38 in SQL. Passes verification checks

Having issues restoring a database in SSMS, error 38. The databases are transferred up to google via their Drive API. Download it on my side and has error. If I transfer it through teamviewer ...
2
votes
1answer
218 views

Developing an Azure Sql Database backup strategy [closed]

I know Azure databases are backed up and kept for a retention period, which I believe the default is 30 days. I'd like to come up with a plan to mimic our current strategy with a physical SQL Server ...
0
votes
1answer
45 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
509 views

barman + postgresql not start after barman retore

I use the barman for backup and restore after some restore , we start the postgresql as the following systemctl start postgresql.service but postgresql not startup from the log: /var/lib/pgsql/...
0
votes
0answers
11 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
1answer
231 views

How to create multiple azure sql database in an elastic pool using powershell script?

I want to create a sql server and deploy the elastic pool on that server. Then create multiple azure sql database in that elastic pool using powershell script.
0
votes
2answers
107 views

Restore previous version of database in sql server

I need your help on restoring previous version of database on SQL Server. In last week I restored database 'A' in DEV server with it's production copy and didn't realize that this database 'A' in ...
13
votes
3answers
19k views

postgres - pg_dump and pg_restore without roles

I'm trying to restore a dump without having the appropriate roles on the receiving database. As mentioned here but also here, you need to have the --no-owner as an option, either in pg_dump or ...
1
vote
1answer
777 views

Will I have to restore controlfile in RMAN level 1 backupset before recover database?

For example, I have a level 0 and level 1 RMAN backupset files like inr00_0413_* inr01_0413_1_* Is it necessary to do this when recover from RMAN level 1 backup: restore controlfile from ...
0
votes
1answer
34 views

Will PostgreSQL server work if I install the service in mounted partition

I have created all tablespaces (only tables created in these tablespaces) in mounted partition, But db is available in pg_default tablespace (root partition where postgresql installed). I am facing ...
3
votes
1answer
5k views

How to restore database from /var/lib/mysql

I have a database folder from a crashed server called gain_wordpress. I'm trying to put that database on a new server but I'm not able to do it successfully. I don't have a .sql dump, all I have is ...
0
votes
1answer
115 views

RMAN restore of primary database - impact on standby database

I've just restored an 11g primary DB that was destroyed. Restored the controlfile from tape and performed a full restore, recovery, and open resetlogs. Looks fine now. How will my physical standby (...
3
votes
1answer
96 views

Log error restoring old database to SQL Server 2017

I am trying to migrate a database from an old SQL Server 2008 R2 to SQL Server 2017. The database was originally 2000 and thus has a compatibility level of 80. Initially I took a full database backup ...
0
votes
0answers
28 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 >...
1
vote
1answer
337 views

SQLServer Linux: Error restoring backup of DB from Windows w/ full-text data file

I'm trying to move a Windows SQL Server database from Windows 10 to Linux. For this, I'm following the instructions in https://docs.microsoft.com/es-es/sql/linux/sql-server-linux-migrate-restore-...
5
votes
3answers
364 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 ...
1
vote
2answers
2k views

Repair/Recover data from MySQL database

I have a big problem with a MySQL database stored on my raspberry (InnoDB engine). I'm not very expert in this field but I'll try to explain to you the problem. MySQL crash everytime that I try to ...
0
votes
0answers
44 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
42 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
1answer
795 views

Restoring dump(backup): ERROR 1022 (23000) at line 44: Can't write; duplicate key in table

I'm doing tests to change a current table from my InnoDB database to Archive, but I had a problem trying to restore a dump after the change. After several tests, the problem is related to the value ...
0
votes
3answers
1k views

Huge mysqldump import

I have a 200+GB mysql dump file that I need to import into the local sql server running on my development machine. I attempted a naive dump restore using the mysql < db_backup.sql approach and ...
0
votes
2answers
54 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 ...
1
vote
2answers
83 views

mysqldump file restore while sql is still being dumped

Im using MaridaDB 10, but my question applies to all mysql variants. I have large dataset (70GB uncomressed when dumped to file). The mysqldump process takes 2-3hours. The restore process takes even ...
2
votes
2answers
978 views

Extract one MySQL database from a FULL MYSQL Server backup file

I have a small shared windows server on which i'have installed MySQL 5.1 engine for hosting my user's mysql databases. I backup the complete MySQL databases each day by running this script as batch ...
0
votes
2answers
1k views

Cloning the database to another server with raw data files

I'm trying to clone the database of server 1 to server 2 with raw data files. I'm using Linux 7 and Oracle 11g R2. I have the instance running with same SID in Server 2 but file structure is different....
2
votes
3answers
76 views

when we restore and when we recover a database?

Restoring involves copying backup files from a secondary storage (backup media) to disk. This can be done to replace damaged files or to copy/move a database to a new location. Recovery is the process ...
0
votes
0answers
12 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
2answers
125 views

Multiple DB restore in sequence

I am restoring several MariaDB databases into a Amazon AWS RDS MariaDB instance from an AWS EC2 machine in the same VPC / region etc. I am using a shell script like so: mysql -u root -h hostname....
30
votes
5answers
60k views

pg_restore: [archiver (db)] could not execute query: ERROR: schema “public” already exists

I am using pg_dump / pg_restore to backup and restore a PostgreSQL database, but am getting some error messages (and a non-zero exit status) from pg_restore. I tried a super simple base case (outlined ...
0
votes
1answer
82 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
45 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 ...
0
votes
1answer
190 views

recovery with binlogs?

I would like to know if there is a way that I can restore my databases, I don't have a replication and I would like to migrate my databases without downtime or losing data. So with binlogs could I do ...
2
votes
4answers
2k views

How do you restore a particular table in MySQL?

One of our users has deleted a table by mistake. How can I restore only that table?
0
votes
2answers
82 views

SQL DB After Restore Script execution

I have a SQL Database that is being restored every day from a Production SQL server. The restore is being done by a third party application. Once the DB is restored I need to set some specific user ...
0
votes
1answer
80 views

Mongodb restore “local” db

I need to restore a replica set. Unfortunately my lack of experience as administrator (I'm not) let me with the only solution of restore the replica using the data of the primary db (the only replica ...
2
votes
1answer
74 views

Recovering credential data from a master DB backup

On a SQL Server 2008 R2 instance, a misconfigured credential used as a SSIS proxy for an SSA job was dropped before I could look at the system views to figure out when it was originally misconfigured. ...
4
votes
4answers
9k views

Restore a database with a different name on the same server

I need a copy of a live database called Carers on the same server for testing purposes. The test database name will be Carers_Test. I took a backup of Carers using SSMS. And tried to restore it using ...

1
2 3 4 5
25