The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
51 views

SQL Server AlwaysOn Error:35250

I am configuring AlwaysOn in my test environment but getting the following error. Msg 35250, Level 16, State 7, Line 1 The connection to the primary replica is not active. The command cannot be ...
0
votes
1answer
46 views

Corrupt Transaction Log on database

I have reason to believe the transaction log file on my database is corrupt. This database is involved in transaction based replication (both subscription and publishing), and I'm unable to start ...
2
votes
1answer
40 views

New SQL Server from backup; application has successful login on 1 database, but fails on another: 0x80040e4d

Our SQL Server crashed and burned, the hard drives destroyed. No hope of recovery. We need to get a very important application working again; this is on a different server. We've set up a new SQL ...
0
votes
1answer
19 views

Always On -Stand Alones

Can i add a Stand alone instance to a Windows Fail-over Cluster for Always-On Set up. I need to have one secondary Synchronous replica with automatic failover ? Please advice.
0
votes
0answers
28 views

SAN replication vs AlwaysOn vs something else?

Working on a DR project at the moment, we have our primary location which is all setup. Our secondary location has most of the hardware we need already. We have a Microsoft SQL driven web application. ...
1
vote
3answers
61 views

Restore multiple databases quickly - practicing disaster recovery

I am currently working administering a SQL Server 2014 Standard Edition instance for Sharepoint 2013. We started 5 month ago with ~25 DB's and now we have 60 in total. So the databases in use are ...
0
votes
1answer
36 views

Standby archive deletion

I have a primary database with a standby in data guard configuration running in a RHEL host. Thing is the storage assigned to this DR is very less, meaning the archive logs file system gets full in ...
3
votes
2answers
252 views

What to do when your AlwaysOn cluster loses quorum?

I was reviewing our company DR procedures and when I looked online for solutions to an AlwaysOn Cluster losing quorum, to compare to. I was three pages into google results before finding the first SE ...
3
votes
0answers
84 views

Recovery from Live to a new Slave Server - PostgreSQL - ERROR

I've started a new SLAVE PostgreSQL server set up. master: 192.168.100.1 slave1: 192.168.100.2 slave2(NEW SLAVE) 192.168.100.3 * NOTE: I run the pg_basebackup from another STANDBY SERVER. Not ...
1
vote
0answers
32 views

How to sync incomplete replication records in MySQL

if replication breaks and you end up with a couple of records not pushed out to the slave, is there a way to update the slave without stopping locks on the master and manually transferring a new ...
1
vote
0answers
19 views

Replicating data from SQL Server 2014 to SQL Server 2005 - temporary solution

I will be installing a new SQL Server 2014 database system, which is based on our current SQL Server 2005 database system. The new system will be on a completely new infrastructure when we go live, ...
2
votes
1answer
68 views

Recommended mirroring alternative?

SETUP 2 Amazon EC2 SQL 2014 servers in different availability regions. Synchronous mirroring S3 for archiving full backups & logs at night Right now for simplicity, nightly full compressed ...
0
votes
2answers
45 views

How to reduce LOG file after switching from full recovery mode to simple mode?

I have a database with full recovery model and without TLog backup. The log file have grown to 160GB and I found out that it needs TLog to be periodically backed up or the recovery model switched to ...
0
votes
1answer
27 views

How to disable replication when Distribution db is lost?

I am in the situation that the Distribution database in SQL Server 2014 is lost and I want to disable the replication. I have found a solution how to achieve that when data files are present (also ...
0
votes
0answers
65 views

SQL Server DB in suspect mode after installing SQL Server 2008 R2 SP3

One of our production DBs is stuck in Suspect mode since we installed SQL Server 2008 R2 SP3. Earlier today we found that most text fields (nvarchar) had the following data appended to it ...
1
vote
1answer
88 views

Log Shipping Fails with CONTINUE_AFTER_ERROR

DR plan for primary database in a private hosted cloud environment. The primary is a hosted physical server. The secondary is on another network, same domain. Version is SQL Server 2008R2 ...
0
votes
0answers
59 views

Restore a TokuDB table from main and key files only. (Status file missing)

I have a TokuDB table that for some reason has a missing _status.tokudb file. I am not yet sure, whether the file is missing due to a TokuDB crash or not. Question is: Is there a way to recover ...
0
votes
1answer
245 views

MySQL: Recover Master from Slave after failover

I have replication running between two MySQL instances on two separate servers. Let's say M is the master and S is the slave. It's setup as one way replication M->S. I currently have S as read only ...
0
votes
1answer
139 views

Query on Standby redo logs - Oracle

I have a oracle 11g (11.3) database running with two standby databases (at different locations) in Maximum performance mode. The platform is Linux. Log transport parameters are: log_archive_dest_5 ...
1
vote
0answers
30 views

Looking for a DR-like solution to enable full data warehouse re-load while having secondary copy live

I am looking for suggestions/ideas to the following problem. We have a number of data warehouses for each of our clients (on SQL Server 2014). These data warehouses are maintained fairly fresh with ...
1
vote
1answer
303 views

Postgresql - Point in Time recovery using recovery.conf and trigger. How to minimize the time waiting for .history files

Following http://www.postgresql.org/docs/9.1/static/continuous-archiving.html, I copy the WAL archives to another machine and apply them regularly. Recently due to pg server crash at my main server I ...
2
votes
1answer
36 views

Recover mysql using data folder

One of our MySQL servers died but somehow we were able to recover all the files from it. This server was a slave at one time however we stopped it being a slave so we could use it for housekeeping ...
0
votes
0answers
34 views

Oracle DB - DR corruption

One of my databases in my DR is fully corrupted ( I have checked running validate database using RMAN). Now to recover all the data files which are corrupted I need to copy the data files from my ...
0
votes
1answer
58 views

what exactly does an RMAN backup do?

I have a database with multiple schemas and data in the tables. I create an rman backup and backup archivelogs. I drop 90% of the tables. I do rman restore and recovery with controfile from ...
1
vote
0answers
32 views

Oracle far sync in 12c [closed]

How efficient is far sync feature when it comes to dr? Does it really provide zero data loss with very less compute?
1
vote
0answers
27 views

Oracle DataGuard [closed]

Maximum performance and Maximum Availability modes has only difference right? Former is async mode and the latter is sync mode wherein it waits for acknowledgement for up to a time and after that it ...
0
votes
1answer
34 views

How can SQL server AlwaysOn AG can be used as a DR feature?

I'm using AlwaysOn ag feature as a HA feature where automatic failover is possible.. I was thinking to log shipping as DR but there is potential data loss in that.. thinking of using ag as a ...
3
votes
3answers
255 views

Hyper V replication - vs - sql replication solutions

I need to establish an offsite copy of a number of production servers, including SQL server. Hyper V replication has been chosen as a simple solution (all servers are virtual). This is to supplement ...
6
votes
2answers
492 views

SQL Server 2012 Standard Edition Disaster Recovery Options?

Suggest me the best method for My DR plan. Currently we have set of databases (6) used for our application and we in the process of building DR and HA plan. As we are into small business we are using ...
2
votes
0answers
49 views

How To Roll Back DR Transactions Without Breaking Mirror

We have a full data center DR test coming up and will need to fail over all of our SQL Server databases to the DR site. The majority (>80%) of our databases are SQL Server 2008 R2 using Database ...
1
vote
1answer
118 views

Oracle: Recover source code/table structures from “utterly wiped out” development database

Given an Oracle 11.1 database used for development, running in NOARCHIVELOG mode, where all datafiles (including undo) have been wiped out; and only SYSTEM and SYSAUX datafiles and control file remain ...
1
vote
1answer
147 views

LSCopy job fails on SQL Server 2005 - Insufficient space

I'm having some trouble getting my LSCopy job of Log-Shipping on my SQL Server 2005 server, to work. The LSBackup job is configured so the backup is made locally (D: drive) The LSCopy job is ...
2
votes
2answers
868 views

Why is Full Recovery model a requirement for AlwaysON? [closed]

We have all our production databases in simple recovery model, and are very happy about it because it fully satisfies our RPOs and RTOs. Now we want to implement AlwaysON DR solution for our ...
1
vote
5answers
322 views

Getting Data Back after Wrong Data Restore in SQL Server

I would like to inquire if there is an possible way to return lost data that stored in a Sql server Database after making a wrong database restore? I know it is extremely hard to get a positive ...
0
votes
1answer
78 views

Operating system disaster recovery strategies

I have read a lot about disaster recovery planning of databases (mainly SQL Server). There are multiple articles/book chapters about backing up databases and recovering them from backup. But what if ...
0
votes
1answer
251 views

Ubuntu broken need to recover mysql db

With a recent Ubuntu upgrade it has broken my system. I now only have access to the filesystem through a live CD. I had a MySQL database on the system with many objects and views I would hate to lose. ...
2
votes
1answer
987 views

How to restore database from /var/lib/mysql

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

Can two databases share one data folder?

I'm planning to install a database (same configuration) on two separate machines, PC1 and PC2. PC1 is the main database while PC2 is the backup.. Is it possible that they can have the same datadir in ...
0
votes
1answer
266 views

Single node SQL Server 2014 cluster at DR environment

We are setting up a new Disaster Recovery environment. On Production we have SQL Server cluster with two nodes. For DR we decided that one node should be enough. The plan is to add the second node ...
0
votes
1answer
75 views

DB2 Transaction Logs - can they be COPY-PASTE on another Disaster Recovery Server?

We have Server1 with Online Backup1, Archive Logs 1,2,3 for example and Transaction Logs from 1 to 10. We are interested in next scenario: If Server1 fails completely and we want to move everything ...
1
vote
2answers
61 views

RMAN backup set, nothing else, how can I duplicate?

I have what appears to be an RMAN backup set, it has been multiplexed in 32 files, each containing 2-3 dbf's inside. The backupset refers to an SPFILE file, but it was not included in the set, the ...
1
vote
3answers
272 views

Recover deleted table from the database

Currently I deleted one table from the database. But now I want some of the information from that table. Please suggest how to restore or get back the table. I am using SQL Server 2008 R2.
1
vote
2answers
454 views

Best DR strategy for MS SQL Failover Cluster [closed]

I have... 2 database servers 1 shared SAN storage 2 MSSQL 2012R2 (Standard) server instances (2 SQL Failover Cluster) Server A is the primary node for SQL Instance A Server B is the primary node for ...
2
votes
3answers
496 views

Problem to access the SQL Server

I have SQL Server 2005 which is installed on server machine. I was working fine on SQL server before I change the server machine IP. I changed server machine IP to host the Web Service on it. But ...
0
votes
0answers
78 views

Postgres 9.0 recovery from inadvertent drop-all-tables event

Due to a accidental config file check-in, a unit test wiped out our entire production database (did a drop, then re-created the tables). Trying to restore from backup revealed the recent backups were ...
1
vote
1answer
3k views

Not receiving archivelogs from production to remote side

I have a scenario in which we have Designed data guard. Where we have 2 standby sides. One standby is located locally and 2nd standby is located on remote side. The distance between local and remote ...
0
votes
1answer
40 views

MySQL recovery procedure

After the server die, I have "old" HD (it is external now) with sock file and data files in mysql directory. Where I should find information how to restore the data in fresh installed MySQL? What ...
1
vote
1answer
114 views

Dual site active-active highly available database

I have an application that is being run on two separate sites. Ideally they would share a database, because each application needs to see what the other is writing to the database. However, the sites ...
0
votes
1answer
79 views

Replication Madness

Summary We were contracted to build a "Hot-Standby" for a company which keep their data in the cloud. The through-put is relatively low. Database availability/accuracy is a matter of life or death. ...
0
votes
2answers
768 views

Disaster Recovery Options for Sql Server

I wanted to see what suggestions you might have for Disaster Recovery Options based on the following criteria. Currently running SQL 2012 standard edition We have 18000 databases (same schema across ...