How can we help you today? How can we help you today?
MikeShepard
Activity overview Badges (0) Posts (3) Comments (6)

Comments

Sort by recent activity
That was a typo. I fixed the parameter and got the same error message (except that the path was correct) / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Error Backing up database to network path
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
  1. Community
  2. SQL Backup Previous Versions
  3. Error Backing up database to network path
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
  1. Community
  2. SQL Backup Previous Versions
  3. Error Backing up database to network path
set @strSQL='-SQL "BACKUP DATABASE '+ @strName +' TO DISK = '''+@strPath+@strName+'\'+ @strName +'_sqlbackup'+replace(replace(convert(varchar(50),getdate() ,120),' ','-'),':','-')+'.sqb'' WITH NAME...
0 votes
Same results using local install of server components (as opposed to the remote install) / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Error backing up
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
  1. Community
  2. SQL Backup Previous Versions
  3. Error backing up
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
  1. Community
  2. SQL Backup Previous Versions
  3. Error backing up
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
Total activity
11
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2