Comments
Sort by recent activity
When you output a report using SQL Compare Command line, you also need to specify what type of report you want to create.
You need to use the /reporttype switch.
/reporttype:<reporttype> alias:/rt [default: XML]
Values: XML, Simple, Interactive, excel
Once you have set the reporttype switch you will need to set the file for the report using /report, and specifying the file name and the file extension for the type of report you have chosen.
e.g. /reporttype:interactive /report:MyReport.html
You can view this in more detail by looking at the SQL Compare command line help file.
Type this command after navigating to the SQL Bundle 5 installation directory.
SQLCompare /help /verbose / comments
When you output a report using SQL Compare Command line, you also need to specify what type of report you want to create.
You need to use the /reporttype switch.
/reporttype:<reporttype> alias:/rt ...
By the looks of the message, the backup was a success, but the copy to the network share failed. I suspect this happened because the network location was unavaliable for some reason at the time of the backup.
It could also be that the SQL Server doesn't have enough contiguous memory to use as buffer space for a backup over the network. Since SQL Server provides this memory space to SQL Backup, it's possible that on a heavily used server that has been up for a long time. The workaround is to manually specify the buffer size in the backup command. This parameter is called MAXDATABLOCK, and must be a multiple of 65536.
For instance, you could amend your backup command to read:
master..sqlbackup N'-SQL "BACKUP DATABASE [Database] TO DISK = ''\\backup-server\d$\FULL_Database.sqb†WITH NAME = ''Database (Database)'', DESCRIPTION = '' '', INIT, MAILTO = ''pgrayson@tpp-uk.com'', COMPRESSION = 1, MAXDATABLOCK=65536"'
If this doesn't work, you can also add MAXTRANSFERSIZE, which is similar to MAXDATABLOCK, but affects memory usage for both local and network backups. MAXTRANSFERSIZE can be used in conjunction with MAXDATABLOCK for handling low-memory situations. / comments
By the looks of the message, the backup was a success, but the copy to the network share failed. I suspect this happened because the network location was unavaliable for some reason at the time of ...
Thanks for your post.
Hopefully I have not understood your question, but the only search facility we have available is accessed by selecting the 'search' link within the forum site. You are able to use this facility to search for existing topics on any or all of the forums.
We are planning to introduce a direct search facility on our website in due course. / comments
Thanks for your post.
Hopefully I have not understood your question, but the only search facility we have available is accessed by selecting the 'search' link within the forum site. You are able to...
Sorry about this delay. I must have missed your last update.
Here is a link to a knowledgebase article that lists some common solutions to this issue. http://www.red-gate.com/support/kb/KB200710000177.htm
If the server has also been running for a long time, and under somewhat heavy load, I think it would be a good idea to restart the SQL Server service if possible. This shouldn't really be necessary with modern versions of SQL Server, but it has been known to resolve these issues in the past.
Have you tried SQL Backup 5? There have been some improvements to the way that the SQL backup task is retried if the SQL Server is low on contiguous memory. This may also fix the problem for you. / comments
Sorry about this delay. I must have missed your last update.
Here is a link to a knowledgebase article that lists some common solutions to this issue.http://www.red-gate.com/support/kb/KB2007100001...
In your case it looks like it succeeded on the second attempt. You may find that if the step down the MAXTRANSFERSIZE parameter to 131072 you will no longer receive the warnings.
I hope this helps. / comments
In your case it looks like it succeeded on the second attempt. You may find that if the step down the MAXTRANSFERSIZE parameter to 131072 you will no longer receive the warnings.
I hope this helps.
Yes, this issue should be resolved by specifying a MAXTRANSFERSIZE parameter in the backup job.
With v5 you are now able to specify the MAXTRANSFERSIZE parameter while setting up a job. You can choose from the largest of 1024kb right down to 64kb, so it should be easy to fix if you ever get these warnings again. / comments
Yes, this issue should be resolved by specifying a MAXTRANSFERSIZE parameter in the backup job.
With v5 you are now able to specify the MAXTRANSFERSIZE parameter while setting up a job. You can cho...
Hi Barry,
Sorry for the delay in this response.
Currently there is no method to incorporate ftp transfer of data using the SQL backup extended stored procedures.
However some people have configured log shipping via ftp, but they have used a third party solution to copy the data from one server to another.
You could use SQL Backup on the Primary server to backup the database locally, then use COPYTO to copy the file to a location where the ftp can send the file. On the Restore side, the job would be configured to monitor the location that the file is sent to, and then restore from there and copy the file to a processed directory.
There are no current plans to introduce a complete ftp solution for log shipping into SQL Backup.
I hope this is helpful. / comments
Hi Barry,
Sorry for the delay in this response.
Currently there is no method to incorporate ftp transfer of data using the SQL backup extended stored procedures.
However some people have configured...
Hi,
There is no direct way to transfer a SQL Compare licence to a different machine. However, we can authorise additional activations if necessary.
If you're having trouble activating the software with your serial number, or you would like to find out if it is valid for activation, can you send the serial number to support@red-gate.com, and we will check it out for you.
Thanks / comments
Hi,
There is no direct way to transfer a SQL Compare licence to a different machine. However, we can authorise additional activations if necessary.
If you're having trouble activating the software ...
Hi,
The functionality to check or uncheck all objects in a group is already available in the software. This can be done by right-clicking in the results for that group.
I will pass your other suggestion to the developers, if it is approved it will be available in a future version. Unfortunately I cannot promise which version.
I hope this helps / comments
Hi,
The functionality to check or uncheck all objects in a group is already available in the software. This can be done by right-clicking in the results for that group.
I will pass your other sugge...
Hi Sam,
You shouldn't have any problems building a project with the sample code. If you still have time left in your evaluation you will just be notified that it is a trail version, it will only fail when the trial expires.
Maybe your evaluation has expired. This could happen if there was a previous version installed on that machine.
If you need to extend your trial, please contact support@red-gate.com
Let me know if this doesn't help / comments
Hi Sam,
You shouldn't have any problems building a project with the sample code. If you still have time left in your evaluation you will just be notified that it is a trail version, it will only fa...