restore's questions - English 1answer

960 restore questions.

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

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

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

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

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

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

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

I have a 300 GB mysql database which i want to migrate to another server in order to setup Master-Master replication between the two and my main aim is to achieve this with least possible downtime. ...

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

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 have a fairly large (~240GB) Mongo database that I need to transfer across a sluggish network and onto a new server. Traditionally for these situations, I've found that a mongodump followed by a ...

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

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

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

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

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

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

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

Restoring a single table on the server is very slow From Fri Jul 22 13:54:48 CEST 2016 to Fri Jul 22 14:17:41 CEST 2016 Server 2016-07-22 13:55:11 CEST [88719-1] tester@test LOG: duration: 22988.122 ...

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

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

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

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

I am writing a set of procedures for (partially) automating DB deployment for a customer, which mostly works fine, but sometimes a RESTORE command is failing with the OS error 32, about a file being ...

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

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

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

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

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

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

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

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

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

Yesterday, I created backups of my various PostgreSQL databases using the following command: pg_dump -Fc -d junk -h localhost -p 5434 -U postgres -W > z:\pg_dump\96_junk.dump I created an ...

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

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

I have written a powershell script that uses Start-AzureSqlDatabaseExport & Get-AzureStorageBlob to export my Azure DB to a bacpac and download it locally, the next step is to restore the bacpac ...

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

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

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

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

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

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

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

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

Related tags

Hot questions

Language

Popular Tags