Questions tagged [data-loss]
The data-loss tag has no summary.
12 questions
0 votes
1 answer
178 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
53 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
46 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
402 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
2k 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
344 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
36 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
770 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 ...
- 211
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
269 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