Questions tagged [restore]
Reloading a database from a backup, typically for disaster recovery, or to make a copy of a database onto another server.
0
votes
0answers
4 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
865 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
26 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
18 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
8 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
22 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
12 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
25 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
25 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
40 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
40 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
21 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
39 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 ...
0
votes
1answer
45 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
23 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
56 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
137 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
34 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
63 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 ...
2
votes
0answers
89 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
83 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
35 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
29 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
47 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
136 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
48 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
63 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
38 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 ...
0
votes
0answers
7 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
198 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
192 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
51 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
45 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
65 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
40 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
47 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
85 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
42 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
110 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 ...
0
votes
2answers
73 views
Restoring more than one .bak files in a TSQL query
Can any one share a script that will allow me to restore all the .bak files in my one folder into SQL Server using a TSQL script?
4
votes
1answer
201 views
SQL Server: are backups between same major/minor version but different build compatible among them?
For example a backup executed on SQL Server 10.50.6000.34 can always be restored on SQL Server 10.50.4000.0 or 10.50.2500.0. All of them indicates an SQL Server 2008 R2 (10.50.xxxx.xx) but different ...
0
votes
1answer
40 views
Lost data after restore
I had an issue after backing up and restoring the DB's from server to server, We have since had some issues with missing information. Is there a way at this point in time to know if the databases ...
2
votes
3answers
265 views
Transaction deadlock during restore
I am working on PS script to restore database backups and I have following SQL script that I am running from PS Invoke-SQLcmd command:
USE master
GO
ALTER DATABASE mydatabase SET SINGLE_USER WITH ...
1
vote
2answers
332 views
How to restore Postgresql without pg_control but with file system backup and wal files?
OS: Ubuntu 16.04, Docker
Postgresql: 10
I'm using an alternative file-system backup that is making “consistent snapshot” of the data directory every 24 hours. I'm experiencing the warning from the ...
0
votes
2answers
125 views
Always On - Restore a node from a Veeam backup
I have a cluster with 2 nodes, and Veeam is backing up databases every day and logs every 5 minutes. This works great and I can easily recover a single database to any point in time.
Then I was ...
0
votes
1answer
35 views
Database Restoration Issue Msg 3156, Level 16, State 6
Recently while restoring a database with memory optimized filegroup I start facing an issue with below error message:-
Msg 3156, Level 16, State 3, Line 2 File 'XYZ' cannot be restored to
'D:\...
0
votes
0answers
27 views
Proper way to fully backup and restore a database including indexes in a low-resource shared web host with ssh access?
I'm rather new to database management and I would like some advice on better practices by using the following experience as an example.
Every time I update php software I do a quick export from ...
0
votes
0answers
100 views
MariaDB 10.2 crash on innodb table corruption - trying to restore the database
I'm running MariaDB 10.2 on Windows and had some hard drive corruption on my server that messed up some innodb tables. Unfortunately this also affected backups, so I'm trying to dump the tables and ...
3
votes
1answer
104 views
Attach ldf more current than mdf
Is it possible to create a database where the ldf is more current then the mdf? Or to attach the older (more mature) ldf to the younger mdf (less mature)?
I am working on Steve Stedman's Week 3 ...
