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
1answer
27 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
15 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
10 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 ...
2
votes
1answer
52 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
33 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
22 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
295 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
49 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
53 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
44 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
29 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
0answers
9 views
postgresql backup DB restore error
PostgreSQL 10 with PostGIS 2.4 linked to a Django (1.11.18). Currently moving my DB to a remote server and going through the backup and restore process.
Backup Process
PGAdminIII - backing up with ...
0
votes
1answer
25 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
37 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
74 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 ...
0
votes
0answers
34 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
30 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
60 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
42 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
39 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
26 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
20 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
41 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
392 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
37 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
56 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
112 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 ...
0
votes
1answer
50 views
Postgresql - Large object exists in pg_largeobject table but cannot open with lo_open?
I have a problem with opening Large Object in postgresql version 9.2,
select * from pg_largeobject where loid = '19423';
will return data like this:
loid oid;page no integer;data bytea
19423;0;"<...
2
votes
4answers
95 views
.bak file not visible for restoration
There is a database on a server of which I would like a copy on my local machine for testing purposes, so I created a backup in the default disk location (C:\Program Files (x86)\Microsoft SQL Server\...
0
votes
2answers
49 views
Timing issues for backups during recovery
Let's say we did a full database backup of the PRIMARY filegroup at 10:20 am. It finished at 10:45 am. We also took log backups every 5 minutes, hence
10:15, 10:20, 10:25, 10:30, 10:35, 10:40, 10:45,....
0
votes
2answers
37 views
What are the different ways to restore a database?
From the most inoffensive of the cases, to the worst of the scenarios they know. What are the different ways to restore or recover a MySQL database? I refer to the use of full backups and incremental ...
2
votes
1answer
21 views
Recover a broken or damaged database from the transaction file or “journal”
A greeting fellow, I would like to know if in MySQL (I understand that all engines must have), you can recover from damage to the database using some kind of file "journal" transactions, if so, what ...
0
votes
2answers
30 views
Replace some rows in one table with rows of another table
I have two tables and a set of primary key values. I want to replace all rows of the first table whose primary keys are in this set with the corresponding (having the same primary key) rows of the ...
-1
votes
3answers
42 views
Restore master database
I want to restore my master database (.dba ).
I am not able to restore from PowerShell because the backup of the database is taken from a different version of the SQL Server and the PowerShell or cmd ...
2
votes
0answers
46 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
0answers
25 views
Archiving SQL Server data on disk to be pottentially restored
Right now, we are backing up data per table into text/CSV files per month. This works fine for fairly small tables. For bigtables, the text files become so big that the restore process for a month ...
1
vote
0answers
39 views
Restoring from a backup having dynamic file names
I want to restore a backup from a set of multiple files. The file names are generated dynamically. I have to restore the UAT with that backup. I need to schedule a job for this restore.
This is SQL ...
3
votes
1answer
137 views
How do I restore an Oracle file system backup onto a new developer machine?
A server (not mine) has died due motherboard temperature problems and disk controller problems. Given that the company's IT support should have known better, and so on, the company does have a file ...
2
votes
1answer
59 views
SQLServer: Backup a database on a server and restore it on another server
I would like to create a process where everyday or every week I backup a database from my production server and restore it on my staging server for testing purpose.
My first idea was to create a ...
1
vote
1answer
91 views
How to make a distibutable .bak file?
I am trying to restore 2 databases. One is adventureworks database downloaded from msdn(its .bak file), and another one is created by me from one databases from my old server. Both have .bak extension,...
0
votes
1answer
70 views
How to immediately terminate a SPID with a very long rollback time estimated?
I have a script to restore a database from a backup. Prior to the restore command, it has:
set single_user with rollback immediate
The script seemed to be hanging here. I used sp_who2 to find out a ...
1
vote
2answers
43 views
Restore a database by pointing to one or more directories containing backup files and specifying a STOPAT time [duplicate]
I'm working on prepping/testing migration of our ERP and other auxiliary systems to a new database server. This will involve restoring database backups from the old server onto the new one.
For the ...
0
votes
2answers
83 views
How to report stats on restore via sqlcmd?
I've inherited a batch file script that calls sqlcmd with parameters. One of the parameters is the path to a SQL file. That file includes a database restore command. The command in the SQL file ...
0
votes
1answer
75 views
Use sp_DatabaseRestore for restore when database does not exist
I am trying to use sp_DatabaseRestore from the SQL Server First Responder Kit to restore some databases. It works fine if I first restore the database in a normal way using SSMS, but if the database ...
0
votes
0answers
44 views
Restore time on dev servers
We have 4 test environments running SQL Server 2014 Developer edition. Every night, we refresh one of those environments by restoring a SQL Backup file stored on a separate server, so that it's in a ...
1
vote
0answers
47 views
Restoring table structure with mysqlfrm
I'm trying to restore an old MySQL database and its tables by using the .frm and .ibd files.
First I tried restoring the structure by using the following command I found in another post:
mysqlfrm....
0
votes
0answers
39 views
Azure SQL Database finding latest available restore point
From reading books online it is clear that there are two types of retention for Azure SQL Database.
Backups for point-in-time restore
Backups for long-term retention
When it comes to restore there ...
1
vote
0answers
55 views
Log Shipping with minimum synchronization gap
We will have an application that will go live soon. I will be using Log Shipping for Disaster Recovery but I am confused about the Job scheduling. The transaction logs will be taken every 10 minutes ...
1
vote
2answers
217 views
After a full backup, how does system know which transactions to restore from the transaction log backup?
Full backup does not truncate the transaction log file.
Assuming the Following Scenario
Full backup at 6AM
TLog backup at 10AM
Full backup at 1PM
TLog backup at 6PM
Crash immediately at the next ...
0
votes
2answers
37 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 ...
