What are the challenges you face when working across database platforms? Take the survey
Options

trouble backing up 1 of my servers

I am backing up two slq servers using the redgate backup solution. on server backs up just fine with no problems. The other server keeps getting the error (Failed to create output folder: 'folder name'. the folder already exist and the user being used to access the server and back it up has full control over the folder.



SQL Backup log file 9.1.4.177

-SQL "BACKUP DATABASES [TG,VWDB] TO DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\<AUTO>.sqb' WITH ERASEFILES = 9, CHECKSUM, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4, FILECOUNT = 2 "

ERRORS AND WARNINGS


11/6/2017 9:33:34 AM: Backing up TG (full database) to:
11/6/2017 9:33:34 AM: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\FULL_(local)_TG_20171106_093334_01.sqb
11/6/2017 9:33:34 AM: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\FULL_(local)_TG_20171106_093334_02.sqb

11/6/2017 9:33:34 AM: BACKUP DATABASE [TG] TO VIRTUAL_DEVICE = 'SQLBACKUP_5DA78D0D-3784-4C0C-8921-0CF1AA8F92DC', VIRTUAL_DEVICE = 'SQLBACKUP_5DA78D0D-3784-4C0C-8921-0CF1AA8F92DC01' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME
= N'Database (TG), 11/6/2017 9:33:34 AM', DESCRIPTION = N'Backup on 11/6/2017 9:33:34 AM Server: ECMPSQL3 Database: TG', FORMAT, CHECKSUM

11/6/2017 9:34:04 AM: VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. Check that the SQL Server instance is running, that you have the SQL Server System Administrator server role; and that no other
processes are blocking the backup or restore process; or try increasing the value of the VDITimeout registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\[InstanceName]
11/6/2017 9:34:04 AM:
11/6/2017 9:34:04 AM: SPID Status Login HostName BlkBy DBName Command CPUTime DiskIO LastBatch ProgramName SPID_1
REQUESTID
11/6/2017 9:34:04 AM:












11/6/2017 9:34:04 AM: 1 BACKGROUND sa . . LOG WRITER 187 0 11/04 20:45:30 1 0

11/6/2017 9:34:04 AM: 2 BACKGROUND sa . . RECOVERY WRITER 0 0 11/04 20:45:30 2 0

11/6/2017 9:34:04 AM: 3 BACKGROUND sa . . LAZY WRITER 31 0 11/04 20:45:30 3 0

11/6/2017 9:34:04 AM: 4 BACKGROUND sa . . LAZY WRITER 0 0 11/04 20:45:30 4 0

11/6/2017 9:34:04 AM: 5 BACKGROUND sa . . master SIGNAL HANDLER 0 0 11/04 20:45:30 5 0

11/6/2017 9:34:04 AM: 6 BACKGROUND sa . . LOCK MONITOR 0 0 11/04 20:45:30 6 0

11/6/2017 9:34:04 AM: 7 BACKGROUND sa . . master BRKR TASK 0 0 11/04 20:45:30 7 0

11/6/2017 9:34:04 AM: 8 sleeping sa . . master TASK MANAGER 0 0 11/04 20:45:30 8 0

11/6/2017 9:34:04 AM: 9 BACKGROUND sa . . RESOURCE MONITOR 0 0 11/04 20:45:30 9 0

11/6/2017 9:34:04 AM: 10 BACKGROUND sa . . RESOURCE MONITOR 1203 0 11/04 20:45:30 10 0

11/6/2017 9:34:04 AM: 11 BACKGROUND sa . . XE TIMER 0 0 11/04 20:45:30 11 0

11/6/2017 9:34:04 AM: 12 BACKGROUND sa . . XE DISPATCHER 0 0 11/04 20:45:30 12 0

11/6/2017 9:34:04 AM: 13 BACKGROUND sa . . master TRACE QUEUE TASK 0 0 11/04 20:45:30 13 0

11/6/2017 9:34:04 AM: 14 BACKGROUND sa . . SYSTEM_HEALTH_MO 0 0 11/04 20:45:30 14 0

11/6/2017 9:34:04 AM: 15 BACKGROUND sa . . RECEIVE 0 2 11/04 20:45:30 15 0

11/6/2017 9:34:04 AM: 16 BACKGROUND sa . . master TASK MANAGER 15 7 11/04 20:45:30 16 0

11/6/2017 9:34:04 AM: 17 BACKGROUND sa . . master CHECKPOINT 15 0 11/04 20:45:30 17 0

11/6/2017 9:34:04 AM: 18 sleeping sa . . master TASK MANAGER 0 0 11/06 09:20:43 18 0

11/6/2017 9:34:04 AM: 19 sleeping sa . . master TASK MANAGER 0 0 11/06 09:12:52 19 0

11/6/2017 9:34:04 AM: 20 sleeping sa . . master TASK MANAGER 0 0 11/06 09:03:50 20 0

11/6/2017 9:34:04 AM: 22 sleeping sa . . master TASK MANAGER 0 0 11/06 09:25:44 22 0

11/6/2017 9:34:04 AM: 23 sleeping sa . . master TASK MANAGER 0 1 11/06 09:13:42 23 0

11/6/2017 9:34:04 AM: 24 sleeping sa . . master TASK MANAGER 0 0 11/06 09:26:44 24 0

11/6/2017 9:34:04 AM: 25 sleeping sa . . master TASK MANAGER 0 0 11/06 09:13:42 25 0

11/6/2017 9:34:04 AM: 26 sleeping sa . . master TASK MANAGER 0 0 11/06 09:21:43 26 0

11/6/2017 9:34:04 AM: 27 sleeping sa . . master TASK MANAGER 0 3 11/06 09:14:42 27 0

11/6/2017 9:34:04 AM: 28 sleeping sa . . master TASK MANAGER 0 0 11/06 09:14:42 28 0

11/6/2017 9:34:04 AM: 29 sleeping sa . . master TASK MANAGER 0 0 11/06 09:06:41 29 0

11/6/2017 9:34:04 AM: 30 BACKGROUND sa . . master BRKR EVENT HNDLR 0 40 11/04 20:45:30 30 0

11/6/2017 9:34:04 AM: 31 BACKGROUND sa . . master BRKR TASK 0 0 11/04 20:45:30 31 0

11/6/2017 9:34:04 AM: 32 BACKGROUND sa . . master BRKR TASK 0 0 11/04 20:45:30 32 0

11/6/2017 9:34:04 AM: 33 BACKGROUND sa . . master BRKR TASK 15 0 11/04 20:45:30 33 0

11/6/2017 9:34:04 AM: 34 sleeping sa . . master TASK MANAGER 0 0 11/06 09:15:42 34 0

11/6/2017 9:34:04 AM: 35 sleeping sa . . master TASK MANAGER 0 0 11/06 09:16:43 35 0

11/6/2017 9:34:04 AM: 51 sleeping GCDSQLUser ecmpcpe1 . GCD AWAITING COMMAND 173 0 11/06 09:33:16 Microsoft JDBC Driver for SQL Server 51 0

11/6/2017 9:34:04 AM: 52 sleeping PACIFIC\SQLADMIN ECMPSQL3 . msdb AWAITING COMMAND 62 99 11/06 09:33:33 SQLAgent - Generic Refresher 52 0

11/6/2017 9:34:04 AM: 53 sleeping p8sqluser ecmpcpe1 . P8Admin AWAITING COMMAND 155 0 11/06 09:33:21 Microsoft JDBC Driver for SQL Server 53 0

11/6/2017 9:34:04 AM: 54 sleeping PACIFIC\PAWXP ECMPSQL3 . master AWAITING COMMAND 32 0 11/06 09:28:53 Microsoft SQL Server Management Studio 54 0

11/6/2017 9:34:04 AM: 55 sleeping CMDUser ecmpcpe1 . CMDesignDB AWAITING COMMAND 2103 78 11/06 09:33:58 Microsoft JDBC Driver for SQL Server 55 0

11/6/2017 9:34:04 AM: 56 sleeping FPUser ecmpcpe1 . FilePlanDB AWAITING COMMAND 0 0 11/06 09:33:40 Microsoft JDBC Driver for SQL Server 56 0

11/6/2017 9:34:04 AM: 57 sleeping TGDBSQLUser ecmpcpe1 . TG AWAITING COMMAND 390 286 11/06 09:33:34 Microsoft JDBC Driver for SQL Server 57 0

11/6/2017 9:34:04 AM: 58 RUNNABLE PACIFIC\SQLADMIN ECMPSQL3 . master EXECUTE 0 0 11/06 09:33:34 SQLAgent - TSQL JobStep (Job 0x838A2DCD9679584ABB79E357EFF9DA91 : Step 1) 58 0

11/6/2017 9:34:04 AM: 59 sleeping sa ECMPSQL3 . master AWAITING COMMAND 1408 1 11/06 09:32:20 SQBCoreService.exe 59 0

11/6/2017 9:34:04 AM: 60 sleeping p8sqluser ecmpcpe1 . P8Admin AWAITING COMMAND 1626 382 11/06 09:33:56 Microsoft JDBC Driver for SQL Server 60 0

11/6/2017 9:34:04 AM: 61 sleeping CMDUser ecmpcpe1 . CMDesignDB AWAITING COMMAND 217 0 11/06 09:33:15 Microsoft JDBC Driver for SQL Server 61 0

11/6/2017 9:34:04 AM: 62 sleeping CMTUser ecmpcpe1 . CMTargetDB AWAITING COMMAND 280 0 11/06 09:33:21 Microsoft JDBC Driver for SQL Server 62 0

11/6/2017 9:34:04 AM: 63 sleeping ICNDBSQLUser ecmpcpe1 . ICNDB2 AWAITING COMMAND 1119 13 11/06 09:33:50 Microsoft JDBC Driver for SQL Server 63 0

11/6/2017 9:34:04 AM: 64 sleeping CMTUser ecmpcpe1 . CMTargetDB AWAITING COMMAND 48 0 11/06 09:33:56 Microsoft JDBC Driver for SQL Server 64 0

11/6/2017 9:34:04 AM: 65 sleeping FPUser ecmpcpe1 . FilePlanDB AWAITING COMMAND 187 0 11/06 09:33:16 Microsoft JDBC Driver for SQL Server 65 0

11/6/2017 9:34:04 AM: 66 sleeping VWDBSqlUser ecmpae1 . VWDB AWAITING COMMAND 329 197 11/06 09:33:19 Microsoft JDBC Driver for SQL Server 66 0

11/6/2017 9:34:04 AM: 67 sleeping GCDSQLUser ecmpcpe1 . GCD AWAITING COMMAND 735 0 11/06 09:33:16 Microsoft JDBC Driver for SQL Server 67 0

11/6/2017 9:34:04 AM: 68 sleeping PACIFIC\PAWXP CORPUTIL2 . master AWAITING COMMAND 0 0 11/06 09:33:33 SQL Backup 68 0

11/6/2017 9:34:04 AM: 69 sleeping TGDBSQLUser ecmpcpe1 . TG AWAITING COMMAND 1095 27736 11/06 09:33:21 Microsoft JDBC Driver for SQL Server 69 0

11/6/2017 9:34:04 AM: 70 sleeping p8sqluser ecmpcpe1 . P8Admin AWAITING COMMAND 766 0 11/06 09:33:21 Microsoft JDBC Driver for SQL Server 70 0

11/6/2017 9:34:04 AM: 71 sleeping CMDUser ecmpcpe1 . CMDesignDB AWAITING COMMAND 684 4 11/06 09:33:15 Microsoft JDBC Driver for SQL Server 71 0

11/6/2017 9:34:04 AM: 72 sleeping TGDBSQLUser ecmpcpe1 . TG AWAITING COMMAND 831 0 11/06 09:33:21 Microsoft JDBC Driver for SQL Server 72 0

11/6/2017 9:34:04 AM: 73 RUNNABLE sa ECMPSQL3 . master SELECT INTO 125 5 11/06 09:33:34 SQBCoreService.exe 73 0

11/6/2017 9:34:04 AM: 74 sleeping PACIFIC\SQLADMIN ECMPSQL3 . msdb AWAITING COMMAND 0 81 11/06 02:00:00 SQLAgent - Job invocation engine 74 0

11/6/2017 9:34:04 AM: 75 sleeping PACIFIC\SQLADMIN ECMPSQL3 . msdb AWAITING COMMAND 0 0 11/04 20:45:32 SQLAgent - Email Logger 75 0

11/6/2017 9:34:04 AM: 76 sleeping CMTUser ecmpcpe1 . CMTargetDB AWAITING COMMAND 745 0 11/06 09:33:21 Microsoft JDBC Driver for SQL Server 76 0

11/6/2017 9:34:04 AM: 77 sleeping FPUser ecmpcpe1 . FilePlanDB AWAITING COMMAND 692 0 11/06 09:33:16 Microsoft JDBC Driver for SQL Server 77 0

11/6/2017 9:34:04 AM: 78 sleeping GCDSQLUser ecmpcpe1 . GCD AWAITING COMMAND 0 0 11/06 09:33:21 Microsoft JDBC Driver for SQL Server 78 0

11/6/2017 9:34:04 AM: 79 sleeping PACIFIC\PAWXP CORPUTIL2 . master AWAITING COMMAND 0 0 11/06 09:33:33 SQL Backup 79 0

11/6/2017 9:34:04 AM: 80 sleeping bp8 ecmpae1 . Bp8Metastore AWAITING COMMAND 217 40 11/06 09:33:19 Microsoft JDBC Driver for SQL Server 80 0

11/6/2017 9:34:04 AM: 81 sleeping VWDBSqlUser ecmpcpe1 . VWDB AWAITING COMMAND 174 0 11/06 09:34:04 Microsoft JDBC Driver for SQL Server 81 0

11/6/2017 9:34:04 AM: 82 sleeping TGDBSQLUser ecmpcpe1 . TG AWAITING COMMAND 15 14 11/06 09:33:21 Microsoft JDBC Driver for SQL Server 82 0

11/6/2017 9:34:04 AM: 83 sleeping VWDBSqlUser ecmpcpe1 . VWDB AWAITING COMMAND 111 303 11/06 09:33:36 Microsoft JDBC Driver for SQL Server 83 0

11/6/2017 9:34:04 AM: 84 sleeping VWDBSqlUser ecmpcpe1 . VWDB AWAITING COMMAND 61 0 11/06 09:33:36 Microsoft JDBC Driver for SQL Server 84 0

11/6/2017 9:34:04 AM: 85 SUSPENDED sa ECMPSQL3 . TG BACKUP DATABASE 16 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 RUNNABLE ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 85 SUSPENDED ECMPSQL3 . TG BACKUP DATABASE 2147483647 0 11/06 09:32:20 SQBCoreService.exe 85 0

11/6/2017 9:34:04 AM: 86 sleeping VWDBSqlUser ecmpcpe1 . VWDB AWAITING COMMAND 841 128 11/06 09:34:04 Microsoft JDBC Driver for SQL Server 86 0

11/6/2017 9:34:04 AM: 87 SUSPENDED sa ECMPSQL3 85 TG BACKUP DATABASE 0 0 11/06 09:33:34 SQBCoreService.exe 87 0

11/6/2017 9:34:04 AM: 88 sleeping GCDSQLUser ecmpcpe1 . GCD AWAITING COMMAND 0 0 11/06 09:33:52 Microsoft JDBC Driver for SQL Server 88 0

11/6/2017 9:34:04 AM: 89 RUNNABLE PACIFIC\PAWXP CORPUTIL2 . master EXECUTE 0 0 11/06 08:37:17 SQL Backup 89 0

11/6/2017 9:34:04 AM: 90 sleeping PACIFIC\PAWXP CORPUTIL2 . master AWAITING COMMAND 0 0 11/06 09:33:24 SQL Backup 90 0

11/6/2017 9:34:04 AM: 91 sleeping ICNDBSQLUser ecmpae1 . ICNDB AWAITING COMMAND 0 0 11/06 09:33:55 Microsoft JDBC Driver for SQL Server 91 0

11/6/2017 9:34:04 AM: 92 sleeping VWDBSqlUser ecmpcpe1 . VWDB AWAITING COMMAND 0 0 11/06 09:34:04 Microsoft JDBC Driver for SQL Server 92 0

11/6/2017 9:34:04 AM: 94 sleeping VWDBSqlUser ecmpcpe1 . VWDB AWAITING COMMAND 62 168 11/06 09:33:21 Microsoft JDBC Driver for SQL Server 94 0

11/6/2017 9:34:04 AM: 95 sleeping VWDBSqlUser ecmpcpe1 . VWDB AWAITING COMMAND 78 0 11/06 09:33:21 Microsoft JDBC Driver for SQL Server 95 0

11/6/2017 9:34:04 AM: 96 sleeping TGDBSQLUser ecmpcpe1 . TG AWAITING COMMAND 16 304 11/06 09:33:21 Microsoft JDBC Driver for SQL Server 96 0

11/6/2017 9:34:04 AM: 97 sleeping TGDBSQLUser ecmpcpe1 . TG AWAITING COMMAND 61 0 11/06 09:33:21 Microsoft JDBC Driver for SQL Server 97 0

11/6/2017 9:34:04 AM: 98 sleeping FPUser ecmpcpe1 . FilePlanDB AWAITING COMMAND 0 0 11/06 09:33:15 Microsoft JDBC Driver for SQL Server 98 0

11/6/2017 9:34:04 AM: 99 sleeping CMTUser ecmpcpe1 . CMTargetDB AWAITING COMMAND 0 0 11/06 09:33:16 Microsoft JDBC Driver for SQL Server 99 0

11/6/2017 9:34:04 AM:
11/6/2017 9:37:50 AM: SQL error 3013: BACKUP DATABASE is terminating abnormally.
11/6/2017 9:37:50 AM: SQL error 3201: Cannot open backup device 'SQLBACKUP_5DA78D0D-3784-4C0C-8921-0CF1AA8F92DC'. Operating system error 0x80070002(The system cannot find the file specified.).
11/6/2017 9:37:50 AM:
11/6/2017 9:37:51 AM: Memory profile
11/6/2017 9:37:51 AM: Type Maximum Minimum Average Blk count Total
11/6/2017 9:37:51 AM:





11/6/2017 9:37:51 AM: Commit 20871774208 4096 5486806 11280 61891174400
11/6/2017 9:37:51 AM: Reserve 8590000128 4096 4686129 4212 19737976832
11/6/2017 9:37:51 AM: Free 8677900001280 4096 2022386587 4309 8714463805440
11/6/2017 9:37:51 AM: Private 20871774208 4096 5539949 14699 81431711744
11/6/2017 9:37:51 AM: Mapped 2969600 4096 172506 69 11902976
11/6/2017 9:37:51 AM: Image 31768576 4096 256265 724 185536512
11/6/2017 9:37:51 AM:
11/6/2017 9:37:51 AM: Warning 300: Backup failed. Retry attempt: 1
11/6/2017 9:37:53 AM: BACKUP DATABASE [TG] TO VIRTUAL_DEVICE = 'SQLBACKUP_9A754889-5581-4163-AF1C-F78FC71239C6', VIRTUAL_DEVICE = 'SQLBACKUP_9A754889-5581-4163-AF1C-F78FC71239C601' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 524288, NAME
= N'Database (TG), 11/6/2017 9:33:34 AM', DESCRIPTION = N'Backup on 11/6/2017 9:33:34 AM Server: ECMPSQL3 Database: TG', FORMAT, CHECKSUM

11/6/2017 9:43:23 AM: Thread 0 error:
Error 605: Error creating backup file(s). No files could be created.
11/6/2017 9:43:23 AM: Warning 200: Thread 0 warning:
11/6/2017 9:37:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:38:23 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:38:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:39:23 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:39:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:40:23 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:40:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:41:23 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:41:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:42:23 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:42:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:43:23 AM:
11/6/2017 9:43:23 AM: Thread 1 error:
Error 605: Error creating backup file(s). No files could be created.
11/6/2017 9:43:23 AM: Warning 200: Thread 1 warning:
11/6/2017 9:37:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:38:23 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:38:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:39:23 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:39:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:40:23 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:40:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:41:23 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:41:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:42:23 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:42:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:43:23 AM:
11/6/2017 9:43:23 AM: SQL error 3013: BACKUP DATABASE is terminating abnormally.
11/6/2017 9:43:23 AM: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_9A754889-5581-4163-AF1C-F78FC71239C6:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
11/6/2017 9:43:23 AM: SQL error 3202: Write on "SQLBACKUP_9A754889-5581-4163-AF1C-F78FC71239C6" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)

11/6/2017 9:43:23 AM: Backing up VWDB (full database) to:
11/6/2017 9:43:23 AM: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\FULL_(local)_VWDB_20171106_094323_01.sqb
11/6/2017 9:43:23 AM: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\FULL_(local)_VWDB_20171106_094323_02.sqb

11/6/2017 9:43:23 AM: BACKUP DATABASE [VWDB] TO VIRTUAL_DEVICE = 'SQLBACKUP_89C71449-2729-4734-BF85-9ADE57C7F3FA', VIRTUAL_DEVICE = 'SQLBACKUP_89C71449-2729-4734-BF85-9ADE57C7F3FA01' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576,
NAME = N'Database (VWDB), 11/6/2017 9:43:23 AM', DESCRIPTION = N'Backup on 11/6/2017 9:43:23 AM Server: ECMPSQL3 Database: VWDB', FORMAT, CHECKSUM

11/6/2017 9:48:54 AM: Thread 0 error:
Error 605: Error creating backup file(s). No files could be created.
11/6/2017 9:48:54 AM: Warning 200: Thread 0 warning:
11/6/2017 9:43:23 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:43:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:44:23 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:44:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:45:23 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:45:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:46:24 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:46:54 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:47:24 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:47:54 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:48:24 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:48:54 AM:
11/6/2017 9:48:54 AM: Thread 1 error:
Error 605: Error creating backup file(s). No files could be created.
11/6/2017 9:48:54 AM: Warning 200: Thread 1 warning:
11/6/2017 9:43:23 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:43:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:44:23 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:44:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:45:23 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:45:53 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:46:24 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:46:54 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:47:24 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:47:54 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:48:24 AM: Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
Warning 480: Failed to create output folder: D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.
11/6/2017 9:48:54 AM:
11/6/2017 9:48:54 AM: SQL error 3013: BACKUP DATABASE is terminating abnormally.
11/6/2017 9:48:54 AM: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_89C71449-2729-4734-BF85-9ADE57C7F3FA:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
11/6/2017 9:48:54 AM: SQL error 3202: Write on "SQLBACKUP_89C71449-2729-4734-BF85-9ADE57C7F3FA" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)


Tagged:

Answers

  • Options
    Hi Bill,

    A good spot from the developer that I missed

    I think the error is because there is a full stop at the end of the path, which makes it invalid i.e.

    D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\RedGate\.

    Further:

    Also, I think he may have 2 backup jobs running simultaneously for the same database - process 87 (a SQL Backup backup process) is being blocked by process 85 (another SQL Backup backup process) in the log he sent.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
Sign In or Register to comment.