Question : I run a daily backup of my database through command prompt: c:sqlcmd -H localhost -Q “BACKUP DATABASE test […]
Category: Database Backup
Restore postgres in command line on ubuntu failed
Question : This question may be asked many times. We are trying to move a postgres db from windows (psql […]
Using SQL Server native backup and Veritas Backup Exec to backup the database and transaction log on the same database
Question : I have a customer who use the Microsoft SQL Server native backup and Veritas Backup Exec to backup […]
SQL Always On COPY ONLY backups – what’s the point if I cant restore the AG from these backups?
Question : Think I already know the answer to this but I’ll ask anyway. Situation is: SQL 2012 Always On […]
Race condition on incremental backups
Question : I am planing to automate to take incremental backups on a range of sql servers from 2000 to […]
How large will the Transaction Log backup be?
Question : I encountered a production database of 12 GB with a log of 90 GB. Full and differential database […]
File permissions for database backups and certificate backups
Question : I have backed up a database and backed up the database master key to the very same folder. […]
Database backup with no frozen I/O
Question : Is there a way to make automated backups of a DB without having the I/O frozen ? I […]
Will non copy only full backup impact transaction log backups chain?
Question : We have full backups and log backups configured. During restore we apply full backup and subsequent log backups. […]
Necessity of backing up tail log when restoring transaction log?
Question : I have a question about whether or not it is necessary to back the tail log up when […]