Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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
5 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
48 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
42 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
28 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
71 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
59 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
21 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
391 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
36 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
46 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
92 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\...
-1
votes
0answers
21 views

mysql aborts during restore

Windows 10 Pro mysql 5.7.23 Win64 (all servers) Python 3.6.6 Aim: Kind of master-slave replication system using python script. Only master is enabled to create binlog file. Slave part is managed ...
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
42 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
38 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 ...
-1
votes
0answers
206 views

Please help, lost data SQL server [duplicate]

I accidentally dropped several tables from a database on sql server with a command from laravel artisan (php artisan migrate:fresh), there is no recent backup but there is a log. Can I recover the ...
3
votes
1answer
136 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
67 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
73 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
40 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
43 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 ...
1
vote
1answer
48 views

Under what conditions could restore of a huge database get delayed, in SQL server 2016, hosted on VM?

I have system where my database gets restored every night, and off late the restore is taking a lot longer from past few days. Here is server config: ES 2637 XEON @ 3.5 Ghz Windows virtual server ...
1
vote
1answer
150 views

How to do per-tenant backups for multi-tenant databases?

Are there any best practices, experiences or guidelines when it comes to do per-tenant backups/restores in a microservice multi-tenant application? In my case I have multiple Postgres servers which ...
0
votes
1answer
192 views

Recovering MySQL 5.7 tables in MariaDB 10

I did a very foolish thing... I did not realize installing mariaDB would uninstall MYSQL 5.7 using apt-get. (Using Ubuntu 16.04). So now I am trying to recover my data. So far, I have read many ...