Comments
Sort by recent activity
Thank you for your post into the forum.
The answer is yes, you can use the trail version of SQL Backup to restore a database.
If you are planning to restore the backup file created by Server A using SQL Backup and restore to Server B.
Ideally you will need to install SQL Backup on Server B and then perform the restore.
If you do not wish to install SQL Backup on Server B, you can convert the backup file created using SQL Backup on Server A using the sqb2mtf.exe utility located in the SQL Backup installtion folder.
The sqb2mtf utility converts the SQL Backup format file, into a format that Microsoft Native SQL Backup will understand.
Hope this answer your question.
Many Thanks
Eddie / comments
Thank you for your post into the forum.
The answer is yes, you can use the trail version of SQL Backup to restore a database.
If you are planning to restore the backup file created by Server A usin...
Thank you for your post into the forum.
I suspect that the backup file you are using for the restore has become corrupt.
If I have understood your actions correctly, you performed a backup using SQL Backup on a Server A (SQL 2005). You then copied the backup file from Server A to another location, Server B (SQL 2000 machine). Next you attempted a restore of the backup file located on Server B.
I have known the above process to corrupt a backup file, particularly if the file was copied using Windows Explorer.
You can check to see if the copied backup has corrupted using a hash generator and create a checksum for each backup file. If the checksum hash generated is not identical, the backup file used in the restore is most likely corrupt.
You can download a checksum MD5 hash generator using this LINK
If you wish to copy the SQL Backup file from location A to location B and restore using the file at location B. I recommend that you either:
A. Use the COPYTO argument within the backup job to copy the file to location B.
or
B. Make use of our Copy Tool which can be download from our ftp site using this LINK
or
C. Use an alternative copy application such as 'XCopy' or 'RoboCopy'.
Many Thanks
Eddie / comments
Thank you for your post into the forum.
I suspect that the backup file you are using for the restore has become corrupt.
If I have understood your actions correctly, you performed a backup using SQ...
Hi, thank you for your forum post. The help documentation listed below, only has examples for a PK of one column and not multiple columns. They may provide some assistance to you, as the steps to take will be identical or similar for multi column PKs: Sync Manager Rules Change a PK value and all associated FKs FK Refresh Rules You will need the Sync. Manager rule on each of the Child tables, as a substitution rule requires a PK. Otherwise, this subject will require a support ticket to investigate further as the subject is too complex to handle via this forum. Many Thanks Eddie / comments
Hi, thank you for your forum post.The help documentation listed below, only has examples for a PK of one column and not multiple columns. They may provide some assistance to you, as the steps to t...
Hi, thank you for your forum post. In the TDM Anonymizer you can choose different or custom datasets. This help document explains how to define a custom dataset. Many Thanks Eddie / comments
Hi, thank you for your forum post.In the TDM Anonymizer you can choose different or custom datasets. This help document explains how to define a custom dataset.Many ThanksEddie
Thank you for your post into the forum.
Unfortunately you cannot filter database objects prior to the comparison being performed.
SQL Compare needs to compare very object and display the results of the comparison. Once the results have been displayed, you can then filter to remove objects that you are not interested in.
I will update a feature request, previously submitted by another customer who requested the ability to filter out objects before running a comparison. The reference for this feature request is SC-4080.
At this time the feature request is set to future, which means that the request will be considered for a future version of SQL Compare. I am sorry to inform, I do not know when or in what future version of SQL Compare the requested feature will appear.
Many Thanks
Eddie / comments
Thank you for your post into the forum.
Unfortunately you cannot filter database objects prior to the comparison being performed.
SQL Compare needs to compare very object and display the results o...
Hi BenDAltus, Thank you for your forum post. Does the information in this help document, help to answer your question? The document includes information on the Support database systems and capabilities of the tools within Test Data Manager. Many Thanks Eddie / comments
Hi BenDAltus,Thank you for your forum post.Does the information in this help document, help to answer your question?The document includes information on the Support database systems and capabilitie...
Hi emmar00, Thank you for your forum post. Please drop the left behind SqlCloneTemp databases, as everything looks healthy. On the next occasion it occurs, it would be good to check both the SQL Clone Server and the SQL Clone Agent log files to see why the SqlCloneTemp database did not successfully dropped. In my experience, it is some process preventing the database from being dropped or the temporary user created to perform any modification to an image can't be dropped as it still owns an object. Many Thanks Eddie / comments
Hi emmar00,Thank you for your forum post.Please drop the left behind SqlCloneTemp databases, as everything looks healthy.On the next occasion it occurs, it would be good to check both the SQL Clone...
Hi Khaoula, Thank you for your forum post. For substitution rules requires that the table to be masked has a primary key, as per the second sentence in this help document. First introduced in V7.1.32, on creating a substitution rule on a table with no primary key, an Invalid Rule dialog appears, as per the image below: [image] You simply need to click Convert to sync manager button. This converts the substitution rule to become a Sync. Manger rule.
The Sync Manager rule creates a temporary table that is a copy of the table selected in the substitution rule, with one difference in that it has a primary key constraint.
It populates the data from the live table into the temporary table.
Runs the substitution rule against the temporary table.
Using a Table to Table rule copies the masked data from the temporary table to the live table you originally selected for the substitution rule that has no primary key.
Finally drops the temporary table.
No requirement for the command rules to create a Primary Key and Indexes. Although what you have configured will add the Primary key for the tables with no primary key, the Rule Controller is not freshed, so is still working on the fact there is no Primary Key. The conversion of each substitution rule whose table has no primary key, the conversion to Sync. Manager rule is the solution in your scenario. Many Thanks Eddie / comments
Hi Khaoula,Thank you for your forum post.For substitution rules requires that the table to be masked has a primary key, as per the second sentence in this help document.First introduced in V7.1.32,...
Hi unclepuff, thank you for your forum post. If you locate the SQL Data Masker log file for this failed masking attempt, does it reveal any further information? The log file location can be found the SQL Data Masker GUI ->Misc. Setup tab ->Directories tab ->the path to log file is list under Directory for Log Files. Or if using the command line, you will find the log file in the path specified in your PARFILE for the LOGFILEDIR= parameter. Just to confirm, this is one substitution rule that is masking 50 columns in one table? Or you are masking 50 columns in this one table spread over two or more substitution rules? I ask this question, as if you have a single rule, you will most likely encounter performance errors. Please consider splitting the rule in smaller more manageable chunks, further reading here. Check the rule particularly the VARCHAR and CHAR columns in that the data set selected is not going to insert a text string that excludes the length of the column. Many Thanks Eddie / comments
Hi unclepuff, thank you for your forum post.If you locate the SQL Data Masker log file for this failed masking attempt, does it reveal any further information?The log file location can be found the...
Hi, thank you for your forum post. Not exactly, if you create a substitution rule on one table and mask the date/time column with the dates, random masking set. You can then use Table-To-Table Sync rule to update the date/time column in another table. Many Thanks Eddie / comments
Hi, thank you for your forum post.Not exactly, if you create a substitution rule on one table and mask the date/time column with the dates, random masking set. You can then use Table-To-Table Syn...