restore's questions - English 1answer

924 restore questions.

I took a backups of a few db's on server A (2008R2), Then restored it to server B (2012). One database had TDE enable, so I disabled it, took a back up then proceeded to server B. The other database, ...

I've been tasked to try to recover a database which suffered from corruption (due to I/O failure, which has been fixed since). I'm not familiar with the database or what it contains. I've been given ...

Follow-up question from: Have postgres' pg_dump export an index Say I have an existing database, and I want to add to it another schema with content. I saved that content previously through a ...

I'm wondering if anybody has ran into this issue before and has any suggestions on what's causing it/how to fix it. We are restoring a database into lower Dev environments and after the restore the ...

My machine (OSX) had a power failure and when restarted, I have one db in MongoDB that is completely unrecoverable. I am using the db per directory with dbpath and logpath specified options and was ...

I'm running MongoDB 2.6 on Ubuntu 14.04 and I accidentally deleted db file in /var/lib/mongodb. I cannot restart the MongoDB instance: mongo: error SEVERE: unable to open file number 5. If I ...

I have an index that is very expensive to calculate, and I'm looking for ways to have it be restored or transfered in a simple copy fashion. It would be done along with the underlying data of course. ...

I've just noticed this recently on one of the SQL Server 2012 SP3 instances that I oversee. When I try to restore a database using SSMS 2012 (by right-clicking on the database,and choosing Tasks>...

I want to restore some production azure database on my local machine for development purposes. So I exported the production database to a .bacpack file & downloaded that file on local. Now I am ...

I have a database folder from a crashed server called gain_wordpress. I'm trying to put that database on a new server but I'm not able to do it successfully. I don't have a .sql dump, all I have is ...

I have a 200+GB mysql dump file that I need to import into the local sql server running on my development machine. I attempted a naive dump restore using the mysql < db_backup.sql approach and ...

I am trying to set up database mirroring for 10-15 databases . All these are around 1-2 TB in size. They have multiple groups and hence are scattered on multiple mount points on their primary server. ...

I was in the process of restoring an sql dump to a newly created RDS mysql instance on AWS. The dump was created with the following command: mysqldump --all-databases \ --single-transaction \ --...

I am using pg_dump / pg_restore to backup and restore a PostgreSQL database, but am getting some error messages (and a non-zero exit status) from pg_restore. I tried a super simple base case (outlined ...

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 ...

For some reason we want to restore one of our schema to an old date. We have the old backup which was taken using RMAN. Is there any way to achieve this? I'm new to oracle, but after doing some ...

I have deleted all directory by mistake except from the given link /var/lib/postgresql/9.5/main/base/18686 and so on. I have 4 such directories, now I want to get data back from those folder as they ...

We have damaged disks on the server and partially lost data. Backup of the database was not the most relevant, so it was decided to restore the database from the .myd, .myi, .frm files. Since the ...

Steps I used: mongodump copy dump folder to another computer (for each collection I get .bson and metadata files) mongorestore myDumpFolder I noticed the indexes are lost and _id has new ...

In restoring a database from a pg_dump, a number of errors are being generated and the whole table is subsequently being ignored. An example: ERROR: insert or update on table "channelproducts" ...

I'm using Heroku's Postgres option and have a backup I downloaded from it. I'd like to restore it into a fresh database so I can look at it. I've been trying different commands to little avail. My ...

I was getting problem in starting and login mysql server so I backuped /var/lib/mysql folder and reinstalled mysql server. Now I want to use old database files like: ibdata1 and database folder /var/...

MongoDB version is 2.4.12 Production Server has 3 shards and each shard have another 2 replica sets. Config server & router also runs on these servers. Backup procedure : 1. Shutdown one of ...

In SQL Server 2017, after applying Cumulative Update 7, there's a new system stored procedure in master called sp_restore_filelistonly. What's it for?

I'm attempting to backup a database (full backup, in simple recovery) to Azure storage, replacing a bak file that already exists, then restoring the new backup. Doing a regular backup and restore ...

I have a database DB in simple recovery mode with filegroups PRIMARY, A, B, and C. Each filegroup has a single file, PRIMARY.MDF, A.NDF, B.NDF, and C.NDF, respectively. First, I run: ALTER DATABASE [...

I'm trying to perform a restore of a database from a different server onto my localhost server .That database is encrypted (the bak file ) ,so I have to decrypt it ,that's fine I have all the cert ...

Im trying to restore a databse running on oracle 9i. I manually moved the datafiles and redofiles from existing to new. Generated a controlfile.sql since Imrecreating the controlfile and edited the ...

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 ...

We have created a replica set and now the problem is 2 members of replica set [3 members set] are in recovering mode from 48 hours. Initially the size of recovering nodes was increasing and now even ...

I am using SQL Server 2014 version 12.0.2000.8 on both systems. When I try to restore the backup taken from the first system onto the second system it says: No backup set selected to be restored ...

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 ...

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 ...

I am trying to restore two specific MySQL Tables, both which are over 3GB in size. I have been able to resort all my other tables using the CREATE TABLE SPACE, DISCARD TABLE SPACE etc commands. ...

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 ...

We are having a database without backup to restore. (we didn’t keep backups as client not having enough space in his SQL Server 2012). Unfortunately some data has been lost and we need to recover ...

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 ...

I am not a DBA nor a database guy, we just recieved a database backup, a differential database backup and daily database transaction logs (each day probably has about 15-20 trans logs). I now have ...

So I feel like this is something that should be very basic and easy to do, maybe I'm just not doing things correctly. I want to do the equivalent of SQL Server backups. I want to create the ...

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 ...

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 ...

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 ...

On a dev machine running Windows Server 2012 R2, I just upgraded SQL Server from 2012 to 2014. Using SQL Server Management Studio 2014, when I right-click a database and go to Tasks -> Restore -&...

I have a small shared windows server on which i'have installed MySQL 5.1 engine for hosting my user's mysql databases. I backup the complete MySQL databases each day by running this script as batch ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

Related tags

Hot questions

Language

Popular Tags