Question : I have 134 separate databases on a SQL Server. Every 15 minutes an entry appears in the msdb.dbo.backupset […]
Category: Database Backup
Identify mysqldump activity in MySQL log file?
Question : I have a database that is being regularly backed up by mysqldump by… something. It’s not a script […]
Backing up my SQL Server System Databases
Question : I’m trying to create a recurring scheduled job to fully backup the master, msdb and model databases, I’m […]
Performing frequent backups of a large MySQL slave
Question : We replicate our production MySQL databases (120 GB on production) to a dedicated local desktop machine. The local […]
Need urgent help with recovering data from dropped database
Question : I just made a huge mistake by doing a rails command on my production web server which reset […]
Can I use xtrabackup to import a database without altering others?
Question : Context: Each time a demo branch is built, I want to download a copy of the prod database […]
How memory limit for backup process is calculated?
Question : How “memory limit” for backup process is actually calculated? Answer : You must have got the output after […]
How can I get SQL Server restore start and end time information?
Question : SQL Server error log reports only the end of the restore (ah doc restore) How can I get […]
How do I save functions to individual files in PostgreSQL?
Question : I maintain a legacy application that uses a PostgreSQL database. The application is heavily dependent on stored procedures […]
Does MSSQL Log shipping truncate the transaction log?
Question : I have setup log shipping on a database in Microsoft SQL Server 2012. I was having issues with […]