User profile for MikeShepard

Same results using local install of server components (as opposed to the remote install) / comments

Same results using local install of server components (as opposed to the remote install)

0 votes

I'll try that and let you know. I've repeated this and had the same results on several machines. Fortunately, uninstalling V4 and re-installing v3 has worked fine. / comments

I'll try that and let you know. I've repeated this and had the same results on several machines. Fortunately, uninstalling V4 and re-installing v3 has worked fine.

0 votes

I've tried using sa and the sa password, and blanks. I also granted the server admin role to the 2 nt accounts that I have been trying (but they were already sysadmins) Error contacting the SQL Backup Agent. Check that the SQL Backup Agent service has been started for this server. Error : 5 (Access is denied) / comments

I've tried using sa and the sa password, and blanks. I also granted the server admin role to the 2 nt accounts that I have been trying (but they were already sysadmins) Error contacting the SQL Ba...

0 votes

Error backing up

I am receiving an error (from the GUI or calling stored procs) doing backups on a server I just upgraded from 3.2 to 4.2. Here's the error: Error contacting the SQL Backup Agent. Check that the SQ...

3 followers 5 comments 0 votes

MIRRORFILE problem

I want to be able to supply a TO DISK and a MIRRORFILE parameter, and have it succeed if either backup succeeds. The help file leads me to believe that this will work, but when I try it, it seems ...

1 follower 1 comment 0 votes

That was a typo. I fixed the parameter and got the same error message (except that the path was correct) / comments

That was a typo. I fixed the parameter and got the same error message (except that the path was correct)

0 votes

5/3/2005 3:18:29 PM: SQL Backup 3.1.0, (c) Red Gate Software Ltd 2004 - 2005 5/3/2005 3:18:29 PM: 5/3/2005 3:18:29 PM: Backing up EPM88PRD (full database) to \\mmofile\\sqlbackups\MMOPSEPM\EPM88PRD\EPM88PRD_sqlbackup2005-05-03-15-18-29.sqb ... 5/3/2005 3:18:29 PM: 5/3/2005 3:18:29 PM: BACKUP DATABASE [EPM88PRD] TO DISK = '\\mmofile\\sqlbackups\MMOPSEPM\EPM88PRD\EPM88PRD_sqlbackup2005-05-03-15-18-29.sqb' WITH NAME = 'Database EPM88PRD, 2005-05-03-15-18-29', DESCRIPTION = 'Backup on 2005-05-03-15-18-29 Database: EPM88PRD Server: MMOPSEPM', ERASEFILES = 3, COMPRESSION = 1 5/3/2005 3:18:29 PM: 5/3/2005 3:18:29 PM: 5/3/2005 3:18:30 PM: Thread 0 error: Error 620: Error writing to backup file(s). Process terminated unexpectedly. Error code: -2139684860 Thread 0 warning: Warning 610: Error writing to backup file: \\mmofile\\sqlbackups\MMOPSEPM\EPM88PRD\EPM88PRD_sqlbackup2005-05-03-15-18-29.sqb Msg 3202, Level 16, State 1, Server MMOPSEPM, Line 1 Write on 'SQLBACKUP_8453389' failed, status = 112. See the SQL Server error log for more details. Msg 3013, Level 16, State 1, Server MMOPSEPM, Line 1 BACKUP DATABASE is terminating abnormally. / comments

5/3/2005 3:18:29 PM: SQL Backup 3.1.0, (c) Red Gate Software Ltd 2004 - 2005 5/3/2005 3:18:29 PM: 5/3/2005 3:18:29 PM: Backing up EPM88PRD (full database) to \\mmofile\\sqlbackups\MMOPSEPM\EPM88PRD...

0 votes

set @strSQL='-SQL "BACKUP DATABASE '+ @strName +' TO DISK = '''+@strPath+@strName+'\'+ @strName +'_sqlbackup'+replace(replace(convert(varchar(50),getdate() ,120),' ','-'),':','-')+'.sqb'' WITH NAME = ''Database '+ @strName +', '+replace(replace(convert(varchar(50),getdate() ,120),' ','-'),':','-')+''', DESCRIPTION = ''Backup on '+ replace(replace(convert(varchar(50),getdate() ,120),' ','-'),':','-')+' Database: '+ @servername +''', ERASEFILES = ' +cast(@intDays as varchar(2)) +', COMPRESSION = 1" -E' the error we see in the log is: SQL Backup 3.1.0, (c) Red Gate Software Ltd 2004 - 2005 Serial number: [REDACTED] Backing up EPM88PRD (full database) to \\mmofile\sqlbackups\MMOPSEPM\EPM88PRD\EPM88PRD_sqlbackup2005-04-27-08-37-42.sqb ... Thread 0 error: Error 620: Error writing to backup file(s). Process terminated unexpectedly. Error code: -2139684860 Msg 3202, Level 16, State 1, Server MMOPSEPM, Line 1 Write on 'SQLBACKUP_201252733' failed, status = 112. See the SQL Server error log for more details. Msg 3013, Level 16, State 1, Server MMOPSEPM, Line 1 BACKUP DATABASE is terminating abnormally. output From the SQL Server logs: BACKUP failed to complete the command BACKUP DATABASE [EPM88PRD] TO VIRTUAL_DEVICE = 'SQLBACKUP_201252733' WITH BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = 'Database EPM88PRD, 2005-04-27-08-37-42', DESCRIPTION = 'Backup on 2005-04-27-08-37-42 Database: EPM88PRD Server: MMOPSEPM', F BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'SQLBACKUP_201252733'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.). Database backed up: Database: UTIL, creation date(time): 2005/04/04(15:30:08), pages dumped: 184, first LSN: 6:280:1, last LSN: 6:282:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'SQLBACKUP_201256829'}). BackupMedium::ReportIoError: write failure on backup device 'SQLBACKUP_201207677'. Operating system error 112(There is not enough space on the disk.). The backup file is approximately 10G, and there is almost 90G free on the network share. / comments

set @strSQL='-SQL "BACKUP DATABASE '+ @strName +' TO DISK = '''+@strPath+@strName+'\'+ @strName +'_sqlbackup'+replace(replace(convert(varchar(50),getdate() ,120),' ','-'),':','-')+'.sqb'' WITH NAME...

0 votes

Error Backing up database to network path

When I try to backup certain databases to a network share, a 1K file gets written, and the log shows the following error. Write on 'SQLBACKUP_108068141' failed, status = 112. See the SQL Server err...

4 followers 18 comments 0 votes

How can we help you today?

MikeShepard

Activity overview