Comments
Sort by recent activity
Only differentials. As long as you have an unbroken chain of log backups, you can still use the last full database backup taken with SQL Backup or SQL Server, and restore the transaction logs. / comments
Only differentials. As long as you have an unbroken chain of log backups, you can still use the last full database backup taken with SQL Backup or SQL Server, and restore the transaction logs.
They will break differential backups i.e. any differential backups taken after these snapshot backups will not be restorable, until you take a full backup with SQL Backup or SQL Server. / comments
They will break differential backups i.e. any differential backups taken after these snapshot backups will not be restorable, until you take a full backup with SQL Backup or SQL Server.
Best guess at this point is that it's a snapshot backup performed by your virtual machine, seeing as how they are virtual device backups and they all kick off at the exact same moment. / comments
Best guess at this point is that it's a snapshot backup performed by your virtual machine, seeing as how they are virtual device backups and they all kick off at the exact same moment.
Try running this query to see if it uncovers anything useful: SELECT a.backup_start_date, a.database_name, a.type, b.device_type, b.logical_device_name, b.physical_device_name, a.name, a.user_name FROM msdb..backupset a INNER JOIN msdb..backupmediafamily b ON a.media_set_id = b.media_set_id WHERE a.backup_start_date >= '2020-5-26 5:38' AND a.backup_start_date < '2020-5-26 5:39' ORDER BY a.backup_start_date / comments
Try running this query to see if it uncovers anything useful:SELECT a.backup_start_date, a.database_name, a.type, b.device_type, b.logical_device_name, b.physical_device_name, a.name, a.user_name F...
Please have a look at this article - https://productsupport.red-gate.com/hc/en-us/articles/360008089393 / comments
Please have a look at this article - https://productsupport.red-gate.com/hc/en-us/articles/360008089393
Yes. SQL Backup has never been able to restore native SQL Server backup files. / comments
Yes. SQL Backup has never been able to restore native SQL Server backup files.
SQL Backup cannot restore native SQL Server backup files. It can only restore backup files created using SQL Backup. / comments
SQL Backup cannot restore native SQL Server backup files. It can only restore backup files created using SQL Backup.
In the SQL Backup log folder (default is C:\Users\All Users\Red Gate\SQL Backup\Log\), is there a text file named SQBCoreService_<instance name>_bugreport.txt file? If there is, could you please send that file to peter.yeoh@red-gate.com? Thanks. / comments
In the SQL Backup log folder (default is C:\Users\All Users\Red Gate\SQL Backup\Log\), is there a text file named SQBCoreService_<instance name>_bugreport.txt file? If there is, could you please s...
When you use the ERASE command, it only deletes backup files: - belonging to the same server/instance as the server/instance you are running the command from - for the specified database (DATA_01) - for the specified backup type (FULL_BACKUPS) - older than the retention period (30) If all these criteria match the backup files that were suppose to be deleted but were not, could you please post the results of running a RESTORE SQBHEADERONLY command for any one of the backups that should be have deleted but was not? E.g. EXEC master..sqlbackup '-sql "RESTORE SQBHEADERONLY FROM DISK = [<filename>]"' You can send me the details at peter.yeoh@red-gate.com if you prefer not to post it here. / comments
When you use the ERASE command, it only deletes backup files:- belonging to the same server/instance as the server/instance you are running the command from- for the specified database (DATA_01)- ...
A few possibilities: - are the backup files password protected? - do the backup files belong to the same server/instance you are running the deletion from? - are the backups that were not deleted full database backups? / comments
A few possibilities:- are the backup files password protected?- do the backup files belong to the same server/instance you are running the deletion from?- are the backups that were not deleted full...