Activity overview
Latest activity by Nicholas Kneeshaw
Hello jonesrob797,
To resolve this error you will need to take a full backup.
In order to perform a differential backup, SQL Server requires that a valid, full backup has been completed on the database being backed up.
If a full backup has been performed, the following conditions will require that another full backup be taken:
* The recovery model had been changed without taking a full backup
* A SQL maintenance plan task had changed the recovery model (reindexing can cause this)
* A backup specifying TRUNCATE_ONLY had been run on the database
* The database was detached from another server and attached to the current server
Please also see our documentation here: http://documentation.red-gate.com/displ ... +not+exist
I hope this helps.
Kind Regards,
Nick / comments
Hello jonesrob797,
To resolve this error you will need to take a full backup.
In order to perform a differential backup, SQL Server requires that a valid, full backup has been completed on the data...
Hi,
I think you'll find what you're looking for here: http://stackoverflow.com/questions/1429 ... -timestamp
Kind Regards,
Nick / comments
Hi,
I think you'll find what you're looking for here:http://stackoverflow.com/questions/1429 ... -timestamp
Kind Regards,
Nick
Hi Mark,
I've done some digging around and I think what is most likely is that the connection is being closed by Azure. Azure may close your connection if you are exceeding the limitations of its resource usage. This would explain why it is working fine for a number of routines but not for this large one.
There are some forums here with people experiencing the same error: https://social.msdn.microsoft.com/Forum ... getstarted http://stackoverflow.com/questions/2323 ... ming-query
The posts are quite old but I hope this is of some help.
Kind Regards,
Nick / comments
Hi Mark,
I've done some digging around and I think what is most likely is that the connection is being closed by Azure. Azure may close your connection if you are exceeding the limitations of its r...
Hi Ranvir,
I'm afraid there is currently no way of doing this. However, once completed and the project is saved, the next time SQL Data Compare is run it will know the custom comparison keys that have been configured.
There is a user voice post here where you can vote on this feature to be implemented: https://redgate.uservoice.com/forums/14 ... ey-give-us
Kind Regards,
Nick / comments
Hi Ranvir,
I'm afraid there is currently no way of doing this. However, once completed and the project is saved, the next time SQL Data Compare is run it will know the custom comparison keys that h...
Hi,
I have checked with the development team and I'm afraid that the way SQL Compare deals with assemblies is to flag any change at a binary level. Due to the nature of assembly files it is difficult to deal with them in another way without ignoring something that other customers wish to be flagged.
If you like you can create a topic on our user voice site, suggesting the change, which other users can then vote on: https://redgate.uservoice.com/forums/141379-sql-compare
However for the reason stated above this is not something that is likely to be implemented soon.
Apologies,
Nick / comments
Hi,
I have checked with the development team and I'm afraid that the way SQL Compare deals with assemblies is to flag any change at a binary level. Due to the nature of assembly files it is difficu...
Hi Meyer,
There is filter option in compare for assemblies which can be unchecked.
In the GUI after compare has run click on Filter Setup and then uncheck Assembly.
More information of filters can be found here, including information about using filters in the command line: http://documentation.red-gate.com/displ ... ng+filters
Another option, but I'm not sure whether this is what you are looking for is as follows:
There is also an option before comparing 'Don't use ALTER ASSEMBLY to change change CLR objects'
This can be found by going to the options tab in the new project window under Behaviour.
I hope this information is helpful. / comments
Hi Meyer,
There is filter option in compare for assemblies which can be unchecked.
In the GUI after compare has run click on Filter Setup and then uncheck Assembly.
More information of filters can ...