Activity overview
Latest activity by charleyevans
eddie davis wrote:
If you are ever unsure of the SQL Backup log file path, always check the server options via the SQL Backup GUI:
Right Click Registered Server ->Select options... from the menu that appears. File Management Tab _>SQL Backup log files section, the Log file folder text box will contain the path to the SQL Backup Log files.
Many Thanks
Eddie
Thanks Eddie, that is actually what I stumbled across and how I found it out.
Cheers! / comments
eddie davis wrote:
If you are ever unsure of the SQL Backup log file path, always check the server options via the SQL Backup GUI:
Right Click Registered Server ->Select options... from the menu...
Someone had placed it in an odd location. / comments
Someone had placed it in an odd location.
Location of SQL Backup Logs on Windows 2008 Server?
Hello,
I am trying to locate the SQL Backup Logs for a Windows Server 2008 R2 Enterprise x64 installation of SQL Backup 6.4.0.56. These logs are found on a Windows 2003 Server installation of SQL ...
Index out of bounds in the array
Hello,
I am running into an error in the trial version of Compare v6 and our fully licensed v5. From what I can gather we run into this error due to the length of the strings in our SQL CLR Assemb...
Sporadic VDI error 1010
Hello,
This error occurs sporadically on our SQL 2005 EE x64 server."VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the S...
This ended up being a permissions issue, as I first suspected. The backup service agent account had full permissions on the share, but not on the physical drive. Once full permissions to the drive were granted, things started working. Thanks for all of your help. It led me down the path I needed. / comments
This ended up being a permissions issue, as I first suspected. The backup service agent account had full permissions on the share, but not on the physical drive. Once full permissions to the driv...
Yes, it should have. Also, interestingly enough, when I run the command using xp_CmdShell I get the same error as when it is run through the red gate sp. I am going to expirement and see if I can get a job to run the batch file. / comments
Yes, it should have. Also, interestingly enough, when I run the command using xp_CmdShell I get the same error as when it is run through the red gate sp. I am going to expirement and see if I can...
That worked fine from the command line. The file was erased and the backup was successful. The odd thing here is that the same account has been used throughout this entire process. / comments
That worked fine from the command line. The file was erased and the backup was successful. The odd thing here is that the same account has been used throughout this entire process.
Brian,
Normally, we just look for anything older than a day to erase. In order to test things, I've been using 1 hour instead. There are no other processes touching this share. So no there is not another backup job that it is competing with. That was my first inclination was I/O contention, followed by account permissions.
Peter,
This is the log...
SQL Backup log file
12/7/2006 12:51:09 PM: Backing up Dev (transaction log) to:
\\server\share\LOG_(local)_Dev_20061207_125109.sqb
12/7/2006 12:51:09 PM: BACKUP LOG [Dev] TO DISK = '\\server\share\LOG_(local)_Dev_20061207_125109.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', ERASEFILES = 1h, COMPRESSION = 1, THREADS = 1
12/7/2006 12:51:10 PM: Backup data size : 832.000 KB
12/7/2006 12:51:10 PM: Compressed data size: 10.000 KB
12/7/2006 12:51:10 PM: Compression rate : 98.80%
Processed 0 pages for database 'Dev', file 'Dev_log' on file 1.
BACKUP LOG successfully processed 0 pages in 0.014 seconds (0.000 MB/sec).
12/7/2006 12:51:12 PM: Deleting old backup file: \\server\share\LOG_(local)_Dev_20061206_123003.sqb
12/7/2006 12:51:13 PM: Warning 160: ERASEFILES error: Failed to delete file: \\server\share\\LOG_(local)_Dev_20061206_123003.sqb.
Of course, I've changed the name of the database and the file paths to something generic. Otherwise, this is exactly what we're seeing.
Thanks for any help you can provide. / comments
Brian,
Normally, we just look for anything older than a day to erase. In order to test things, I've been using 1 hour instead. There are no other processes touching this share. So no there is no...
REPOST: Deleting backups on a share
I noticed that I can create backups using the UNC path to the share, as described in one of the stickies in this forum. However, I've seen that I receive a 160 Error, unable to delete backups when ...