Questions tagged [restore]
Reloading a database from a backup, typically for disaster recovery, or to make a copy of a database onto another server.
1
vote
1answer
38 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
83 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
9 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
20 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
60 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
192 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
203 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
45 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
57 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
20 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
32 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
63 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
37 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
79 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
301 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
57 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
55 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
37 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
10 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
30 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
44 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
87 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
55 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
62 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
66 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
44 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
22 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
44 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
402 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
42 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
58 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
115 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
113 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
133 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
50 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
22 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
31 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
49 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
83 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
43 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
142 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
62 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
92 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
96 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 ...
