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
15 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
23 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
43 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
47 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
58 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
6 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
76 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
172 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
42 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
31 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
42 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
54 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
35 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
42 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
84 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
31 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
35 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
62 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
197 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 ...
2
votes
3answers
224 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
158 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
74 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
33 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
22 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
69 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
80 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 ...
2
votes
2answers
39 views
When is the modify_date of an object updated?
As part of the daily checks I'm setting up, I'm restoring the nightly full backups to our test server and checking the modified date of objects. This is not for any kind of precise change tracking or ...
0
votes
1answer
231 views
How to repair corrupted PostgreSQL pg_toast error
The hard drive on my PostgreSQL 9.5 server died, but I managed to recover most of the data. I've restored the database to a solid state hard drive, and I can access most of the data. However, when I ...
2
votes
2answers
302 views
Restoring database with less data than the backup file
I'm not really experienced with DBA and SQL, so I need some recommendations from you.
I have a production database backup file, however it is very large, so when I'm executing restore, for example, ...
2
votes
2answers
60 views
Does MSSQL log shipping automatically remove the backup files from both servers?
Does Microsoft SQL Server's log shipping feature remove the backup files automatically? I am concerned that the secondary server's hard drive will reach capacity unless the previously restored files ...
0
votes
4answers
58 views
Creating a database from a backup file
I have a peculiar issue on my hands. I have a few databases in my SSMS already (2014), and when creating a new database and performing a restore from a file that has never been used, it sets my main ...
1
vote
1answer
46 views
how to find out the log backups that I need to restore in order to bring log shipping from standby to online?
I have log shipping set up from server1 to server2.
on server1 transaction logs backups are taken every 15 min to a network share folder.
these transaction log backups are then copied (afte 1 hour) ...
0
votes
1answer
39 views
Server version error where restoring backup with SQL Server Management Studio
I have SSMS v17.9.1 freshly installed. I believe the only later versions as of this post's date and time are only preview versions.
I am attempting to restore a .bak file. I get the error that: The ...
0
votes
2answers
54 views
Cannot restore postgres dump file
When i try to restore a database from a dump file using the following command:
\i C:/pathname/dumpfile.txt
from within my sql shell, it runs the first few lines of the dump file and then I get the ...
1
vote
2answers
49 views
Restore a single database backup (.bak) file into multiple filegroups
I have a SQL Server 2014 database DB01 (single filegroup - PRIMARY) and I took a backup of it into a DB01.bak file in SSMS.
I have another database DB02 with 1 primary filegroup (1 file) and one ...
0
votes
1answer
156 views
sp_DatabaseRestore msg 50000
I used Ola's script to backup my database (SQL Server 2017) and now I'm trying to restore it using Brent's sp_DatabaseRestore. Currently trying to do a Full restore only. Here is my code, written ...
1
vote
0answers
102 views
DB Restore Agent Job Fails After “..running the upgrade from version 695 to version 696.”
Recently I have started to see an intermittent error when trying to restore database 'X' via an agent job. The job runs a T-SQL script that restores a database from a 2008 R2 (production) instance to ...
0
votes
1answer
32 views
How do you restore to a point in time between the last log backup before a full backup and the full backup?
Imagine the following timeline:
T0 = full backup
T1 = log backup
T2 = log backup
T3 = log backup
T4 = full backup
T5 = log backup
After all the above have transpired, if you still have all the ...
0
votes
0answers
63 views
Microsoft SQL page level restore, no valid backup. Confirming process
We have a database in production that is coming up with issues after running DBCC CHECKDB. This particular DB was moved from a development environment to production. During this time, for some reason ...
0
votes
1answer
153 views
How to create SQL Agent job to automatically restore a database from latest backups?
There are 3 different folders which store respectively full, differential, and log backups. Different types of backups occur in different schedules. Now I need to create a new job which will ...
2
votes
1answer
42 views
If the DBAs restored a single table from backup, would there be evidence anywhere in the data dictionary?
In Oracle 12.1, if the DBAs restored a single table from backup, would there be evidence anywhere in the data dictionary? If so, what would it be?
0
votes
0answers
99 views
What steps can I take to recover MySQL InnoDB databases when forced recovery fails?
Coming here from StackOverflow because I saw a similar question being closed as off-topic on there.
I have corrupted my local MySQL instance in my development environment.
I was running a set of ...
0
votes
0answers
28 views
point in time recovery not working with blackhole engine tables involved
The basic problem summary:
I am trying to do a point in time recovery on a specific table. To speed things up I made every other table use the blackhole engine. Unfortunately this runs into errors ...
1
vote
1answer
53 views
SQL Log shipping - Very Slow restore
I have SQL Server 2012 SP4, ten databases and log shipping.
One database 2.7TB
Ten data files and two log files
Log shipping configuration:
Transaction log backup job : 3 Min
Copy job : 1 Min
...
1
vote
2answers
448 views
what is the penalty for NOT setting Disconnect users in the database when restoring backups?
setting up Log shipping between 2 sql server 2016 servers
I want my databases read-only standby on the secondary server.
there is a tick box saying Disconnect users in the database when restoring ...
1
vote
2answers
55 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
3answers
61 views
How to choose which backup files to restore when identical timestamps exist for diff and log backups
I can see from an earlier question that log file backup may be performed simultaneously with either full or differential data file backups.
Imagine for a moment that full backups run during a window ...
7
votes
2answers
118 views
Accidental DBA: Unsure why I have a broken log chain?
First of all, thanks for having a look at this - We've got a large database in our production environment (1.26 TB), it's got a few hundred corrupt pages in it and has done for months, so the same ...
