User profile for gsc_ghx

Peter - Thank you. I tried to create that folder - and discovered that we did have that folder. It was hidden and all the files in it were hidden. I have since found the log and discovered the reason that the backup failed. The file was in use - I believe there was a tape backup at that time and the backup process could not access the file. I do very much appreciate your help and responsiveness to my issue. Thanks Geri [image] / comments

Peter - Thank you. I tried to create that folder - and discovered that we did have that folder. It was hidden and all the files in it were hidden. I have since found the log and discovered the r...

0 votes

Peter - I am sorry but we don't havet that folder set up. So therefore there is no log file to send you. What next? Geri / comments

Peter - I am sorry but we don't havet that folder set up. So therefore there is no log file to send you. What next? Geri

0 votes

Nope - no such folder on this system. At least on the active node of this cluster. I just checked my passive node - same thing - no folder under all users for Application Data and I have searched for the log on both machines. Geri / comments

Nope - no such folder on this system. At least on the active node of this cluster. I just checked my passive node - same thing - no folder under all users for Application Data and I have searched...

0 votes

when i run the following code - SELECT b.backup_start_date, b.database_name, b.user_name, a.logical_device_name, a.physical_device_name FROM msdb..backupmediafamily a INNER JOIN msdb..backupset b ON a.media_set_id = b.media_set_id WHERE b.backup_start_date >= GETDATE() - 7 AND a.logical_device_name LIKE 'Red Gate SQL Backup%' it returns a value Red Gate SQL Backup (4.2.0.511):00000000036300000000000000C2760000005C17000000030101 - does the 4.2.0.511 refer to the version of backup software we are using? Also - how would i find out what servers are running which license we have? I need to identify which servers have which license... Thank you... / comments

when i run the following code - SELECT b.backup_start_date, b.database_name, b.user_name, a.logical_device_name, a.physical_device_name FROM msdb..backupmediafamily a INNER JOIN msdb..backupset b O...

0 votes

I found the information. I so appreciate your assistance. / comments

I found the information. I so appreciate your assistance.

0 votes

peter thank you so VERY much for responding. I had two failures here they are: This failed Monday - 12/3 at 8:30pm SQL Backup log file 12/3/2007 8:30:01 PM: Backing up master (full database) to: \\server1\sqlbkp3\CATSQL02\master_FULL_RG.bak 12/3/2007 8:30:01 PM: BACKUP DATABASE [master] TO DISK = '\\server1\sqlbkp3\CATSQL02\master_FULL_RG.bak' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', INIT, COMPRESSION = 1 12/3/2007 8:30:02 PM: Thread 0 error: Error 620: Error writing to backup file(s). Process terminated unexpectedly. Error code: -2139684860 Thread 0 warning: Warning 210: Error writing to backup file: \\server1\sqlbkp3\CATSQL02\master_FULL_RG.bak Warning: System error code: (Insufficient system resources exist to complete the requested service) 12/3/2007 8:30:02 PM: Server: Msg 3013 BACKUP DATABASE is terminating abnormally. 12/3/2007 8:30:02 PM: Server: Msg 3202 Write on 'SQLBACKUP_C82BA2F7-37C4-49BF-9BB4-256B4DCFC853' failed, status = 112. See the SQL Server error log for more details. 12/3/2007 8:30:02 PM: Failed to close vdi. this failed 12/4/07 at 4:45am SQL Backup log file 12/4/2007 4:45:00 AM: Backing up Admin (full database) to: \\server1\sqlbkp3\CATSQL02\Admin_FULL_RG.bak 12/4/2007 4:45:00 AM: BACKUP DATABASE [Admin] TO DISK = '\\server1\sqlbkp3\CATSQL02\Admin_FULL_RG.bak' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', INIT, COMPRESSION = 1 12/4/2007 4:45:01 AM: Thread 0 error: Error 620: Error writing to backup file(s). Process terminated unexpectedly. Error code: -2139684860 Thread 0 warning: Warning 210: Error writing to backup file: \\server1\sqlbkp3\CATSQL02\Admin_FULL_RG.bak Warning: System error code: (Insufficient system resources exist to complete the requested service) 12/4/2007 4:45:01 AM: Server: Msg 3013 BACKUP DATABASE is terminating abnormally. 12/4/2007 4:45:01 AM: Server: Msg 3202 Write on 'SQLBACKUP_7176AF0D-A8A8-4CEC-A256-F112B11EC4D3' failed, status = 112. See the SQL Server error log for more details. 12/4/2007 4:45:01 AM: Failed to close vdi. there is more than sufficient disk available - 21gb in fact. The sql server log shows: 12/3/07 8:30pm Date 12/3/2007 8:30:00 PM Log Job History (DBA_Backup_System_Full) Step ID 1 Server CATSQL02 Job Name DBA_Backup_System_Full Step Name DBA_Backup_System_Full Duration 00:15:02 Sql Severity 16 Sql Message ID 245 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Executed as user: sqla_svc. ***** Backing Up Database : master ***** [SQLSTATE 01000] (Message 0) -SQL "BACKUP DATABASE [master] TO DISK = '\\server1\sqlbkp3\CATSQL02\master_FULL_RG.bak'WITH COMPRESSION = 1, INIT, MAXTRANSFERSIZE = 65536, MAXDATABLOCK = 655360" [SQLSTATE 01000] (Message 0) Syntax error converting the varchar value ' ==== backup failed: ' to a column of data type int. [SQLSTATE 22018] (Error 245). The step failed. And the 12/4/07 4:45am job - same thing Date 12/4/2007 4:45:00 AM Log Job History (DBA_Backup_User_Full) Step ID 2 Server CATSQL02 Job Name DBA_Backup_User_Full Step Name DBA_Backup_User_Full Duration 00:15:02 Sql Severity 16 Sql Message ID 245 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Executed as user: sqla_svc. ***** Backing Up Database : Admin ***** [SQLSTATE 01000] (Message 0) -SQL "BACKUP DATABASE [Admin] TO DISK = '\\server1\sqlbkp3\CATSQL02\Admin_FULL_RG.bak'WITH COMPRESSION = 1, INIT, MAXTRANSFERSIZE = 65536, MAXDATABLOCK = 655360" [SQLSTATE 01000] (Message 0) Syntax error converting the varchar value ' ==== backup failed: ' to a column of data type int. [SQLSTATE 22018] (Error 245). The step failed. I am new to this position - as the other SQL DBA left and i have no one that is knowledgable about this process. Thank you so much again. :roll: g / comments

peter thank you so VERY much for responding. I had two failures here they are: This failed Monday - 12/3 at 8:30pm SQL Backup log file 12/3/2007 8:30:01 PM: Backing up master (full database) to: ...

0 votes

We backup to a backup share - hosted on a VM windows machine. Thanks Petey. / comments

We backup to a backup share - hosted on a VM windows machine. Thanks Petey.

0 votes

Thank you Chris. You can add another vote for adding that feature... / comments

Thank you Chris. You can add another vote for adding that feature...

0 votes

I am having this issue again. I have stopped and restarted the service many times. Then get the error again. Error is: Failed to initialize local data store: File already exists. Try using a different database name...... Any help is appreciated. Thank you Geri / comments

I am having this issue again. I have stopped and restarted the service many times. Then get the error again. Error is: Failed to initialize local data store: File already exists. Try using a diff...

0 votes

Peter - I found that the user the backup agent is running under did not have sufficient rights to the redgate folder. I have changed the backup agent user back to what it was prior to the update on Friday night. If I have this issue again and it is not user related - I will then turn debugging on. Thank you so much for responding... Geri / comments

Peter - I found that the user the backup agent is running under did not have sufficient rights to the redgate folder. I have changed the backup agent user back to what it was prior to the update o...

0 votes

How can we help you today?

gsc_ghx

Comments