Posts
Sort by recent activity
Backupset showing backup type
I want to use backupset to determine when the last FULL backup was taken. My log backup job currently looks at backupset and if the backuptype is not D, the log does not initialize the log backup....
Back up errors
I am getting the following error after a backup:
SQL Backup log file
5/9/2008 5:46:12 PM: Backing up CAT_StJoseph_Regional_Health (full database) to:
\\prdsmb1.ghx.com\sqlbkp\CATSQL02\sqlbkp\CAT_Re...
Backup job spawning several processes
I have noticed that when I am running a backup using SQL Redgate (4.2) that i have several processes in the activity monitor of SSMS. Does the backup job spawn multi thread operations for backups?...
Appending to backup log files
A previous DBA indicated that Redgate SQL Backup does not allow for appending backups to a single log file. Thus requiring a new file to be created for each log backup. This forced us to use the ...
Error message or not
I have backups that report an error but when I look at the job log - it shows this:
SQL Backup log file
3/25/2008 5:00:00 AM: Backing up dba (full database) to:
3/25/2008 5:00:00 AM: \\SQL_Land\d...
SQL Backup failed on vdi error
I have a backup that has failed now for several nights. This morning the error was reported as:
SQL Backup log file
3/9/2008 5:01:18 AM: Backing up CAT_Broward (full database) to:
\\prdsmb1\sqlbkp...
Backup failed -
I get the following message when trying to run my normally scheduled backups.
SQL Backup log file
1/29/2008 5:15:34 AM: Backing up portal200401 (full database) to:
\\datadrive\SQL_Land\devsql02\por...
Backup will not complete - no logs, no entries
My system full backup failed tonite. The SQL Server logs just say the spid was calling the backup file: Source spid59
Message
Using 'xp_sqlbackup.dll' version '0005.01.00' to execute extended st...
Differntial BU failing on SQL Backup 4.2.0.511
Using SQL Server 2000 - my differential backup job is failing occasionally. the output from the Event Viewer and SQL logs:
BackupVirtualDeviceSet::Initialize: Open failure on backup device 'SQLBAC...
How to tell if you are using SQL Backup?
I am new to sql server dba and have never used this software (SQL Backup) and there is no one who can tell me if they use the Redgate software for backups. How would i know?
Thanks
g