Question : I read a lot of documentations for db2 restore but I could not find how to perform online […]
Category: Database Backup
Having the backup file, how to work out the total disk space required to do the restore?
Question : I have a nice query that gives me the date of last full backup, size and location, even […]
TRY/CATCH only reports the last (and most useless) error
Question : (This is SQL Server 2016 SP2-CU12.) When running this command interactively, I see the quite useful Msg 3035, […]
Differential backup same size as of Full Backup
Question : I have a SQL Server database of almost 2 TB size, it has tables with image datatypes. Now […]
Restoring dump(backup): ERROR 1022 (23000) at line 44: Can’t write; duplicate key in table
Question : I’m doing tests to change a current table from my InnoDB database to Archive, but I had a […]
Transaction Log Backup Maintenance Plan and Newly Restored Databases
Question : When we add a new database (restore from a staging instance) to our live instance we have a […]
Mongodump affects app performance really bad
Question : We have quite a big mongo instance (150 GB) with no sharding, and our regular backup (mongodump) has […]
Users complain that system runs slow when mysqldump is in progress
Question : The MYSQL database (ibdata1) is of size 73 GB and is configured to run as a dedicated database […]
SQL Server Table Backup [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Which MySQL directories to back up using FTP
Question : My server has been hacked and I only have FTP access to recover my data before reinstalling the […]