Comments
Sort by recent activity
Thank you for your post into the forum.
SQL Backup 5 is cluster aware.
SQL Backup has two main components:
SQL Backup GUI
SQL Backup Server Components
When you first install SQL Backup from the SQL Toolbelt installer, this action only installs the SQL Backup GUI. You need to install the SQL Backup Server Components as a separate action.
The installer for the SQL Backup Server Components is the cluster aware.
To install SQL Backup on your cluster, I recommend you follow the steps below:
1. On a machine with the SQL Backup GUI installed, locate a file called SQBServerSetup.exe. By default the file will be located in the %systemroot%\program files\Red Gate\SQL Backup directory. If not already on the active node of the cluster, copy this file to the active node of the cluster and execute the file. This action will start the SQL Backup Server Components Installer.
2. Follow the on screen instructions, the installer will detect that you are installing to a cluster. Ensure that you select the option to install to all nodes in the cluster.
The following contains further advice on installing SQL Backup on a cluster and includes screen shots on what you will see: http://www.red-gate.com/supportcenter/C ... alling.htm
Also from your post, I see that you are attempting to install SQL Backup 5.3. The lastest version of SQL Backup is Version 5.4 which can be downloaded using this LINK
Many Thanks
Eddie / comments
Thank you for your post into the forum.
SQL Backup 5 is cluster aware.
SQL Backup has two main components:
SQL Backup GUI
SQL Backup Server Components
When you first install SQL Backup from the SQL...
Hi, thank you for your forum post. I assume you are referring to Source Control for Oracle application. Not 100% sure what you mean by the comment: Now I need to connect to a remote setting. Source Control for Oracle (SOCO) is designed to operate on user's Windows workstation or laptop. You just need to create a new project, of which there are 5 steps:
Step 1, you connect to the Oracle database host either via a TNS connection or Manual connection where the user provides the host name, port, SID or Service Name and the username/password combination to connect to the database.
Step 2, select the location or source control system. 4 choices - Subversion, TFS, Git or a Working Scripts folder option.
Step 3, select the schema or schemas you wish to link to source control option in Step 2.
Step 4, the folder that contains the object creation scripts.
Step 5 is a summary of Steps 1 - 4.
Further reading in this help document. There is a locking feature, further reading in this help document. SOCO will only push to the location specified in Step 2, of the create project steps, you cannot specify an alternative or new location. Many Thanks Eddie / comments
Hi, thank you for your forum post.I assume you are referring to Source Control for Oracle application.Not 100% sure what you mean by the comment:Now I need to connect to a remote setting. Source Co...
Thank you for your post into the forum.
The problem you have encountered is a known issue.
If you are using SQL Server authentication on a SQL Server, for security reasons browsing to folders or files on the SQL Server is disabled by default. This is to prevent information about the file system structure being revealed to SQL Authenticated users who do not have permissions to browse the file system on the SQL Server.
You can override this restriction. However, you should do this only after careful consideration.
To enable file browsing by SQL Server users, in the registry folder:
32-bit machines: HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>
64-bit machines: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>
create the registry key AllowSQLBrowsing as type DWORD, and set the value to 1.
You must have administrator privileges to do this.
Many Thanks
Eddie / comments
Thank you for your post into the forum.
The problem you have encountered is a known issue.
If you are using SQL Server authentication on a SQL Server, for security reasons browsing to folders or fi...
Thank you for your post into the forum.
I am sorry to say, I unsure as why the SQL Backup Server Components did not install successfully. The SQL Backup Server Components installer is cluster aware and normally installs to all nodes on a cluster simultaneously.
Are you installing onto a named SQL Instance on the cluster?
You have informed us that the SQL Backup Agent is not created. Can you please check to see if the SQL Backup Server Components are installed by checking to see if the installation folder is created? By default it is created in this directory:
%SystemRoot%\Program Files\Red Gate\SQL Backup\(local) or <SQL Instance name>
Did the install create a SQL Backup resource in the Cluster Administrator? If the answer is yes, can you please disable the resource. Copying the following file to the passive node, SQBServerSetup.exe and run this executable. Are you able to successfully install SQL Backup Server Components to the node?
The following knowledge base article contains further advice on cleaning up from a failed installation and getting SQL Backup Server Components installed successfully on both nodes of your cluster: http://www.red-gate.com/supportcenter/C ... nstall.htm
Many Thanks
Eddie / comments
Thank you for your post into the forum.
I am sorry to say, I unsure as why the SQL Backup Server Components did not install successfully. The SQL Backup Server Components installer is cluster awar...
Hi @jamesgally, A Redgate support ticket has been created for you, the ticket reference is #309451. I will contact you via the Support Ticket, to request further information. Many Thanks Eddie / comments
Hi @jamesgally,A Redgate support ticket has been created for you, the ticket reference is #309451.I will contact you via the Support Ticket, to request further information.Many ThanksEddie
Hi BenAtWork, Thank you for your forum post. Sadly there is not an option to turn off the sample data preview. The closest possible way of achieving your goal, is to reduce the number of rows for the preview data via the Tools menu on the toolbar ->Application options -> General Tab ->Application display ->Set the "Number of rows in generator preview" to equal 1 and the preview will display a single row (Setting "Number of rows in generator preview" to zero and leaving the setting blank has no effect). Many Thanks Eddie / comments
Hi BenAtWork,Thank you for your forum post.Sadly there is not an option to turn off the sample data preview.The closest possible way of achieving your goal, is to reduce the number of rows for the ...
Hi, thank you for your reply. Based on screen shot, if you need rule 01-0015 to execute after Rule 01-0022, simply drag and drop it so becomes dependent on rule 01-0022 successfully executing before running rule 01-0015. Rule 01-0015 becomes [image] -0015 as below: [image] Another method to having rules to run later, is to set a rule block. So using Rule 01-0015 as the example, highlight the rule and click the Bulk Change RuleBlock button ->set the New rule block for rules value, in my example I entered the number 5 ->Clicked Change Rule Block button ->Clicked Done button. Rule 01-0015 becomes rule 05-0015. So Rule block 5 will not execute until all the rules in rule block 1 have successfully completed. [image] Many Thanks Eddie / comments
Hi, thank you for your reply.Based on screen shot, if you need rule 01-0015 to execute after Rule 01-0022, simply drag and drop it so becomes dependent on rule 01-0022 successfully executing before...
Hi, Thank you for your post into the forum. To move the rules into the order you wish them to run, it is a simple matter of drag and drop to have them in a different order. As Data Masker is multi-threaded, which means rules will execute at the same time. If you have a rule that is dependent on another rule and you want the rule to execute on a successful completion of another rule, you can setup rule dependencies and rule blocks. This help article explains how to configure Rule dependencies and Rule blocks. Many Thanks Eddie / comments
Hi,Thank you for your post into the forum.To move the rules into the order you wish them to run, it is a simple matter of drag and drop to have them in a different order. As Data Masker is multi-t...
Hi, Thank you for your forum post. A support ticket has been generated for you, as I need to collect log files and if possible a copy of the MaskingSet you have generated, that you will not want to upload in this public forum. The support ticket number is #307134. I will correspond with you via the support ticket. Many Thanks Eddie / comments
Hi,Thank you for your forum post.A support ticket has been generated for you, as I need to collect log files and if possible a copy of the MaskingSet you have generated, that you will not want to u...
Hi, Thank you for your forum post. When you refer to LocalDB, is this the special developer-optimized edition low impact version of the SQL Server engine, that is not installed as Windows Service but launched on demand by an ADO.NET client (intended for single user scenarios)? Or do you mean a full SQL Server installation using the default instance name (local)? I ask the above questions, as SQL Backup does not support LocalDB. SQL Backup does support a full SQL Server installation where the instance uses the default name (local). In my experience when connecting the user either specifics just the host name in your case KKNJML3 or by adding (local) as the instance name to the hostname, for example FKNJML3\(local). Many Thanks Eddie / comments
Hi, Thank you for your forum post.When you refer to LocalDB, is this the special developer-optimized edition low impact version of the SQL Server engine, that is not installed as Windows Service bu...