Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [restore]

Reloading a database from a backup, typically for disaster recovery, or to make a copy of a database onto another server.

Filter by
Sorted by
Tagged with
0
votes
2answers
230 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
213 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
42 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
426 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
806 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
270 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
45 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
172 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
152 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
82 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
890 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
308 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
129 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
65 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
62 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
54 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
166 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
81 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
508 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
251 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
40 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
71 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
762 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
44 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
259 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
45 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
203 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
716 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
171 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
73 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
136 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
1k 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
742 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
57 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
52 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
35 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
130 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
227 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
1answer
522 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
46 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
116 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
155 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
74 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
135 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
365 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
57 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
215 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
185 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
50 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 ...