Comments
Sort by recent activity
Thank you for your post into the forum.
Can you please confirm the excat version of SQL Backup you are using?
On the next occasion that the restore job hangs or goes unresponsive, please type in a new query window in SSMS or Query Analyzer: execute master..sqbutility 9997
The above makes use of the SQL Backup SQBUtility Extended Stored Procedure. This function will provide a debugging trace of the current execution process in the SQL Backup engine.
Executing sqbutility 9997 will return a NULL value and generate a file in the named directory for the corresponding SQL Backup Agent (eg by default, C:\Program files\Red Gate\SQL Backup\%instance%, called "SQBCoreService_bugreport.txt"
Please send the resulting debug file to support@red-gate.com and include the following call reference number in the subject field on the e-mail, F0024980.
Many Thanks
Eddie[/code] / comments
Thank you for your post into the forum.
Can you please confirm the excat version of SQL Backup you are using?
On the next occasion that the restore job hangs or goes unresponsive, please type in a ...
Thank you for your post into the forum.
A feature request has been submitted for the development team to consider. The reference for this request is DT-567.
We cannot guarantee the success of the feature request submitted. Or if approval is given, what future version of SQL Dependency Tracker the feature will appear in.
We will be maintaining a watch on the feature request submitted and will update this forum post when any changes occur.
Thank you once again for your suggestion.
Many Thanks
Eddie / comments
Thank you for your post into the forum.
A feature request has been submitted for the development team to consider. The reference for this request is DT-567.
We cannot guarantee the success of the ...
Thank you for your reply and excellent news that SQL Prompt 4 has resolved your table hints issue.
I will now close the support call created. Please do contact us if you need our help and assistance in the future.
Many Thanks
Eddie / comments
Thank you for your reply and excellent news that SQL Prompt 4 has resolved your table hints issue.
I will now close the support call created. Please do contact us if you need our help and assistan...
Thank you for your post into the forum.
SQL Prompt 3.* does not prompt the table hints.
I will check with the SQL Prompt development team to see if this is still the case in new version of SQL Prompt, version 4 that is to be released within the next couple of weeks.
If not I will create a feature request to add this functionality.
Many Thanks
Eddie / comments
Thank you for your post into the forum.
SQL Prompt 3.* does not prompt the table hints.
I will check with the SQL Prompt development team to see if this is still the case in new version of SQL Prom...
Hi
You will be pleased to read that this problem is resolved in SQL Prompt V4 due to be released within the next 10 to 14 days.
I will update this forum post upon the release of SQL Prompt V4.
Many Thanks
Eddie / comments
Hi
You will be pleased to read that this problem is resolved in SQL Prompt V4 due to be released within the next 10 to 14 days.
I will update this forum post upon the release of SQL Prompt V4.
Many...
Thank you for your post into the forum.
On the SQL Server, to remove or uninstall the SQL Backup Server components, from the Control Panel ->Select Add / Remove Programs.
Locate the entry for SQL Backup 5 (server components) or for a named instance SQL Backup 5-<Instance Name> (server components). Click the Change/Remove button and remove the server components installed.
Please note if you have the SQL Backup GUI installed on the same machine, you will have two entries in 'Add / Remove Programs'.
SQL Backup 5 This will for the SQL Backup GUI
SQL Backup 5 (server components) This will be for the SQL Backup Server Components. It is the SQL Backup Server Components that installs and creates the SQL Backup Agent Service.
Once you have removed the SQL Backup Server Components, manually delete any left behind Server Components installation folder from:
C:\ Program Files\Red Gate\SQL Backup\(local) for a default instance
or
C:\ Program Files\Red Gate\SQL Backup\<Instance Name> for a named instance
Delete just the (local) or <Instance Name> folder if you have the SQL Backup GUI installed on the same machine.
On a machine with the SQL Backup GUI installed, locate a file called SQBServerSetup.exe from the C:\ Program Files\Red Gate\SQL Backup directory. Copy the file to the SQL Server and run the executable. If the GUI is already installed on the SQL Server, simply run the SQBServerSetup.exe file. Follow the on screen instructions. This action will reinstall the SQL Backup Server Components and recreate the SQL Backup Agent service.
I hope the above information helps. / comments
Thank you for your post into the forum.
On the SQL Server, to remove or uninstall the SQL Backup Server components, from the Control Panel ->Select Add / Remove Programs.
Locate the entry for SQL B...
Thank you for your post into the forum.
Do you have an further information regarding the objects envolved in the circular dependency or dependencies?
I have known this problem to occur if you have update triggers enabled that cause actions that come back to the original object to be updated.
If you edit the project and select the options tab. Please enable the options to Disable DML Triggers and Disable DDL Triggers in the Synchronization Behavior Section.
Hope this helps.
Many Thanks
Eddie / comments
Thank you for your post into the forum.
Do you have an further information regarding the objects envolved in the circular dependency or dependencies?
I have known this problem to occur if you have ...
Thank you for your post into the forum.
I am sure that other SQL Snapper users will find this information useful.
For those user's who are aware of SQL Snapper - SQL Snapper is a free utility that creates a SQL Compare schema snapshot of a SQL Server 2000, 2005 or 2008 database. This snapshot can then be used as a database source in Red Gate’s SQL Compare.
Further information regarding SQL Snapper can be found using this LINK.
Many Thanks
Eddie / comments
Thank you for your post into the forum.
I am sure that other SQL Snapper users will find this information useful.
For those user's who are aware of SQL Snapper - SQL Snapper is a free utility that ...
Thank you for your post into the forum.
This part of the error message: Warning: System error 121 (The semaphore timeout period has expired), indicates a network error or problem occured during the backup process. So the connection was lost to the network share.
This could be a connectivity issue where:
Network adapters and switch ports have mismatching duplex levels or transfer speed settings.
Network adapters or switches with transmission rates of 10/100 megabits per second (Mbps) do not switch over correctly. Some autosense settings may not correctly detect the speed of some network adapters.
The network adapter is incompatible with the motherboard or other hardware or software components and drivers.
Another possible cause is that the server performing the backup did not enough free resources or was busy and could not respond to the semaphore before timing out.
Another possible cause is that the amount of data placed onto the network that SQL Backup outputs onto the network. SQL Backup writes out the compressed data in blocks of 4MB by default. Unfortunately, on some networks this fails.
To get around this issue the user must specify the MAXDATABLOCK option, to specify the maximum size of data blocks to be used for writing data to network shares. Valid values are integers in multiples of 65536 up to a maximum value of 4194304. If you edit the scheduled job, on Step 5 of the 'Schedule Backup Wizard' you can specify the MAXDATABLOCK value.
I hope the above helps.
Many Thanks
Eddie / comments
Thank you for your post into the forum.
This part of the error message: Warning: System error 121 (The semaphore timeout period has expired), indicates a network error or problem occured during the...
Thank you for your post into the forum.
I am unable to reproduce the reported problem. So a support call has been created for you, the call reference is F0024450.
If possible, can you please export a SQL Compare snapshot of each data source and send a copies of the snapshot files to support@red-gate.com, quoting your call reference? (File Menu ->Create Snapshot)
This will help to investigate your problem.
Many Thanks
Eddie / comments
Thank you for your post into the forum.
I am unable to reproduce the reported problem. So a support call has been created for you, the call reference is F0024450.
If possible, can you please expor...