Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

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

SQL Server Agent Job - Unable to open Step output file. The step succeeded

I have seen many posts with "Unable to open Step output file.", but can't find any references where the step succeeded. I have my output file location set to: $(ESCAPE_SQUOTE(SQLLOGDIR))\$(...
2
votes
1answer
81 views

How to check if backups are reliable?

I generally have to restore databases to different servers after important data imports or other important and delicate database operations. I need to be sure that my backups up to that point in time ...
-3
votes
1answer
53 views

Postgres Restore [closed]

I need to restore a single schema from production postgres to test. Test database and schema already exists. The users/roles & sequences are different on prod to test and after schema is ...
0
votes
0answers
10 views

How to make replication continue to work after repairing?

I would like to share with you a problem I faced today and will be glad if you can help me to tackle that issue. The issue related to transactional replication. So, let's go step-by-step to know how ...
0
votes
1answer
96 views

Unable to restore a PostgreSQL database from a .backup file

I am using Ubuntu 18.04 and PostgreSQL. For the GUI, i am using pgadmin4 (browser version). I created a new database and when trying to restore, the following error message comes up: <!DOCTYPE ...
0
votes
1answer
25 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 ...
1
vote
1answer
90 views

PostgreSQL - do we need to DROP the database and recreate it if we want to RESTORE it?

I worked with many different databases (SQL Server, Oracle, IBM db2) and for all of them if we have a backup it is just enough to execute RESTORE command in order to restore the data. I am beginner ...
0
votes
0answers
22 views

Log shipping - Secondary Server

I am not a SQL Server DBA but I need some advise. I am having a problem with a prod server that’s being pounded by constant queries and data mining. I have a second server that I would like to setup ...
1
vote
1answer
33 views

Legacy data migration to Always on Availability group database

In our application there is a data conversion process that brings all the legacy data to the production database. Since our database is on availability group and the migration might bring 100GB + ...
0
votes
0answers
10 views

What are the considerations when restoring an Oracle db from control file instead of RMAN catalog?

I have a customer that needs to make a testing restore of its Oracle 11.02g database. The destination host is not the source host (so the structures of directories may not be the same). They use ...
0
votes
0answers
18 views

Migrating AWS RDS SQL Server to a smaller RDS instance

I am in the process of migrating an AWS RDS SQL Server to another instance of AWS RDS SQL Server with lesser storage. AWS folks suggested using the native backup/restore option instead of DMS. Steps ...
6
votes
2answers
1k views

How can I restore a master database from its bak file?

During a penetration test I found multiple .bak-files for an MSSQL database. I want to restore them all. In a Windows VM I installed SQL Server 2017. For restoring the master database, I put the ...
0
votes
1answer
52 views

Can you restore purged MySQL binary logs?

I have two situations I need some clarification. 1) Let's say I made a backup of all the MySQL binary logs before I purged a single binary log file (the oldest one, possibly the very first one). ...
0
votes
0answers
40 views

error while restoring database from mysql: ERROR 1006 (HY000)

I made a mysqldump from all my databases prior to fully deinstall and reinstall MariaDB. while restoring the databases with the following command, logged in as root: MySQL -u root -p < /mnt/...
0
votes
0answers
13 views

Migrate data from database on MarkLogic 7 to database on MarkLogic 9

I need to copy data from a MarkLogic 7 database to MarkLogic 9 database on another system. I tried backup and restore option provided by the MarkLogic Admin console. The original database in MarkLogic ...
2
votes
1answer
48 views

How to attach a sql db with blobs using a shared folder?

I use the following query for attaching a sql db: CREATE DATABASE [myDb] ON (FILENAME=N'C:\myDb\myDb.mdf'), (FILENAME=N'C:\myDb\myDb_log.ldf'), (FILENAME=N'C:\myDb\FILESTORE') FOR ATTACH In ...
0
votes
0answers
40 views

how to restore partial-backup created using xtrabackup

I had to take a backup of a single database in my MySQL server of size 2.4 TB. I used percona xtrabackup as mysqldump was taking forever. I used below command for it: xtrabackup --backup -u user -p ...
0
votes
1answer
37 views

Restore database from a save

I use pgadmin 4 and PostgreSQL I try to restore a database from a save. I have put the directory of my file save C:\Users\H2O\Desktop\temp_DB\ as a binary path in file preferences. When I try to ...
0
votes
2answers
34 views

Took a full backup of a running mariadb server and restored, but none of the databases are visible

I'm setting up a mariadb galera cluster to ultimately switch production to. However, I don't have the ability to stop the production instance so I'm trying to set this up using various workarounds I'...
2
votes
1answer
51 views

Oracle isn't restoring correctly a backup

First of all I'll say I'm using: Oracle Database 11g Express Edition Oracle SQL developer What I'm trying to achieve Create a backup and restore it, so for example I can delete a table after a ...
0
votes
0answers
65 views

Restore a 140GB - 292 Million entrie MySQL-Database faster?

i need help. I have an old innodb Server and my storage limit reached. I dont use files per table entries because in old times there were no ability at this time. My ibdata grown up fast and there is ...
0
votes
1answer
34 views

How to restore output from pg_dump into a new table name

I am dumping a large postgres table (~15m records) like this: pg_dump -h myserver -U my_user --table=mytable -Fc -Z 9 --file mytable.dump mydb The above creates a mytable.dump file. I now want to ...
0
votes
0answers
390 views

RMAN restore error to restore archivelogs

I have this backup piece with the archivelogs: BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 54 1.01M DISK ...
1
vote
1answer
81 views

Having a backup of the master key, how can I restore a database that was encrypted by master key?

while setting up AlwaysOn - Availability Group on a test system, I generated all the restores from live and restored them to this new server. then I backup all these databases to a network share to ...
1
vote
1answer
36 views

pg_restoring into a table with a not null column

I'm merging two databases. The newer one has a table with an integer column failed_port which is NOT NULL. The older database does not have this column. So after using pg_dump to dump both ...
1
vote
1answer
179 views

How to specify column positions in insert statements generated by pg_dump?

I need to add a column to a specific position in a table. I'm doing this because I'm merging tables from two different databases: DB1.schema1.table1 has these columns: name_pk | date | type while ...
7
votes
1answer
193 views

After Restoring Log Shipping to Secondary Server, First Stored Procedure Execution is Slow

We've set up log shipping to a secondary SQL server on Standby/ Read-Only to offload all SSRS report generation. This works fine within the restrictions imposed by: Kicking out the user during the ...
-1
votes
1answer
37 views

Database in restoring state and transaction duplicates

I use following PS script to restore database: $sqlScript = @" USE master GO ALTER DATABASE mydatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO RESTORE DATABASE mydatabase FROM DISK = '\\...
4
votes
1answer
79 views

Point in time Restore failed - Error 3456 'Could not redo log record'

I have a database from which all tables got deleted by accident. Unfortunately we do not have a 'perfect' backup and now my problem comes in: FULL Backup is from yesterday, 18:00 LOG Backup wasn't ...
3
votes
0answers
283 views

Restoring from PostgreSQL 9.5 dump to 10 is super slow

I am trying to restore database dump created on PostgreSQL 9.5.16 to PostgreSQL 10.7 and it is taking a lot of time to restore. Restoring the same dump to 9.5 doesn't take that much. So I am wondering ...
0
votes
0answers
343 views

how to dump mysql schema without keys and without constraint ? and keep all of them to alter afterwards

i am using ubuntu 16.04 and want to dump large schema with hounded of tables from AWS rds, remove all keys and foreign key , load data and then add back the keys , is there any automatic tool that ...
0
votes
1answer
140 views

How to restore mysqldump of one database in different databaseName with content of data in the same host machine

Let's start from the beginning there is a MySQL database with name DB1. As I want to restore the mysqldump backup of DB1 database in DB2. The DB2 database is another database in same Host Server ...
2
votes
2answers
34 views

Database Merging / Re-integration

I am a SQL Server DBA. I recently had the misfortune of losing a database due to drive failure. I was able to restore the data but for whatever reason, it stopped at a certain time and not all of the ...
0
votes
0answers
69 views

How to speed up MySQLl loading from dump file?

I'm using mysqld Ver 5.7.25-0 in Ubuntu 16.04. I dumped from AWS Relational Database Service (RDS) with mysqldump --single-transaction --quick --max_allowed_packet 1G ... and now when I tried to load ...
0
votes
2answers
258 views

User and login mapping after an SQL Server restore

I need to restore a DB from an SQL Server instance to another and I am well aware that the DB users will be transferred but the logins won't. I have created a script to be able to create the logins on ...
1
vote
1answer
95 views

Having the backup file, how to work out the total disk space required to do the restore?

I have a nice query that gives me the date of last full backup, size and location, even when I backup to multiple backup files. what I don't have is an estimate of the total backup size (for each of ...
0
votes
2answers
81 views

Recover all databases to a new server

I need to copy an entire SQL Server instance, with all databases from one server to another server in my test lab. I am aware that this can be done the "cold way", by stopping/pausing the databases ...
1
vote
1answer
44 views

Piecemeal restore, filegroup and file extension

As per my understanding (so far) any given user database contains three types of files - mdf, ndf and ldf. MDF stands for meta data file and stores data definition as well as data (in case of small ...
1
vote
0answers
37 views

Couchbase backup and restote through copy data files

I was exploring couchbase backup and restoring procedures then we found standard procedures. But, if I can take data directory backup in the form of .tar and untar data directory whenever restore ...
-1
votes
1answer
548 views

Restore database - Operating system error 5(Access is denied.) on Linux

I try to restore SQL Server 2017 Express database using sqlcmd tool on Ubuntu 16 Server. My SQL command is: RESTORE DATABASE [xxxxx] FROM DISK = N'/home/xxxxxx/DBBackups/xxxx.bak' WITH NORECOVERY, ...
4
votes
1answer
265 views

Does restoring a database break external synonyms targeting objects in that database?

If one has a database where synonyms in another database refer to objects in that database, does restoring a backup into that database invalidate the synonyms? To be specific, imagine this situation: ...
0
votes
0answers
121 views

Restore database using old control file

Our environment has a full daily DB backup system, including the control file at 11 pm. We had a case to restore the database in different environments but with maximum data to recover. Archivelogs ...
0
votes
1answer
32 views

Would installing 32 bit packages on the existing 64-bit VM be an option to run Oracle 9.2?

I inherited an old old 9i DB that now needs recovery. It is unstable (disk corruption and performance problems). I have a backup. In the interest of time - I have 64-bit VMs all over the place, but ...
2
votes
1answer
57 views

Creating encrypted backups inhouse to be restored at client

I am trying to understand the mechanics of database backup encryptions, but there are some issues, which I can't seem to wrap my head around. I have 2 requirements: I need to be able to create and ...
0
votes
1answer
106 views

How can I restore a backup without overwriting ALL of the tables?

I have a SQL Server database with 3 tables. I need to restore a backup that contains 4 tables, while still keeping the old data in the original 3 tables. Is this possible?
2
votes
1answer
56 views

How to find out the oldest full backup still existing on disk?

one of the things I like to find out is what is the oldest full backup file still living in my servers. it is the custom to delete or move those files to a different place after a number of days. How ...
1
vote
1answer
91 views

Database file location change on standby site after restore standby database

I am configuring Log shipping from SQL Server 2008R2 to 2016 using NORECOVERY option with Log Shopping jobs. I have successfully configured Backup, Copy and Restore jobs. When I perform a restore on ...
2
votes
2answers
93 views

SQL Server mistaken update rows without backup

I did a mistake UPDATE query yesterday. Database engine is MSSQL and the version is 2017. I have not any backups. All I have is the database itself. Do you know any ways to redo my modifications to ...
1
vote
1answer
118 views

Any correct procedure for couchbase backup and restore?

I have just started using couchbase server and trying to configure backup and restore method. We require to take backup for each couchbase node or cluster backup also available ?
0
votes
1answer
333 views

Migrate complete postgres database cluster to another machine using pg_dump

I am referring to How to get a working and complete PostgreSQL DB backup and test In this example/solution, which part of the restore process does actually the "CREATE DATABASE sandbox"? I have been ...