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

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

3
votes
1answer
79 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
58 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
89 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
33 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
38 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
1answer
40 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
55 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 ...
0
votes
0answers
40 views

Database swapping

I have a scenario to switch(Swap the databases) in my production databases after every ETL processing. DB size is approximately 300GB. The reason behind this is the main tables in the db we are ...
1
vote
0answers
19 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
38 views

Identity value in a restored database is different from the value in the backed up database

I am replicating (using backup instead of snapshot) from 2008r2 to 2016 and it seems to be working fine except for a few tables where the restored table identity value is less than the backed up id ...
0
votes
0answers
22 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
52 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 ...
0
votes
0answers
22 views

How to change version of .mdf file to lower version [duplicate]

I have SQL Server database file with .mdf extension. which I created on visual Web Developer 2015 then now I am using Visual Studio 2010 and I attached that .mdf file (which was created in Visual Web ...
1
vote
2answers
203 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
36 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 ...
0
votes
0answers
10 views

Copy Postgres database from DEV to PROD on Amazon RDS using pgAdminIII

I am running pgAdminIII on Windows 10 and trying to copy my PostgreSQL database to production. I am able to Backup to a file. I am also able to connect to the PROD server on Amazon RDS and make ...
1
vote
1answer
87 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
56 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 ...
0
votes
1answer
26 views

SSMS Restore Database Wizard questions while restoring to different destination

I need to pull some data from an earlier backup of a current prod database, so I'm using the SSMS Restore Wizard to run a point in time restore and put it into a temporary restore database (for ...
-1
votes
1answer
24 views

Restoring AdventureWorks2014 Database to SQL Server 2017

I restored AdventureWorks2014 database from SQL Server 2014 to SQL Server 2017. (I restored it twice, I changed the name on the 2nd restore, of course) It works fine. Now I tried to change the ...
0
votes
0answers
15 views

postgres 9.6 restoring a server in an other one

I made a pg_dumpall of a 9.6 postgres server in order to restore it (for the first time) completely on another computer. On this second computer, postgres 9.6 is also installed with old versions of ...
1
vote
1answer
79 views

Restoring development database from production backup triggered production database to restore as well

We backed up our production database to restore our development database. When we restored our development database from the backup it triggered the production database to restore as well. The ...
1
vote
0answers
34 views

Switch-SQLAvailability error during DB Restore in AlwaysON Group

Can anyone share your inputs on below and how to fix the issue and possible causes of failure? I am trying to restore a DB using PS script and at one step it is failing during the role change test ...
0
votes
0answers
54 views

Users are missing in Database restored from .bacpac file

I am creating a new database from a reference .bacpac db file but the issue is that in the new Database, users are corrupted and I cannot login through any of the database users that were there ...
1
vote
2answers
73 views

Repair/Recover data from MySQL database

I have a big problem with a MySQL database stored on my raspberry (InnoDB engine). I'm not very expert in this field but I'll try to explain to you the problem. MySQL crash everytime that I try to ...
2
votes
1answer
454 views

The backup or restore was aborted - what could it be?

use master go ALTER DATABASE Apcore SET SINGLE_USER WITH ROLLBACK IMMEDIATE RESTORE DATABASE Apcore FROM DISK=N'C:\Backups\QG-V-SQL-TS$AIFS_DEVELOPMENT_APCore_FULL_20180909_230034.bak' WITH FILE = ...
-1
votes
1answer
36 views

DB2 rollforward fails

I get the following error when I try to do a point in time recovery [inst20@localhost ~]$ db2 rollforward database sample2 to 2018-09-01-15.16.00 and stop SQL4970N Rollforward recovery stopped ...
0
votes
1answer
39 views

SQL server tool - backup & restore to different servers different locations

I need to back up 100s of databases and restore them to 20 different servers, and different data file locations for destination servers. Are there any tool that allows me to copy 1 database/all ...
1
vote
0answers
22 views

Oracle Database Recovery [closed]

I recently develop an app using Oracle Application Express on a Windows OS, after uploading lots of data. Unfortunately for me the OS field before I could make any backup but, I salvage the data files ...
0
votes
1answer
32 views

TSQL retrieve backup date from database after restore

Usecase: MSSQL Database is hosted in the cloud, I download the database thrue FTP and restore it on-premise automatically for reporting. Now I want to retrieve the date/time when the backup was made, ...
1
vote
0answers
44 views

Error when restore database using dialog - SQL Server 2016

I'm trying to restore backups for a DB, but every time I select the files, like this: As soon as I click on "Options" or on "Script" (not even to execute the actual restore!), I get the following ...
0
votes
1answer
32 views

Mongo doesn't restore user password

I have following scenario: Dump Mongo database (cmd mongodump) Change password from one of admin users Restore Mongo database (cmd mongorestore) EDIT: I use following command for db dump: ...
1
vote
1answer
53 views

Does SQL Server allow moving backwards with standby file?

I have a database in standby mode. -- STEP 1 -- Restore path F1 > T7 RESTORE DATABASE [TestRestore] FROM DISK = N'C:\Temp\F1.BAK' WITH FILE = 1, NORECOVERY, NOUNLOAD, REPLACE, STATS = 5 GO -- ...
1
vote
2answers
94 views

How to get to know that db files are inaccessible?

Let me explain my case. I have a mount with database files on my local PC. I attach the database (from this mount). And then close this mount (in other word i attach db and then delete db files). So ...
0
votes
1answer
220 views

Mysql Restore - ERROR 1227 (42000) at line 30908: Access denied DEFINER issue

Im trying to restore the database dump which has the DEFINER=test@%. Backup file is 50GB. OS - CentOS 7.5 While restoring this, I got the below error. ERROR 1227 (42000) at line 30908: ...
1
vote
1answer
44 views

Is it possible to restore mongodb after db.dropDatabase() by replacing the contents of folder /data/db with older backup?

In order to reset replication, I did drop the local mongo database using the following commands: use local; db.dropDatabase(); The mongo data directory(dbPath) is /data/db/ I took a backup of this ...
0
votes
1answer
59 views

Restore Log and Differential Backups Simultaneously in MS SQL Server

I have the full backup of a database, also one differential backup and one log backup. Is it possible to restore this 3 backups together? SSMS lets only full backup and only one of them. Is there a ...
0
votes
1answer
45 views

LSN mentioned in Backup is missing in Backupset

I was testing some restore scenario for one of my requirement. SO while i was restoring i got the below error. --Msg 4305, Level 16, State 1, Line 79 --The log in this backup set begins at LSN ...
1
vote
1answer
110 views

During restore restart, an I/O error occurred on checkpoint file

Short version: Running a RESTORE VERIFYONLY throws one of these errors: During restore restart, an I/O error occurred on checkpoint file '\Server\Backup\SQLDirectBackup\DatabaseName\...
-1
votes
2answers
69 views

RESTORE hourly transaction log to every 10 min interval

I have an hourly transaction log backup running for my production database. I have to implement the below scenario to check for a deleted data. I have two tlogs. tlog1.trn at 10 AM tlog2.trn at 11 ...
0
votes
3answers
57 views

Restore deleted data from a Table which occurred daily

I am not sure whether this is restore data scenario is possible. Scenario: I have a table with few 100 data inserts every day.I didn't realize that because of some reason(identified later as a bug in ...
0
votes
0answers
28 views

MySQL8 Restore from Physical Files - Innodb

I recently had one of my VM's go down (MS Server 2016) and the only version I am able to get up and running is two weeks old. However, I do have a backup of my C:/ drive from last night that has my C:/...
2
votes
2answers
117 views

How to restore a file group from file group backup?

I want to restore a specific file group from file group backup. I found examples how to restore it from full backup, but I want to do it from file group backup. Every time when I try, all of the files ...
0
votes
1answer
311 views

Upload multiple csv file to multiple tables sqlServer

I have over than 200 csv files that each of them is diffrent table. I create now a new DB and want to upload them all so I will have all the table. I not accessable to old DB to backup in diffrent ...
2
votes
2answers
92 views

sqlserver RESTORE missing views

I amb trying to do a full database backup from one server to restore into another one, this is the backup script (creating a dated name for the backup). declare @DB sysname declare @DISK sysname SET @...
0
votes
1answer
125 views

Restoring to modified database

If i restore a DB to a DB that has beed modified vill it work? In case the modification and the backup could be compatible like if a new table has been added without required connections to it, or an ...
1
vote
0answers
38 views

SQLServer Linux: Error restoring backup of DB from Windows w/ full-text data file

I'm trying to move a Windows SQL Server database from Windows 10 to Linux. For this, I'm following the instructions in https://docs.microsoft.com/es-es/sql/linux/sql-server-linux-migrate-restore-...
0
votes
1answer
24 views

SQLServer Linux: Restore full database / Catalog

UPDATE: I continue with the same error, but, with the comments, I have done some progress: - Initially, the full text search feature was not in my installation. I installed with https://docs.microsoft....