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
1answer
24 views

How to restore SQL Server database to a particular time?

Is it possible for me to restore a SQL Server 2019 database up to a particular datetime? The database backup is full backup. Thanks.
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
45 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
79 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
0answers
47 views

Why is the restore failing? [closed]

i can't see the database tables i just backed up. I don't understand what the problem is, do I have to enter the password? But when I create the backup copy, it doesn't ask me for the password. I ...
2
votes
2answers
973 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 ...
-2
votes
0answers
42 views

Vm went out of space due to database restore

While trying to restore a database the vm ware went off due to low space. The database data files resides on a separate drive other than C: drive. My question is if the data drives becomes full during ...
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
73 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 ...
-1
votes
0answers
21 views

SQL Server restore bak file [closed]

I am trying to restore a .bak database. I located the file correctly, and I can find it with the restore wizard, but when I am trying to finish the restore, the file doesn't appear in the check list.
0
votes
0answers
11 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
117 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....
29
votes
5answers
59k 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
42 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
43 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
187 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
77 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
79 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
7k 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 ...
2
votes
1answer
103 views

Missing mysql, sys, performance_schema

I have Percona Mysql 8.0.19-10 on debian 10. A year ago I had some issues restoring a backup that required me to mess with tablespaces. I forget what all I had done but eventually I got the database ...
4
votes
1answer
90 views

how to remove all permissions in a database?

every time I need to either restore a database or reinitialize a replication publication I first (on the restored to be or subscription database) I script all the permissions, triggers, indexes, ...
1
vote
1answer
3k views

MySQL Point in Time Recovery For Just a Single Schema?

Is it possible to simply restore a single schema and bring it to a point in time (Say three hours ago) without bringing the entire database back? I can think of a lengthy method of backing up each ...
7
votes
1answer
144 views

How to restore a specific table from a big mysqldump file?

From a very big backup file (created by mysqldump) I need to bring back only one (or a few) specific table(s), without loading all tables. Are there any fast alternatives?
0
votes
0answers
12 views

Point-In-Time Recovery of a single table having full physical backup in MySQL?

I need to do a point-in-time recovery, having a full physical backup and the bin-logs available. One way is for sure by mean of an external instance where one can restore the full database and then ...
1
vote
1answer
521 views

MongoDB Unrecoverable Failure

My machine (OSX) had a power failure and when restarted, I have one db in MongoDB that is completely unrecoverable. I am using the db per directory with dbpath and logpath specified options and was ...
2
votes
1answer
1k 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
20 views

How to get lsn(xid) numbers of transactions from WAL file?

I'm looking for a way of getting transactions from WAL files. Basically I need their LSN numbers. (ideally both transactions LSN numbers and WAL files first and last LSN numbers) I have a PostgreSQL ...
0
votes
1answer
121 views

Having two data folder in my postgresql setup- Postgresql

I am using centos 6 and installed Postgresql_9.4 using the following commands yum install postgresql postgresql-contrib postgresql-client pgadmin3 yum install postgresql-server After that i ...
0
votes
1answer
209 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:\...
0
votes
0answers
3k views

The media family on device '<BAK file>' is incorrectly formed. SQL Server cannot process this media family

RESTORE VERIFYONLY and RESTORE DATABASE always fail immediately with this error: Msg 3241, Level 16, State 201, Line 1 The media family on device '' is incorrectly formed. SQL Server cannot process ...
3
votes
2answers
581 views

Applying (log backup) LSNs to the secondary node of an Availability Group

I have a test instance configured as always-on go down today due to a restart of the primary node and the file-share going down together. I had a bunch of problems in order to get the secondary ...
5
votes
3answers
4k views

Backup a database from Azure SQL Managed Instance and restore to on premise SQL Server

I have three databases that I am migrating to Azure SQL Managed Instance. One is a Utility database, just a small collection of generic functions and procedures. One is the OLTP database for a web ...
0
votes
1answer
134 views

Restore user db from UNC

I need to create a job that restores all user databases from UNC to my SQL Server. All the backups, for 3 days, are located in the same folder and I need to restore the last modified backup. What is ...
0
votes
0answers
33 views

Restore FULL Oracle DB from ORADATA after DISK fail

my system DISK crashed and know I have to restore my oracle from ORADATA only. CTL, DBF, REDO is okay because system was shutdown normally. I installed new harddisks and new OS. After that I installed ...
2
votes
1answer
60 views

How can a database have a logical name that is different than displayed in SSMS?

I found that on a production server there is a database named MYOBInterim. On other environments (development, testing), there is, instead, a database named MYOBTraining. (Don't ask me why - I'm still ...
2
votes
1answer
242 views

Restoring a MS SQL Server database on Linux

I am running Manjaro Linux and I am trying to restore a Microsoft SQL Server database from a .bak file. I am trying to follow the official documentation, but it doesn't seem to work! ➜ ~ sudo ...
0
votes
2answers
27 views

Speedup MYSQL(8.0.13) Restore from .sql file

I am receiving .SQL(500mb) backup file and restoring to MYSQL (8.0.13) database. Currently, restore is taking 5 hrs to complete. I would like to speedup the process and started working on it. Here are ...
1
vote
1answer
115 views

Copy postgis layer from S3 to Heroku

I have a dump of a postgis layer (layer.dump), which I am trying to add to my heroku database (mydatabase). The postgis layer is stored on S3 (https://s3.amazonaws.com/layer.dump). I would like to add ...
2
votes
1answer
84 views

Recover mysql using data folder

One of our MySQL servers died but somehow we were able to recover all the files from it. This server was a slave at one time however we stopped it being a slave so we could use it for housekeeping ...
0
votes
1answer
19 views

Is there a better way to add failed node back to postgres cluster?

There are 2 nodes in the cluster: node1(primary) and node2(replica). I will shutdown node1 and promote node2 as primary. I'll add the node1 back to the cluster (as a replica this time), so I am using ...
0
votes
1answer
83 views

Unistalled MySQL 5.6 and installed MySQL 5.7 - Restore Database and Tables

All of the data resides in "C:\ProgramData\MySQL\MySQL Server 5.6\data". There are 46 folders inside of this folder. There is one folder for every old database I had. For example the first three ...
0
votes
0answers
10 views

Azure SQL MI PITR got failed

We were trying to restore a database on the same SQL MI with older date and different name but it got failed and we did get any information from the error message. This is also causing issue while ...
0
votes
1answer
100 views

postgres: WAL ends before end of online backup

We are running Postgres 9.6, with 10+TB size. Backups have been taken using a homegrown tool "pgrsync", which uses S3 as the repository. Both the backup files and WAL archives are stored on ...
1
vote
2answers
46 views

Fast Backup and Restore of Growing Databases

I work in Tech Support and the some of the products I support are heavily database dependent (PostgreSQL and MySQL, but most of the big ones are MySQL). Before we do an upgrade, we always take a full ...
0
votes
1answer
99 views

Restoring a managed SQL instance in Azure using PowerShell

I am trying to figure out how to restore a database from one managed SQL instance to another. I'm following the tutorials, but I keep running into inscrutable error messages. Here's my command: ...
2
votes
1answer
77 views

Source Database of a restore stuck Restoring

I have copied a database vn_Budget_2021_BofDOct29 to the database vn_Budget_2021_Rig2. I did this through Tasks->Restore Database shown in the second image. I saw this similar issue except the ...
2
votes
1answer
33 views

postgres: do I really need to use Collate and Ctype when restoring database?

Need to import in Linux a Windows postgres exported database. In windows it's listed as follows: Name | Owner | Encoding | Collate | Ctype | Access privileges -----...
0
votes
2answers
72 views

Can't create diskgroup in Oracle 19c

I've successfully installed Oracle 19c with this article. Now I need to restore the database from existing backups. I've first restored the control file, then I started to restore the database: rman&...

1
2 3 4 5
25