The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
37 views

Log shipping - failed over to secondary, how to fail back

SQL 2012 I've been researching and testing Log Shipping as a DR solution. I got the two servers setup. Log shipping is in place and verified to be working correctly. I failed over by restoring the ...
0
votes
1answer
37 views

Oracle Recovery

Oracle server died. Built a new VM and mapped out the volumes to the SAN. Installed the same version of Oracle on the new server and applied the same patches. How can I "register" or "attached" the ...
0
votes
2answers
75 views

Recovering mysql innodb table from table.ibd backup file

Just practising DB disaster recovery. As per our back up policy, we do complete disk image back ups every half an hour (on our slave server). Now for a scenario, where some how a table has been ...
0
votes
1answer
108 views

Mysql trying to recover from Hard disk failure [duplicate]

Am trying to get a database up and running after having a hard disk crash, got the data recovered. mysql can only start with the innodb_force_recovery set as 5 or 6. When started I can get a table ...
2
votes
1answer
49 views

Can you restore log file backups to a mirror database after failure?

Purely a theoretical question as I've been considering possible DR scenarios... In this scenario: The link between a principle and a mirror server becomes unavailable for a period of time (e.g. ...
1
vote
1answer
96 views

Database Recovery Model - Simple vs. Full [duplicate]

Does the SIMPLE Recovery Model perform the same transaction logging as FULL Recovery Model? i.e. keep record of each insert/update/delete transaction? If this is the case, then why should FULL ...
1
vote
2answers
141 views

Recovery from datafiles

Thanks to the recent weather/floods, we lost many of our servers. This included our central database server as well as the server that holds our backups. The database server was running Oracle 12c ...
6
votes
1answer
318 views

Broken tempdb location and can't recover

Made a mistake and mistyped an alter database command for tempdb. Now the instance won't start. I can't start in single user mode using -m as it states the tempdb could not be found. I tried using: ...
0
votes
1answer
242 views

FATAL: catalog is missing 1 attribute(s) for relid 2662

I have a server with PostgreSQL9.1-903 (Windows 7 Professional). After a power cut my database is inaccessible (I presume that the database is corrupted). The postgreSQL service starts but the ...
3
votes
0answers
131 views

Why are we suddenly getting time-outs on multiple transactions? [closed]

Two days ago the transaction log filled up and my user's couldn't update or insert. One of my techs truncated the log, shrank the db, then did a full backup. The next day (Monday) we noticed that ...
2
votes
1answer
1k views

Max Memory settings on Multi-Instance SQL Server 2008 R2 Cluster

SQL Server 2008 R2 multi-instance cluster (on VMware vSphere 5.1) 2 nodes, each running 2 instances 16GB RAM per node. The only time the instances are on the same node is when I am patching the ...
1
vote
2answers
152 views

Get missed transactions from slave

I'm trying to write a disaster recovery plan, I have one way replication with 1 master(A) and 3 slaves(B,C,D) A /|\ / | \ B C D Let's say my master crash, and I loose all data on ...
0
votes
1answer
112 views

Disaster Recovery for PostgreSQL 9.0

We have a number of PostgreSQL 9.0 servers. We use binary replication to have a host standby instance of those. The only problem is that is someone drops the master, with or without intentions, this ...
0
votes
3answers
187 views

Oracle DB Recovery

Before I start, I just want to mention that I am not a DBA, I am a programmer/developer who also happens to look after the database. So if I say something wrong, my apologies in advance. We recently ...
0
votes
3answers
121 views

Master/Slave without populating tables

So I have some Zabbix instances which are using MySQL for their backends. What I would like to do is, for DR purposes, backup the DBs for each instance using a Master/Slave configuration, with the ...
0
votes
1answer
98 views

RavenDB - Disaster Recovery on a Replicated Instance

EDIT: I'm encountering precisely the same issue. Assume that I have two RavenDB instances. Instance 1 contains one document: users/1. Instance 2 contains three documents: users/2, users/3, and ...
0
votes
1answer
55 views

Subscriber database to be in sync using Distributor

I have database D1 as a publisher, D2 as a subscriber and they are using Distributor 'DIST' which is reside on the subscriber side. Both D1 and D2 database having DR databases called DR1 and DR2. I ...
0
votes
2answers
1k views

Resume Logshipping after Primary database restored

We have Database (D1) as a primary database and Log shipping setup to the secondary database called (LS_D1). Now what we are doing is taking backup of D1 database and restore it on D2 database. We do ...
4
votes
2answers
678 views

Can I recover a TDE certificate by restoring the MASTER database?

(We are, fortunately, not currently in this situation, just planning ahead to see what our options would be if it ever occurred.) For a database encrypted with Transparent Date Encryption (TDE), a ...