Comments
Sort by recent activity
APOLOGIES - I need new glasses; I didn't see the 'xsp' option; Am unintalling and re-installing using that option instead.
So, disregard my Why IIS rant; apparently you all are smarter than most people who develop products requiring a web service and just assume IIS will work for them. / comments
APOLOGIES - I need new glasses; I didn't see the 'xsp' option; Am unintalling and re-installing using that option instead.
So, disregard my Why IIS rant; apparently you all are smarter than most pe...
We found the problem; was not on backup; new backup server - permissions on the folder were not set properly. / comments
We found the problem; was not on backup; new backup server - permissions on the folder were not set properly.
Oh, and I ran the statement below on the server...
exec master..sqbdata 'DELETE FROM backupfiles_copylist WHERE status <> ''S ''' / comments
Oh, and I ran the statement below on the server...
exec master..sqbdata 'DELETE FROM backupfiles_copylist WHERE status <> ''S '''
If I have to post the script 'in the clear' I'll just turn in a support call.
Thanks anyway. / comments
If I have to post the script 'in the clear' I'll just turn in a support call.
Thanks anyway.
Ok, I ran the suggested code to delete the entries from the queue; results were 0 rows.
I'm having the problem again. As you can see below, the problem is the source file does not exist. Note the last message - 111 attempts to copy the file thus far - seems a tad bit over the 10 times quoted in the replies.
Any idea how to stop this? It is flooding the email.
========= attachment ============================
SQL Backup file copy process failed to copy "M:\LDF BACKUP\LOG_(local)_DBA_20100517_103000.sqb" to "\\whaley10\Backups\WFR-DailyBackups\Whaley08\LOG_(local)_DBA_20100517_103000.sqb"
Last attempt started on 5/18/2010 8:52:24 AM, and failed with the error "COPYTO error: Unable to copy M:\LDF BACKUP\LOG_(local)_DBA_20100517_103000.sqb to \\whaley10\Backups\WFR-DailyBackups\Whaley08\LOG_(local)_DBA_20100517_103000.sqb (Source file does not exist: M:\LDF BACKUP\LOG_(local)_DBA_20100517_103000.sqb).
"
111 attempts have already been made to copy this file. / comments
Ok, I ran the suggested code to delete the entries from the queue; results were 0 rows.
I'm having the problem again. As you can see below, the problem is the source file does not exist. Note the...
In order to do that, I would have to turn the service back on, otherwise the application closes when I click on the icon.
Turning the service back on, even momentarily virtually assures a system halt, and this has become so problematic for us that I cannot turn it back on.
However, the vendor has owned up to being the core problem, so you can close this. / comments
In order to do that, I would have to turn the service back on, otherwise the application closes when I click on the icon.
Turning the service back on, even momentarily virtually assures a system ha...
scratch this... just went back in to the server after posting the previous, now it is updating / comments
scratch this... just went back in to the server after posting the previous, now it is updating
Brian -
I understand. That said, I am using SQL Backup. So how would I restored the msdb?
Surely Red Gate has tested this procedure. There must be some document that explains how to handle this, including some script to issue to the SQL Backup engine.
Yes/No? / comments
Brian -
I understand. That said, I am using SQL Backup. So how would I restored the msdb?
Surely Red Gate has tested this procedure. There must be some document that explains how to handle this, ...
Brian -
Understood. Let me re-phrase. I am not 'saavy' on using the scripting part of SQL Backup. So here is my question re-phrased.
Assume I put SQL Server into single user mode; theoretically, now msdb can be restored. Regardless of whether restoration occurs by restoring over the existing db, or detaching and removing it and restoring from backup, the question on the table at that point is what is the scripting command to SQL Backup to have it restore from a backup file? / comments
Brian -
Understood. Let me re-phrase. I am not 'saavy' on using the scripting part of SQL Backup. So here is my question re-phrased.
Assume I put SQL Server into single user mode; theoretically,...
I was simply attempting to restore from a backup over the msdb database with the GUI.
And while I appreciate the willingness to help; I'd really like to hear from someone at Red Gate on this as it is a system database and their product.
I'd like to know exactly how they recommend doing this.
Regards
Randy / comments
I was simply attempting to restore from a backup over the msdb database with the GUI.
And while I appreciate the willingness to help; I'd really like to hear from someone at Red Gate on this as it ...