Comments
Sort by recent activity
the data generated is located inside your sql server database. You will have to use the sql server backup tools or redgate backup tools (SQL Backup) to keep a copy somewhere. / comments
the data generated is located inside your sql server database. You will have to use the sql server backup tools or redgate backup tools (SQL Backup) to keep a copy somewhere.
It looks like we've had some reports of behaviour like this previously when the SQBConverter.exe file has been corrupted in an upgrade - can you try downloading it from http://www.red-gate.com/labs/free-tools ... terGUI.zip and let me know if that works?
You can replace the SQBConverter.exe file in the SQL Backup program folder with the download if it does work, and you'll be able to launch it from the Utilities menu in the SQL Backup GUI. / comments
It looks like we've had some reports of behaviour like this previously when the SQBConverter.exe file has been corrupted in an upgrade - can you try downloading it from http://www.red-gate.com/labs...
I am contacting you in regards to this support case. Did you need any further support at this stage?
I am the support engineer that is responding to this support case.
What you have mentioned would be the percentage processed. Where are you seeing the 120GB processed info? Is this a restore being done via the gui?
Normally restores via command line display as per below:
7/2/2012 12:00:11 AM: Database size : 19.813 MB
7/2/2012 12:00:11 AM: Compressed data size: 1.794 MB
7/2/2012 12:00:11 AM: Compression rate : 90.94%
7/2/2012 12:00:11 AM: Processed 1848 pages for database 'msdb', file 'MSDBData' on file 1.
7/2/2012 12:00:11 AM: Processed 6 pages for database 'msdb', file 'MSDBLog' on file 1.
7/2/2012 12:00:11 AM: BACKUP DATABASE successfully processed 1854 pages in 1.013 seconds (14.297 MB/sec).
Thanks for your patience and feedback in this matter. / comments
I am contacting you in regards to this support case. Did you need any further support at this stage?
I am the support engineer that is responding to this support case.
What you have mentioned would...
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:
...