User profile for PDinCA

Hi Peter, Bad DB: EXECUTE master..sqlbackup '-SQL "BACKUP LOG [CustomerData] TO DISK = ''E:\DB_Backups\<database>\<AUTO>.sqb'' WITH ERASEFILES = 2, ERASEFILES_REMOTE = 15, FILEOPTIONS = 4, CHECKSUM, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4, COPYTO = ''\\bk2waspk\sq2waspk_logs'', INIT, THREADCOUNT = 6, VERIFY"' Successful DB on same instance: EXECUTE master..sqlbackup '-SQL "BACKUP LOG [DataBaseSecurity] TO DISK = ''E:\DB_Backups\<database>\<AUTO>.sqb'' WITH ERASEFILES = 15, ERASEFILES_REMOTE = 15, FILEOPTIONS = 4, CHECKSUM, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4, COPYTO = ''\\bk2waspk\sq2waspk_logs'', INIT, THREADCOUNT = 6, VERIFY"' CustomerData (~30MB files, 3 seconds) runs every 15 minutes; DataBaseSecurity (>1MB, > 1 second) every hour. / comments

Hi Peter, Bad DB: EXECUTE master..sqlbackup '-SQL "BACKUP LOG [CustomerData] TO DISK = ''E:\DB_Backups\<database>\<AUTO>.sqb'' WITH ERASEFILES = 2, ERASEFILES_REMOTE = 15, FILEO...

0 votes

Sent another email to ZenDesk in hopes of a response after a three week silence. Update, please? / comments

Sent another email to ZenDesk in hopes of a response after a three week silence. Update, please?

0 votes

eddie davis wrote: Hi Another quick thing to check for, if you have an anti-virus application that performs an on-access or real-time check of a file when it is opened to read, edited or being created. This may prevent SQL Backup reading the backup file header and deleting the backup file if it meets the criteria for deletion. Many Thanks Eddie The odd thing, Eddie, is that of all the database backup being copied, this is the only database experiencing issues, and the UNC location is identical for another database on the same instance. If an Anti-virus tool is interfering, why would it choose just this ONE database's files? / comments

eddie davis wrote: Hi Another quick thing to check for, if you have an anti-virus application that performs an on-access or real-time check of a file when it is opened to read, edited or being c...

0 votes

petey wrote: The next time this happens, could you please run EXEC master..sqbutility 9997 to generate a stack trace file, and send me the file (peter.yeoh@red-gate.com)? This file is named SQBCoreService_<instance name>_bugreport.txt, and is located in ... 'C:\ProgramData\Red Gate\SQL Backup\Log\' on Windows Vista and newer. Having found that the latest (2 minutes after execution) had also failed to delete files, I ran the command on my Windows 8.1 laptop. Having searched for the file on both the SQL Cluster and my Laptop, no such file exists. Please advise. / comments

petey wrote: The next time this happens, could you please run EXEC master..sqbutility 9997 to generate a stack trace file, and send me the file (peter.yeoh@red-gate.com)? This file is named SQB...

0 votes

Only if I restart the SQB Core Service. Restarting appears to release whatever enduring lock the Service retains upon alleged completion of the file transfer. I only dealt with the remote files as they're the only ones cited in any "Completed with warnings" log messages. / comments

Only if I restart the SQB Core Service. Restarting appears to release whatever enduring lock the Service retains upon alleged completion of the file transfer. I only dealt with the remote files as...

0 votes

Thanks, Colin, good news indeed. Cheers! / comments

Thanks, Colin, good news indeed. Cheers!

0 votes

Although Eddie sent me an email to which I replied very swiftly, SILENCE has ensued, sadly... Eddie Davis (Support) Nov 29 09:48 (GMT) Hi This is an undocumented feature which allows SQL Backup users to disable the timeline component of the SQL Backup GUI. By enabling this feature, you may experience improved performance of GUI. If you wish use this feature, please follow the instructions: To disable the time line, close the SQL Backup GUI and add the following registry key on the machine where the GUI is installed: HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\Client (please note, you may need to create the 'Client' folder). Create a new string value called DisableTimelineItemRequests and set the value to = 1 or true Restart the SQL Backup Agent service for each of the registered servers. Open the SQL Backup GUI and see if the performance has improved in populating the registered servers. Once the spinning wheel has stopped, it appears that the registered server is not connected. You will need to expand the registered server to see a successful connection and to see entries in the Activity History. KNOWN ISSUES Upon opening the GUI and once the registered server or servers has completed loading, it appears that the registered server is not connected. You will need to expand the registered server to see a successful connection and to see entries in the Activity History or the other bottom grid items. When navigating through the databases listed for a registered server, you may experience that the entries in the Activity History disappear. Simply click on another server or database and then click back to the original server or database to reload the Activity History or the other bottom grid items. Many Thanks Eddie Davis Technical Support Engineer Red Gate Software Ltd My Reply: Thanks for the info BUT that doesn't address the issue at hand. If you refer to the behavior cited in Profiler, the top pane continues to function with auto-scroll turned off. The lower pane is then static, allowing the user to choose which activities to view. The auto UPDATE of the chronological pane should continue, just DON'T move the lower pane - that is what constitutes a huge time waster when paging through the Activity History, as in: I scroll down to the activity I'm interested in, then, having found the group of backups to investigate, along comes auto-refresh and resets the list to the top - stop THAT! Hope this clarifies. Referring to my final sentence, above, DOES MY REPLY CLARIFY THINGS? Is this thread dead? Is Support Case 8828 dead? This is still causing issues as I cannot research an ongoing remote file erase issue, support case 10148, while this dumb refresh goes on sticking it to me by presenting the latest activity in my face all the time... Yes, Eddie has provided an "undocumented" workaround, but is that the best there is - turn off ALL refresh when only the lower pane refresh should be togglable? Not exactly desirable for everyday usage, IMO. Yes, I'm a bit peevish because I've been using SQL Backup seems like since forever, and this ONE pain in the rear behavior is still a pain in the rear after how many years? Five? Six? Seven? Lost count... "SQL Profiler behaves better than SQL Backup" - is that a statement to live down or what? / comments

Although Eddie sent me an email to which I replied very swiftly, SILENCE has ensued, sadly... Eddie Davis (Support) Nov 29 09:48 (GMT) Hi This is an undocumented feature which allows SQL Backup us...

0 votes

Chris Kelly supplied the following, which worked. These are the workaround steps that have successfully allowed the other users to get installed once they had hit this error message. 1. When you first start the installer, and encounter the Verification error 0x8006010a, please click Yes on the dialog. This encourages the installer to continue with the installation. 2. Once the SQL Monitor installer starts properly, ensure that you select the option Ã¢â‚¬ËœInstall the Web Server on this computer and the Base Monitor on a different computerÃ¢â‚¬â„¢. This means that you will install the two components independently (but you will be able to install both on the same machine despite what the option says). If any further error messages are displayed then ensure that you choose to ignore the error and continue with the installation. 3. Assuming that the WebService component installs successfully then you will be prompted to start SQL Monitor. At this point you will be prompted that there is not an appropriate Base Monitor service to connect to. But the page should display a link to download the Base Monitor service installer. Please do this and run it. 4. If any errors are displayed again please can you handle them in the same way by clicking Continue or Yes to continue with the installation. Ensure that you choose to select your existing SQL Monitor data repository (RedGateMonitor) when prompted. 5. Once complete, ensure both the SQL Monitor WebServer service and the SQL Monitor Base Monitor service are Started. Then refresh or reload the SQL Monitor web page. / comments

Chris Kelly supplied the following, which worked. These are the workaround steps that have successfully allowed the other users to get installed once they had hit this error message. 1. When you fi...

0 votes

I must correct Priya's assertion - I have had this issue since 3.4 came out and TODAY still cannot install and I HAD A CORRUPTED INSTALL THAT REQUIRED A COMPLETE REBUILD OF ALL MY CUSTOMIZED ALERT CONFIGURATIONS. So, be VERY careful if you get this error. From my email to support today, December 3rd, 2013: I have been able to completely DISABLE the Sophos Anti-Virus services. I downloaded a fresh SQL Monitor 3.5 installer and the SAME 0x800b0110 error occurred. I downloaded the very latest SQL Toolbelt and the exact same error occurs on firing up the SQL Toolbelt installer. I am completely unable to install ANY version after 3.3 on the Server. Incident F0074068 was the original ID - I hope it is still open and that someone from Red Gate can sort this out as I'm NOT getting the upgrades paid for! Assistance hereby requested once more. Thanks in advance. / comments

I must correct Priya's assertion - I have had this issue since 3.4 came out and TODAY still cannot install and I HAD A CORRUPTED INSTALL THAT REQUIRED A COMPLETE REBUILD OF ALL MY CUSTOMIZED ALERT ...

0 votes

Took the alternative and I'm good to go. Many thanks Peter / comments

Took the alternative and I'm good to go. Many thanks Peter

0 votes

How can we help you today?

PDinCA

Comments