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
1
vote
2answers
1k 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
1answer
470 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
1answer
18 views

SQL Server - SQL script to restore database backup file into a new database

I am trying to create a SQL script to restore a database backup file into a new database in SQL Server. I can do it manually without problems: Right click on Databases => Restore Database Tick on ...
0
votes
0answers
11 views

Restore mongodb database from blockstore snapshot backup

I have a situation where I need to restore the mongodb database from the blockstore snapshot backup taken from the ops manager which is used to manage 3 node replica set. I need to restore this backup ...
8
votes
1answer
306 views

Is it possible to restore a SQL Server Linux Backup on SQL Server Windows

I am running SQL Server in docker on a mac. I have taken a SQL Server backup from windows and restored it in the mac SQL Server docker instance. Now I want to take a backup from the SQL Server docker ...
0
votes
2answers
58 views

Can't alter database roles on a restored database

My SSMS Login (using an AD group) is allocated all server roles apart from sysadmin so I have quite a lot of access. Using this Login, I have restored a database from its .bak file. However, my Login ...
1
vote
1answer
232 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-...
0
votes
1answer
460 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
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 ...
4
votes
1answer
198 views

What is Data Virtualization?

I've just been asked whether our company should consider Data Virtualization for our test environments. The benefits are given as: Screening of sensitive data Fast data refreshes in our test ...
23
votes
4answers
49k 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
0answers
18 views

Always on Availability Group not allowing restores on secondary replica [closed]

I can’t restore backups or t-logs to my secondary replica and perhaps you can lead me in the right direction or if you've seen this before, give me a hint. I inherited an environment with zero ...
3
votes
2answers
2k views

After Restore Log_reuse_wait_desc of Replication

I'm wondering if anybody has ran into this issue before and has any suggestions on what's causing it/how to fix it. We are restoring a database into lower Dev environments and after the restore the ...
1
vote
2answers
2k views

SQL Server Editions: Backup restore of Enterprise Edition 2014 on Standard Edition 2017

I know, this kind of question has already been answered some times but I don't find some current answers and wonder if SQL Server Standard Edition 2016 SP1 has changed something in the matter as it ...
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
631 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
1answer
11 views

restore table and populate new data from transaction log

I use mysqldump nightly to backup a database. I'm trying to find a way to do a partial restore on the data from one table. I use the --master-data flag so I know where in the transactions log my data ...
3
votes
2answers
2k views

Prevent logins loss when restoring a database

I'm backuping and restoring databases accross two sql server (v12.0.2000). But it looks like whenever I restore a .bak file, the login I created on the database that was backuped is no more existent ...
2
votes
1answer
647 views

Postgres very slow on server [closed]

Restoring a single table on the server is very slow From Fri Jul 22 13:54:48 CEST 2016 to Fri Jul 22 14:17:41 CEST 2016 Server 2016-07-22 13:55:11 CEST [88719-1] tester@test LOG: duration: 22988.122 ...
1
vote
1answer
551 views

SQL Server DB Restore Unable to browse directory [closed]

I have a problem with SQL Server 2008. When I try to restore a backup (located in the default location). This error appears. Cannot access the specified path of file on the server. Verify that you ...
0
votes
0answers
11 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 ...
2
votes
2answers
962 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 ...
1
vote
1answer
2k views

MariaDB: point in time backup recovery with binary log using position

Following the below sequence of commands i expected the recovery of backup and subsequent point in time recovery using binary log. However, the database was restored to backup only: 1) CREATE TABLE ...
7
votes
2answers
597 views

Automation of backups of Large Number of Database

In a multi-tenant web application where a database is set up for each tenant, the database can be backed up and restored manually through a fairly conventional approach. I am considering this type of ...
0
votes
1answer
27 views

views restored from backup in a different server referring to linked servers

I have 3 SQL servers X, Y, Z and 2 databases X.A and Y.B. There are (many) view in X.A that uses 4-level naming in their definition: SELECT ... FROM Y.B.SCHEMA.TABLE From this I infer that X ...
0
votes
0answers
23 views

Restore job “stuck”

After a restore job I can't read from database until I kill that long-running job. I'll try to give as much info as I can but being that I'm stuck I'm not sure what is pertinent. We are using ...
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....
3
votes
0answers
53 views

Why recovery took longer time even though analysis phase is not that long

We are doing Volume Snapshot restoration from Production to Warm Stand-By Server on daily basis. Daily it takes around 10 mins for DB to recover. But yesterday it took 44 mins to recover. I am ...
3
votes
2answers
84 views

Restoring MDF without LDF file

I am trying to attach a database just from the MDF file, cause the server crashed and could never find the LDF. I am on a 2019 MS SQL Server. I am following the instructions from this page. I have ...
2
votes
1answer
34 views

Large MySQL database dump/restore [closed]

Got a quite interesting task: Have to dump mysql databases from AWS and restore on a private cloud. Databases are quite big: 160GB, 120GB and 21GB each db.sql dump - all 3 in the same aurora rds ...
1
vote
1answer
32 views

SQL Fast database restore with Azure Virtual Machine instant recovery snapshot and SQL in Azure VM?

I have a large database. If I want to restore to a point in time using a full back up, it takes around 4 hours + time taken for transaction log restores. I also have VM image instant restore ...
6
votes
1answer
304 views

SQL Server: Get location of transaction log from MDF file

Our SQL Server 2012 Express server crashed and lost some data. We managed to rescue the main MDF, but can't find the LDF. Is there a way to get this information from the database MDF file or msdb, or ...
0
votes
2answers
92 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....
1
vote
2answers
27 views

MySQL replication master-slave

I'm learning master-slave replication with MySQL and I could get it to work and also use the Percona backup tool to restore a slave. I learnt from this project https://github.com/vbabak/docker-mysql-...
9
votes
3answers
2k views

Restoring ANY database to Azure MI fails

Our freshly provisioned Azure SQL managed instance fails restoring backups from URL. According to the server log the restore itself seems to finish after a certain amount of time but errors in ...
0
votes
1answer
21 views

Is it possible to restore single postgreSql database to PITR?

I have PostgreSQL instance with n databases on it. Is it possible to restore just a single database using PITR ? # restore tar xvfz /var/lib/postgresql/db_file_backup.tar.gz -C /var/lib/postgresql/10/...
0
votes
1answer
40 views

SQL Server: Get latest backup restore

We had a SQL Server crash and most of the data is unobtainable. I have found some old full backups and some differential backups in different servers. Is there a way to tell which differential ...
1
vote
0answers
20 views

PgAdmin: backup and restore schemas using the GUI

I know how to backup and restore one or more schema(s) from a PostgreSQL database using psql: Go to the folder that contains the executables of PostgreSQL: cd C:\Program Files\PostgreSQL\11\bin ...
0
votes
1answer
175 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 ...
0
votes
0answers
19 views

How to restore inno db table to mysql 8.0?

Something wrong with my ibdata1 file in mysql 5.5, now I only have *.frm and *.ibd files for my inno db tables, And I know the structure for my tables, so I can create empty tables in mysql8.0. Is it ...
3
votes
1answer
848 views

Loading SQL Server from SQLite with image data

I am trying to load a SQL Server database table from a SQLite database. I have been unable to transfer the data between the two databases since there are: Difficulties in accessing the data in the ...
0
votes
2answers
49 views

How to find the current Log Sequence Number (LSN) of a database that is in Restoring state?

I removed one of my databases from the availability group on my secondary replica in my AlwaysOn group for an experiment. I want to add it back, but I cannot do so because the databases needs to be ...
1
vote
1answer
650 views

restore mongodb sharded cluster to another server

MongoDB version is 2.4.12 Production Server has 3 shards and each shard have another 2 replica sets. Config server & router also runs on these servers. Backup procedure : 1. Shutdown one of ...
2
votes
0answers
46 views

Remove table from DEFUNCT filegroup so we can recreate the table again in a different online filegroup

We have a BIG production database. We also have STG and UAT servers, where we restore the PROD database. One of the biggest tables (+250 GBs) in this PROD database is in the SECONDARY filegroup. We ...
2
votes
1answer
839 views

Galera - single database backup & restore

I have a MariaDB Galera cluster. One of its nodes is dedicated for the backups (pc.weight=0 and the MaxScale SQL proxy doesn't know it exists). I'm using mariabackup --backup --galera-info --target-...
0
votes
1answer
24 views

How to bring all replicas on a SQL availability group to an earlier state / point in time?

I have a SQL Always on availability group, with 4 replicas. One of them is the primary. Lets say someone accidentally drops a table on the primary. This transaction would go to all of the secondary ...
0
votes
0answers
8 views

sp_AllNightLog - Not restoring differential backup at the start of the process

I have setup [sp_AllNightLog] and running backups in production site with no issues. I have FULL, DIFF and LOG backups happening. Using version 3.5 and sql 2014 build 12.0.5659.1 When I run [...
1
vote
2answers
47 views

Associate BAK file with SQL Server database

One of our users deleted a lot of data from one of our database applications, and I need to find a way to restore it. I have a bak file and full recovery mode, but there is a catch. This bak file is ...
1
vote
3answers
330 views

Creating/restoring mdf/ldf to non-default file location giving access denied

Default folder is typical C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA. But C: drive on server is almost full. So, in restoring an 11gb database from another server, I ...
0
votes
1answer
199 views

Restoring a FrontBase database

I have a FrontBase database that I am trying to restore. This is a database system I have no experience up until now so this may be a basic question. I am issuing the following command to restore c:\...

1
2 3 4 5
24