Comments
Sort by recent activity
Thanks for your response in this matter.
Are you able to send me the following info via the associated support call:
1) Run the restore filelistonly command for the associated backup file and the output?
2) The restore command and the associated output?
Also let me know how have you generated the restore command when you have executed this in the past? via the GUI or you have been running the TSQL via SSMS?
Thanks for your response in this regards. / comments
Thanks for your response in this matter.
Are you able to send me the following info via the associated support call:
1) Run the restore filelistonly command for the associated backup file and the o...
Once a SQL Server database is online then there is no option to append additional data changes from a backup to that 'online' database.
Having said that there is one way you could try to apply more changes to that database. To do this you will have to take this database offline by changing its state to 'norecovery' (using restore database with 'norecovery' option). After this you can apply further backups to this same database. Now the backups that 'could' be applied will need to have the correct LSN sequence (so if the next backup was was a FULL then that will need to be applied, if it was a DIFF then that will need to be applied etc).
I hope this helps in your situation. / comments
Once a SQL Server database is online then there is no option to append additional data changes from a backup to that 'online' database.
Having said that there is one way you could try to apply more...
Many thanks for your post and apologies for inconvenience caused.
This is being investigated as a suppot case via our ticketing system as I need some files from you. The case number for your reference is F0072015.
At this stage are you able to send me the base monitor log files for this server? / comments
Many thanks for your post and apologies for inconvenience caused.
This is being investigated as a suppot case via our ticketing system as I need some files from you. The case number for your refere...
I am still reviewing the possible scenarios that could be causing this issue. Thanks for sending the logs across for review.
One possibility that could be causing this is because the query that performs the clock skew check runs every 15 seconds. So if the monitored server is busy performing other tasks or a network problem has occurred, it is possible for the clock skew query being late in reply.
Is it possible to confirm there are no messages in the windows event logs corresponding to any of this timelines? / comments
I am still reviewing the possible scenarios that could be causing this issue. Thanks for sending the logs across for review.
One possibility that could be causing this is because the query that per...
I am the support engineer that is responding to this request. OLR has a few limitations and it seems like you are running into the issues. I am sorry and want to apologise for the trouble this has caused on your side.
Just to get a more understanding of the situation are you able to let me know the following:
1) Location of the backup?
2) The size of the backup file?
3) The size of the database when online in sql server?
I know you have said that it's just a five row table. Just wanted to confirm the above to be sure! Apologies for repeating this!
Also let me now if the source and the destination server for the backup is this same server? or it was taken on a different server?
One possible reason for this could be the version of .Net on this server? Are you able to try this on a machine with version 3.5 and above?
We welcome your business and look forward to hearing about your experience with this tool.
Thanks for your patience and feedback in this matter. / comments
I am the support engineer that is responding to this request. OLR has a few limitations and it seems like you are running into the issues. I am sorry and want to apologise for the trouble this has ...
To use SQL Source Control, users need following permissions to:
execute functions on tempdb
alter databases linked to source control
These permissions are usually granted by default.
Permission to execute functions on tempdb:
You can test if you have this permission by running this SQL (where <dbname> is your database name):
SELECT HAS_PERMS_BY_NAME('tempdb', 'database', 'EXECUTE')
If the returned value is 1, you have this permission.
If needed, administrators can grant this permission with this SQL (where <user> is a user or role):
use tempdb
GRANT EXECUTE TO <user>
Permission to alter databases linked to source control:
You can test if you have this permission by running this SQL (where <dbname> is your database name):
SELECT HAS_PERMS_BY_NAME('<dbname>', 'database', 'ALTER')
If the returned value is 1, you have this permission.
If needed, administrators can grant this permission with this SQL (where <user> is a user or role):
USE <dbname>
GRANT ALTER TO <user> / comments
To use SQL Source Control, users need following permissions to:
execute functions on tempdb
alter databases linked to source control
These permissions are usually granted by default.
Permission to ...
Many thanks for your e-mail and apologies for inconvenience caused.
The permissions error is likely to be a problem with access to TempDb. You can grant the execute permission on tempdb like this:
use [tempdb]
GRANT EXECUTE
TO
sql_source_control_users
You'll need to replace 'sql_source_control_users' with a role that represents all of the users that need this permission (for example, if you have a database developers role they should use that).
Hope this solves the issue you are having. / comments
Many thanks for your e-mail and apologies for inconvenience caused.
The permissions error is likely to be a problem with access to TempDb. You can grant the execute permission on tempdb like this:
...
Thanks for your forum post.
Are you able to confirm if you have followed the steps detailed in the url below: http://www.red-gate.com/supportcenter/C ... Repository
Thanks for your patience and feedback in this matter. / comments
Thanks for your forum post.
Are you able to confirm if you have followed the steps detailed in the url below:http://www.red-gate.com/supportcenter/C ... Repository
Thanks for your patience and feed...
I hope your day is off to a good start? I am sending you an update in regards to this issue. Thank you very much for your feedback in regards to this issue.
I have raised a JIRA issue for the enhancement requestion you have reported and have organised for you to be notified when this is fixed. This issue is now being triaged by development for a future sprint. The JIRA number (SE-681) that will ensure you get an automatic update.
Thanks for your patience and feedback in this investigation, This is really appreciated. / comments
I hope your day is off to a good start? I am sending you an update in regards to this issue. Thank you very much for your feedback in regards to this issue.
I have raised a JIRA issue for the enhan...
Thanks for your forum post. This does not need to be raised in a new post.
The TSQL script that you have generated using the wizard is the correct one and should work fine for that specific backup. To dynamically generate the TSQL depending on the backup will require using variables to substitute the relevant values. Unfortunately we haven't written any TSQL that can do this at the moment.
Please note this will need to be customised in your environment and depending on the number of threads, database structure the 'move syntax' will change as well.
Thanks for your patience and feedback in this matter. / comments
Thanks for your forum post. This does not need to be raised in a new post.
The TSQL script that you have generated using the wizard is the correct one and should work fine for that specific backup....