We’re rewarding the question askers & reputations are being recalculated! Read more.

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
1answer
1k views

MariaDB: point in time backup recovery with binary log using position

Following the below sequence of commands i expected the recovery of backup and subsequent point in time recovery using binary log. However, the database was restored to backup only: 1) CREATE TABLE ...
0
votes
1answer
237 views

SQL Server 2016 Database Backup and Restore

Is there any different approach to restore a SQL Database backup having memory optimized tables as we know that there's additional filegroup present for holding In-Memory data. The restore command ...
3
votes
1answer
208 views

Automating DB Restore from network share

We have a network share that uses different credentials from the currently logged in user. Inside this share we have full, differential and log backups that come through from a third party database ...
3
votes
1answer
417 views

SQL Server 2016 Restore Failure on DB Using Clustered Shared Volumes (Error 7627)

We are new to using clustered shared volumes and SQL Server 2016 Enterprise Edition. When restoring SQL Server 2005 databases with full text search catalogs onto our new 2016 instance, we get the ...
14
votes
2answers
3k views

10 TB database backup / restore Question

We have a very big production database which is 10 TB. We are considering migrating it to a cloud service, but I have to understand the risks and estimate the duration of the whole process. I backup ...
2
votes
1answer
37 views

Automate SQL Server install and restore DB

I’ve been tasked to automate our sql server express installation and with that, create a database from a .bak file. I found a way to automate the install using a Configuration.ini file which works ...
0
votes
1answer
63 views

Mongodb restore “local” db

I need to restore a replica set. Unfortunately my lack of experience as administrator (I'm not) let me with the only solution of restore the replica using the data of the primary db (the only replica ...
1
vote
1answer
110 views

Does a backup include dropped, hidden columns still in a table's physical structure?

If I have a table with an NVARCHAR(MAX) column and I drop it, the standard way to reclaim the space it used is to either: Rebuild the clustered index or Run DBCC CLEANTABLE If I didn't perform ...
1
vote
1answer
350 views

Restore Latest Copy of Full and Differential database From Azure Blob Container

I'm trying to work out how to Restore the Latest Backup of a Database that is held on Azure Storage Blobs. This container contains other backups from different databases on a server but I'm only ...
2
votes
3answers
819 views

Is Database Backup Time = Restore Time in SQL Server?

I have a SQL Server Database with 10 GB size. When I performed a backup, it took almost 3-4 minutes. When I tried to restore, it took almost the same 3-4 minutes. Does this mean backup and restore ...
3
votes
0answers
68 views

database restore with filestream on Windows Server 2016 renames data file

I have a database in SQL Server 2008 R2 sp2 that has filestream enabled. Restore of the database on a Win10 machine works as it should. However, on Windows Server 2016, the data directory (file) for ...
0
votes
1answer
920 views

delete tables on import of dump created by mysqldump

There are 2 copies of the same database on 2 different storages which need to be in sync. For example, database named test_db contains tables T1,T2,T3 tables. T2,T3 are deleted. Dump of the 1st copy ...
0
votes
1answer
151 views

RMAN restore error;. expected sequence# 211287 doesn't match 211311 during recover

Oracle version = Oracle 8i (817_312) //Yes I know this is old. Database id = LED OS = Solaris 8 Oracle USERID = oraled Oracle DBA group = dba I an mot a DBA, but a UNIX/Linux System Administrator ...
0
votes
2answers
78 views

Multiple DB restore in sequence

I am restoring several MariaDB databases into a Amazon AWS RDS MariaDB instance from an AWS EC2 machine in the same VPC / region etc. I am using a shell script like so: mysql -u root -h hostname....
1
vote
1answer
608 views

requested recovery stop point is before consistent recovery point

I am getting below error while restoring Postgres instance to a point in time. FATAL: requested recovery stop point is before consistent recovery point below is my recovery.conf content ...
1
vote
1answer
88 views

SQL Server Diff not restoring from Azure BLOB storage

I'm setting up a process to back up a SQL Server 2016 database to Azure blob storage and subsequently restore to another server. I'm doing a weekly full back up and hourly differential. The issue I'm ...
0
votes
1answer
99 views

Can we reconstruct/reset a broken Postgresql data directory without losing data? [closed]

I'm trying to restore a database from a broken data directory that have lost many of its files accidentally. I have tried unsuccessfully to install new instance of the same Postgresql version and ...
1
vote
2answers
469 views

Database Stuck in “Restoring” in SSMS After Running From an Outside Process

I am running a RESTORE DATABASE procedure with RECOVERY and REPLACE from an outside process (Windows Batch using a Python script) and when I do so, it makes my database stuck in "Restoring..." mode ...
0
votes
2answers
231 views

Backup Files with Append option growing huge Vs Better Options

We have close to 5 Databases . Below are the .mdf and .ldf sizes . NOTE : Along with this we do also have the FileStream enabled for these Databases . Kindly suggest me on below : As of now we are ...
0
votes
1answer
70 views

Double Concurrent Restore from one backup for 3 node AG?

I have a 400GB database on SQL 2014 Enterprise Edition Instance. I took a full backup as a single file (not striped), it restores to 8 datafiles and 1 log file. I put the backup in a shared folder ...
0
votes
1answer
68 views

Long delay before redirected restore “starts”

On several occasions, I noticed that it takes a long time before anything "happens" during a redirected restore. There are no entries in db2diag.log and list utilities show detailshows: Completed ...
2
votes
1answer
1k views

Can I read a .bak file without restoring it?

A few years ago I had used a 3rd party product to read a full backup file and open it in SSMS just as if it was online. The .bak could be queried like any online database. I need to do that again, but ...
2
votes
1answer
3k views

unable to start the standby postgres database

Situation I have 2 separate instances. Both running on Ubuntu 14.04 server. Both have installed postgres 9.5 the following way: sudo apt-get install software-properties-common python-software-...
0
votes
1answer
198 views

Impact of shrinking ldf file after restoring full backup

What is the use of data in .ldf(log) file after restoring a full backup. I am planning to shrink the log files after restoring the full backup in my dev server. Is there any side effect for this ?
0
votes
2answers
864 views

Cloning the database to another server with raw data files

I'm trying to clone the database of server 1 to server 2 with raw data files. I'm using Linux 7 and Oracle 11g R2. I have the instance running with same SID in Server 2 but file structure is different....
1
vote
1answer
300 views

FileStream Db restore

Microsoft SQL Server 2016 (SP1-CU6) (KB4037354) - 13.0.4457.0 (X64) The database's total size is 450 GB, from which 350GB is inital filestream size The average picture size is around 200Kb, the ...
2
votes
1answer
94 views

defragment SQL server database

I have deleted some tables on a SQL server. Suddenly the size of the database jumped by 100Gb (whereas the deleted tables were taking 10% of that..). I have read good and bad things about SHRINK ...
1
vote
0answers
135 views

MySql could not restore whole dump file

MySql cluster is unable to restore whole dump file. Error: MaxNoOfConcurrentOperations and increase MaxNoOfAttributes This is the command I tried: mysql -u username -p create database ...
0
votes
1answer
521 views

Restoring dump(backup): ERROR 1022 (23000) at line 44: Can't write; duplicate key in table

I'm doing tests to change a current table from my InnoDB database to Archive, but I had a problem trying to restore a dump after the change. After several tests, the problem is related to the value ...
0
votes
1answer
111 views

Innodb switch innodb_file_per_table to OFF

I want to switch off the inno variable: innodb_file_per_table I found that this affects only new tables, how to apply this change also to old tables? I tried: Alter table (ALTER TABLE xxx ENGINES=...
0
votes
0answers
86 views

MariaDB restore InnoDB db from file system files

How can I restore a InnoDB database from filesystem files (FRM/IBD)? I cannot run db service from that system, so I tought to move its file to another Windows machine but I don't know if is there any ...
0
votes
1answer
408 views

Cannot recover Database from ibdata file

My Server recently had a Kernel-Panic and I downloaded all the mysql data using the rescue mode. Now when I upload the ibdata1 file and table folders to a local XAMPP Server and click on a table to ...
0
votes
0answers
45 views

SQL Server - Partial Backup

I want to check if my Data Warehouse historical filegroup backups are valid with my most recent Primary Filegroup backup. I backup the Primary Filegroup every night but historical filegroup backups ...
0
votes
1answer
64 views

Move local SQL Server DB to hosted SQL Server

I have a SQL Server database here that contains the info for the Gemini Issue Tracking software. It is running on a Windows XP system and I have SQL Server Management Studio (SSMS) on that system. I ...
2
votes
2answers
50 views

Move very large DB from single to multple drives with not a lot of space

I have to restore a SQL database that is just over 5 TB; it is going from a single drive that is 7 TB, to another server that has split drives C:\ 4 TB and D:\ 3 TB and also has E:\Bak which is only ...
1
vote
1answer
418 views

Cannot restore database because of stuck rollback

When I try to restore my database with RESTORE DATABASE MyDatabase FROM DISK = '\path\to\my\backup.bak' WITH REPLACE, RECOVERY It says Exclusive access could not be obtained because the database ...
0
votes
1answer
51 views

Simple way to Drop Test databases and restore from Prod databases on 2008r2

I have a production database instance on a production server and a test database instance on a test server. I need to restore the production databases to the test instance daily. What I need: LOOP ...
1
vote
2answers
10k views

mongodb restore multiple collections with single command

How do I restore multiple collections at once in mongodb. I have tried mongorestore -c Role -c UserAccount -c Permission -d movie-app dump/ and I got an error file dump is a directory, not a bson ...
3
votes
1answer
104 views

restore log slow after In-Memory OLTP

The issue I have is that once you set a database to support in-memory OLTP tables the time to execute a "restore log" increases significantly; about 100 times slower. I tested, I thought prudently, ...
1
vote
1answer
3k views

ORA-01196: file 1 is inconsistent due to a failed media recovery session [closed]

I have 3 database 1 primary and two standby, The storage of one the standby was abruptly removed without shutting down the database. Few Days later the storage was returned, I restart the whole ...
3
votes
2answers
3k views

SQL Server - backup restore - lose indexes?

It looks like at a client site, after a database backup and restore (from SQL Server 2008 to SQL Server 2012), it looks like they have lost indexes from the tables and we had to manually create them. ...
2
votes
1answer
204 views

Transaction log restore hourly

Is it possible to restore SQL Transaction Logs to a MS SQL database every hour without having to restore the full backup first? Can you set database to No Recovery, apply transaction Logs, then set ...
0
votes
2answers
46 views

Restore user in DataBase that in master have mapped the child database but in child database doesn't have the user created

I don't know why te following database arrive to this point but this is the situation In master security you can see the defcon\axadmin user with DAXTest database mapped But if you go to the ...
9
votes
1answer
15k views

SQL Server error “Missing family sequence number 2”

I'm trying to restore a local database on my server, but I'm having problems with the backup. I did a file .bak but every time I try to load it on the server it doesn't let me. Here's a screenshot of ...
1
vote
1answer
54 views

MySQL - Order of Table Load From Backup

I need to load a database backup from some months ago.There are 29 tables backed up as individual.sql files. Is the order I load them important? For instance the ClientSupplementary table has a FK ...
0
votes
1answer
147 views

Create a New AWS RDS Instance of only one database from a snapshot

I'm trying to Create a new AWS RDS SQL Server instance of only one database from a snapshot. I've gone through the AWS documentation, but according to it when I restore from a snapshot it will create ...
0
votes
3answers
178 views

The mapped logins are removed when database is restored

Whenever I restore a database all my logins associated with that database are removed. How can I avoid this ?
2
votes
2answers
9k views

Single user mode while restoring database

Is it necessary to put the database into single user mode before restoring a database? If so which one is more preferable putting the sql server into single user mode or putting the database only into ...
4
votes
2answers
2k views

what would be the right permission to allow everything else but overwriting or creating a database?

I have a test environment where the AD group mycompany\developers is currently sysadmin. Recently I have had some issues, specially regarding to people restoring databases. My concerns are: ...
0
votes
1answer
71 views

Unistalled MySQL 5.6 and installed MySQL 5.7 - Restore Database and Tables

All of the data resides in "C:\ProgramData\MySQL\MySQL Server 5.6\data". There are 46 folders inside of this folder. There is one folder for every old database I had. For example the first three ...