Questions tagged [data-loss]
The data-loss tag has no usage guidance.
12 questions
0
votes
1
answer
86
views
SQL Server Failover Cluster Data Loss on failover
Currently running several databases on an Active/Passive SQL Server 2014 Failover Cluster on Windows Server 2012 R2. Recently there was an event that caused the active server to failover. The failover ...
0
votes
1
answer
30
views
How to implement historical data with this EERD?
I am looking for a way to implement historical data with the following EERD (what I have tried, below the image):
What have I tried?
Temporal tables
Didn't work because I use MySQL and it has no ...
0
votes
1
answer
28
views
MySQL Data not flushing to disk
Lets start with what I did...
I copied a table via PHPmyadmin operations/ copy table/(temp1) structure and data. nothing should make any changes to this copy.phpmyadmin shows 1185199 entries
I copy ...
0
votes
0
answers
345
views
What happens if you interrupt a POSTGRESQL database that's receiving data?
I have a Docker application and as a quick and dirty backup strategy, I'm thinking to tar the whole project incrementally and send it off remotely.
I'd rather keep the services running while doing the ...
- 101
2
votes
1
answer
1k
views
MS SQL 2008 Databse in Suspect mode and CHECKDB returns error: Object ID 3 has chain linkage mismatch
We did a disk expansion for VM DB server. However, after this operation the DB became suspect mode and cannot be open.
Then we tried somethings like that;
https://www.sqlrecoverysoftware.net/blog/...
- 21
0
votes
1
answer
293
views
Is there any scenario where a exported (.sql) database dump could be bigger in size, than the database itself?
I'm a developer in a local company, and I'm currently working on a project which involves migrating a website to my company's server, from some other hosting provider.
For some reason this other ...
user149325
0
votes
1
answer
26
views
Can vmware (virtualisation) configuration impact the data integrity of the data file [closed]
I'm wondering how much can a VMWare configuration impacts the integrity of the data file.
I mean, if the VMWare configuration is not optimal and the database writes a lot of complex operations (...
- 101
1
vote
1
answer
720
views
Can power failure rollback mysql innodb database of many days?
I have an application running on a x86 system with MySQL InnoDB database. This application store many rows per day and yesterday, due to a power failure, I experienced a rollback of a one entire day ...
- 201
0
votes
1
answer
2k
views
Worry to delete Read replica RDS
I created a read replica from RDS , and I do want to delete it.
I am so worry about affecting the origin RDS which is in PROD .
Is it recommended to take snapshots before deletion of read replica ...
- 101
2
votes
0
answers
256
views
Old records disappearing after upgrade from 9.4.1 to 9.4.4
I recently upgraded from 9.4.1 to 9.4.4. Since then millions of rows have disappeared from several tables containing historical data.
The severity of data loss seems to be directly proportional to ...
- 345
2
votes
3
answers
5k
views
MySQL “lost” all data(InnoBD)
Today I was making some work with site and I get error what MySQL can't rename file (to make changes in BD). Next I tried to restart MySQL, and it failed to stop MySQL. Then I did go to /var/lib/mysql ...
fhntv24
3
votes
1
answer
4k
views
How do I access a old saved tablespace after reinstalling postgres?
So a lot of things might have gone wrong here. I first installed postgres 9.3 on mac 9.1 via homebrew to manage some data. I am using postgres.app. Turns out my harddrive was too small so I decided to ...
- 31