Activity overview
Latest activity by wilsonc
In an attempt to handle this differently I created a DNS alias and pointed the server to the alias instead. I find that when running against an alias the job fails as well. It sits in a running state until it eventually times out.
What check is occurring during this job that would prevent the job from running against an alias name? I am able to navigate to manipulate folders in the target path via the alias so it is able to see and connect to it. / comments
In an attempt to handle this differently I created a DNS alias and pointed the server to the alias instead. I find that when running against an alias the job fails as well. It sits in a running sta...
This an error that was spit out when attempting to backup to the dfs path. When using the path directly, ie \\remoteserver\share with the same credentials it works correctly.
These errors are generated for all databases the job encompasses.
ERRORS AND WARNINGS
1/18/2010 10:04:11 AM: Backing up master (full database) to:
1/18/2010 10:04:11 AM: \\adms_nt\shares\SQLBackups\DIF\SERVERNAME\SYSTEM\FULL_master_20100118_100411.sqb
1/18/2010 10:04:12 AM: BACKUP DATABASE [master] TO VIRTUAL_DEVICE = 'SQLBACKUP_A6C4AD78-EBC2-4BF4-98B5-88110589C550', VIRTUAL_DEVICE = 'SQLBACKUP_A6C4AD78-EBC2-4BF4-98B5-88110589C55001' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (master), 1/18/2010 10:04:11 AM', DESCRIPTION = N'Backup on 1/18/2010 10:04:11 AM Server: SERVERNAME Database: master', FORMAT
1/18/2010 10:04:18 AM: Thread 1 error: Backup error: Division by zero
See error details in log file: C:\ProgramData\Red Gate\SQL Backup\Log\SQBCoreService_(LOCAL)_bugreport.txt
1/18/2010 10:04:18 AM:
1/18/2010 10:04:18 AM: SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
1/18/2010 10:04:18 AM: SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_A6C4AD78-EBC2-4BF4-98B5-88110589C55001:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
1/18/2010 10:04:18 AM: Processed 376 pages for database 'master', file 'master' on file 1.
1/18/2010 10:04:18 AM: Processed 3 pages for database 'master', file 'mastlog' on file 1.
/ comments
This an error that was spit out when attempting to backup to the dfs path. When using the path directly, ie \\remoteserver\share with the same credentials it works correctly.
These errors are gener...
we tried manually specifying different user credentials with the same result. The permissions on the share are the same directly or through dfs. I will post an error log when back in the office tomorrow. / comments
we tried manually specifying different user credentials with the same result. The permissions on the share are the same directly or through dfs. I will post an error log when back in the office tom...
SQL Backup 6 with DFS Share
Hey Guys,
We have been using SQL Backup 6 for the past couple months with great success. Today we tried pointing it to a dfs share and it fails while creating a backup. It only fails while writing ...
Off-Host Backups
I have not installed or tested the software myself yet due to lack of time, but a couple dba's in our company are telling me that when doing the backups, the backups are created locally on the SQL ...