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

learn more… | top users | synonyms (2)

1
vote
0answers
48 views

riak is not so good in case of sudden poweoffs [on hold]

Can you suggest stable NoSQL database, where i can put binary files by key and get it. We tried riak , but when sudden poweroff appear, it suddenly becomes inconsistent and all system goes down ...
1
vote
0answers
11 views

Why restore a single node of a cluster?

We were reviewing the restore documentation for Cassandra here, and noted it made the following distinction between restoring a single node or an entire cluster: If restoring a single node, you ...
0
votes
1answer
31 views

Postgres very slow on server

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 ...
2
votes
2answers
39 views

Restore Database from Database with Different Name

I have 2 databases, DB1 and DB2. DB1 has production/live data. A script runs daily (takes about 3 hours) to fill DB2. The goal is to restore DB1 with DB2 so that DB1 is down for as little time as ...
0
votes
1answer
23 views

Create a MySQL Database using a MS SQL database dump (.CSV)

I have a dump of a MS SQL database in the form of CSV files for every table in the database. There are 679 .csv files each for every table. The highest size of the table extract is 9 GB and the lowest ...
0
votes
0answers
12 views

how to transform binlog row statement into SQL statement?

I know the conventional way to recovery, but I want to transform binlog row statement into SQL statement, is it possible +----+--------+-------+ | id | name | score | +----+--------+-------+ | 1 | ...
2
votes
0answers
27 views

Is it possible to deny RESTORE permissions to login with db_owner role membership?

Is it possible to deny RESTORE permissions to login with db_owner role membership? Is dbcreator required to RESTORE over an existing DB with a BACKUP of that DB? Or is that only needed when creating a ...
0
votes
1answer
25 views

How to change “Initial File Size” before restoring

I have backup of size 10GB. When I restore DB on server it will take around 100GB due to initial file size set to 100GB. I could change it and shrink to around 14GB. Now I want to restore db on my ...
0
votes
2answers
22 views

PITR restore in postgresql

I need to perform incremental backups and restore those backups in postgresql. So in order to achieve this i setup wal-archiving as follows. wal_level = archive archive_mode = on archive_command = ...
2
votes
0answers
34 views

Restoring a database with just .idb and .frm files

I've never attempted something like this before. We had a WAMP installation with WordPress running on my wife's PC, and the Aestan tray menu failed. I figured we need to uninstall and re-install WAMP, ...
0
votes
1answer
46 views

Restore of database failed .bak file SQL Server 2008

I have faced following error during restoring database: TITLE: Microsoft SQL Server Management Studio Restore failed for Server (Microsoft.SqlServer.SmoExtended) ADDITIONAL INFORMATION: ...
0
votes
1answer
24 views

Necessity of backing up tail log when restoring transaction log?

I have a question about whether or not it is necessary to back the tail log up when performing a restore of a database in Full Recovery mode. I've sprawled for a good while now, and have gotten ...
1
vote
0answers
44 views

SQL Server 2012 database stuck restoring

I'm trying to restore my development database DEV with a backup of my production database PROD. Every time I go through this process, the DEV database gets stuck in a Restoring state. Using the SQL "...
3
votes
2answers
58 views

Applying Transaction Logs to an existing Database

I am wondering if this possible, I can not seem to apply another transaction log. I have restored the Full database backup, the differential backup and my last Transaction Log WITH RECOVERY. If later ...
-1
votes
1answer
52 views

RESTORE DATABASE execution continues restore completed

Today, I faced a strange problem which didn't cause any error or downtime. I executed a query to restore a database. RESTORE DATABASE Database_Name FROM DISK='PATH\FILE1.BAK', ...
0
votes
1answer
61 views

How to do 10 G Database recovery without archive logs but available redo logs, ctl files and .dbf files

My client's Oracle 10g database crashed abruptly on Win 2003 NT. The oracle was installed on C drive and redo logs, ctl files and .dbf files were in D: It was unable to backup C: but successfully ...
0
votes
0answers
16 views

Restoring a backup of 1 database to another puts both databases into Restoring mode

We have a 2 databases- Staging Test At times, we refresh out Test environment with a copy of Staging. We do this by taking a full backup of the Staging database and restoring it over the Test ...
1
vote
1answer
59 views

Restoring Database, creating new copy and use existing transaction logs for the original backup database to restore the NEW database to be current?

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 ...
0
votes
0answers
64 views

What are PDE files and how can I use them?

I've got a legacy DB which was given to me as a collection of PDE files. I've googled around and didn't come up with any useful information. Saw this question: Import .pde file on PL/SQL Developer .....
0
votes
0answers
31 views

Import databases using /var/lib/mysql

I've got some issues with my server, leading me to completely reinstall my debian OS. Before reinstalling, I backed up some files on the server and now it reveals that I have a backup of my previous /...
1
vote
2answers
51 views

How to recover deleted records with minimal downtime?

In an OLTP environment that cannot tolerated downtime, suppose if 100 records are deleted from table, how do we recover them? One way to recover the deleted records is to restore the database and/or ...
0
votes
0answers
84 views

mysql: Error reading file 'UNOPENED' (Errcode: 5 “Input/output error”)

I restore the backup of my main server daily in this other server. Today something went wrong and I received this message: mysql: Error reading file 'UNOPENED' (Errcode: 5 "Input/output error") I ...
7
votes
2answers
105 views

Restore database with a FileTable

We have a SQL Server 2014 (build 12.0.24457.0) database with two tables in, both are FileStream tables, the biggest has 2979466 rows, SUM(cached_file_size)= 40564905472. We have tried to restore this ...
1
vote
1answer
40 views

I'm seeing inconsisntecies in table data after exporting from one server and importing to another, why is this?

I'm quite new to the process of importing/exporting databases. I'm using Maria DB, and HeidiSQL to run queries, etc. I exported an entire database from our dev server, and loaded it into our live ...
3
votes
1answer
81 views

MySQL applying second incremental backup causes LSN in the ibdata files to be higher than LSN in the ib_logfiles

Using the backup procedure described below, it gives warnings. These warnings start to appear from the 2nd till 6th (last) incremental backup that is being applied to the base backup. How to solve ...
1
vote
0answers
22 views

SSMS Crashes when attempting to restore DB from Azure URL

I'd previously been using the April 2016 version of SQL Server Management Studio with no issues, but have run into problems since updating to the GA June 2016 version of SSMS. When I try to restore a ...
-2
votes
1answer
50 views

Oracle Restoring Database on Existing Database or rename database

I want to change my DB name in Oracle. I am using this command: nid TARGET=SYS/welc0me12$@CSPROD DBNAME=CSGOLD SETNAME=Y After that I am getting an error: Datafile E:\APP\ADMINISTRATOR\ORADATA\...
1
vote
1answer
41 views

Restoring a mysql database using --single-transaction

I learned that specifying "--single-transaction" (yes we do have InnoDB) option into the mysqldump tool produces a dump utilizing transactions. However, I am failing to find a way to restore the ...
1
vote
0answers
31 views

Re integrate MSSQL 2008 to new Active Directory

I have a server which was joined to an AD Domain, then installed with MSSQL Server 2008 R2 and System Center Operations Manager 2012's Reporting Server on it. The same server had the Active Directory ...
0
votes
2answers
58 views

SQL Server auto restore only log where not restored before

i want to make an auto restore script for the transaction log only i have found the script to restore log in directory which have named with dbname_timestamp.trn the problem is this script will ...
0
votes
1answer
64 views

SQL Server Msg 2812, level 16 state 62 line 30

i want to make automatic backup and restore my database on SQL Server 2012. i have made automatic backup with script in my windows server. now, i want to make auto restore with script, i have found ...
0
votes
3answers
94 views

Problem generating restore scripts for multiple ola backups

I am using Ola for maintenance solution. I have 300 databases I want restore those databases using scripts rather than going through one by one. I prepare the following script to generate restore ...
0
votes
2answers
52 views

Can I restore only the LOG of a database?

We have a 1.5TB database. I could create some replication strategies do replicate the database to another server in a fixed time.But the developers don't know when they will need to replicate this ...
0
votes
2answers
106 views

A tail-log backup of the source database will be taken ? Why I am seeing this warning

I took a backup of a database from 1st server (which runs SQL Server 2014). When I try to restore the backup to a 2nd server (which runs SQL Server 2012) I get this warning message: Warning ...
3
votes
2answers
70 views

Copy one database to another (existing) database on the same server

I have a "Live" database and a "Development" database and occasionally, I want to replace the entire contents of the development database with the live data. Ideally, without taking the live database ...
3
votes
0answers
70 views

how do i create an automated sql restore script for multiple backups?

Hello to all SQL gurus out there. I basically have 6 daily sql backups (.bak) that need a restore everyday. I want to automate this process by having the sql agent run the script daily. I have the ...
1
vote
2answers
32 views

Prevent SQL Server Management Studio changing destination DB on restore

Is there a way to prevent SQL Server Management Studio 2014 from automatically setting the destination database when you try to restore a backup to another database? I just had a nasty surprise when ...
0
votes
1answer
39 views

How to, efficiently, search through many sql dump files of really big size

We have an ads website that the uncompressed(plain .sql file) size of the database is about 30gb. Until now when a user was deleting his classified the classified was completely getting wiped out from ...
2
votes
1answer
23 views

Backup a hot standby database (streaming replication) whilst it is in recovery

Synchronous Streaming Replicating is set up between a master and a hot standby database. It seems like a good idea to perform daily backups on the standby database to avoid any performance issues ...
0
votes
1answer
39 views

Regarding Backup and Restore Strategy

Everyone I have some queries regarding backup and restore strategies. I want to take Backup and Restore of Large Database approx. 60 to 70 GB and it is critical database in SQL Server. Backup ...
0
votes
1answer
20 views

Having two data folder in my postgresql setup- Postgresql

I am using centos 6 and installed Postgresql_9.4 using the following commands yum install postgresql postgresql-contrib postgresql-client pgadmin3 yum install postgresql-server After that i ...
0
votes
1answer
26 views

Backup/Restore single database with MySQL Enterprise backup

From what I have found online is it is possible to backup/restore an entire mysql instance with MEB and also a single .ibd file (to my understanding is a single table). What I am trying to do is ...
0
votes
1answer
70 views

Restore a database with compression on a non-enterprise edition SQL Server

Is it possible to restore a compressed an object from backup without the Enterprise Edition? I'm getting the following error after a RESTORE DATABASE operation. Msg 3013, Level 16, State 1, Line 2 ...
0
votes
1answer
57 views

Dumping and restoring tables in PostgreSQL - ERROR: extra data after last expected column

I am trying to dump and restore multiple tables from a database on one server, to a different database on another server. Both are running Postgres 9.4 on linux. The command for the backup was: $ ...
0
votes
0answers
16 views

Backup and restore specific filegroups [duplicate]

I've seen this Stack Overflow question: Backup and restore SQL Server database filegroup. However, it didn't do what I needed. I have a database with three filegroups: primary, reporting, and ...
-1
votes
1answer
23 views

Restore DB script

I wrote this script for restore DB: declare @dir nvarchar(70), @year nvarchar(4), @month nvarchar(2), @day nvarchar(2) set @year = datepart(year,getdate()) set @month = datepart(month,getdate()) if(...
1
vote
0answers
55 views

How to backup SSIS packages and CUBE Projects from Visual Studio 2013.5?

I'm using VisualStudio 2013.5 to develop SSIS, SSDT and SSAS Cubes (multidimensional and tabular model). I would like to ask you is there a possible to backup SSIS packages and SSAS cubes from ...
4
votes
2answers
392 views

Help undoing an accidental restore on SQL Server 2014

Yesterday I made a serious mistake¹: Restoring the wrong database. Background (you may skip this section): I right-clicked the Test database and proceeded to the "Restore Database" section as ...
1
vote
1answer
68 views

Large `mongodump` followed by `mongorestore`

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 ...
1
vote
0answers
63 views

Will I have to restore controlfile in RMAN level 1 backupset before recover database?

For example, I have a level 0 and level 1 RMAN backupset files like inr00_0413_* inr01_0413_1_* Is it necessary to do this when recover from RMAN level 1 backup: restore controlfile from ...