Comments
Sort by recent activity
If you took a full backup of any database from the source using SQL Backup with the minimum of options e.g. EXEC master..sqlbackup '-sql "BACKUP DATABASE [database name] TO DISK = [backup file name]"' and restored this backup on the destination server, is the same error raised? If not, could you then try incrementally adding the other options used in the original backups until the restore fails? When that restore fails, could you please post the contents of the backup and restore logs? The default folder for the logs is C:\ProgramData\Red Gate\SQL Backup\Log\<instance name> / comments
If you took a full backup of any database from the source using SQL Backup with the minimum of options e.g.EXEC master..sqlbackup '-sql "BACKUP DATABASE [database name] TO DISK = [backup file name]...
Which SQL Server version were the backups taken from, and which version are they being restored to? / comments
Which SQL Server version were the backups taken from, and which version are they being restored to?
I think there is an error in the 'D:\Temp\20191020_045728_AWSCSQL02_DB21387_FULL.sqb' file. Could you try restoring from another backup file? / comments
I think there is an error in the 'D:\Temp\20191020_045728_AWSCSQL02_DB21387_FULL.sqb' file. Could you try restoring from another backup file?
The error suggests that the database was in use at the time of the restore. Have you considered using the SQL Backup features that help to automate restores of multiple transaction log files? For e.g. something like this: EXEC master..sqlbackup '-sql "RESTORE LOG AdventureWorks_COPY FROM DISK = [g:\backups\log\AdventureWorks_*.sqb] WITH NORECOVERY, MOVETO = [g:\backups\log\restored\], DISCONNECT_EXISTING"' - disconnects all existing users to the AdventureWorks_COPY database (DISCONNECT_EXISTING), - finds all files matching the AdventureWorks_*.sqb pattern in the g:\backups\log\ folder - sorts and restores those files in the correct order - moves each of those files to the g:\backups\log\restored\ folder after the restore so that they are not picked up to be restored again later / comments
The error suggests that the database was in use at the time of the restore.Have you considered using the SQL Backup features that help to automate restores of multiple transaction log files? For e...
Try assigning the 'db_owner' or 'db_backupoperator' role to the SQL Server Agent service startup account for that database and see if the backup works. / comments
Try assigning the 'db_owner' or 'db_backupoperator' role to the SQL Server Agent service startup account for that database and see if the backup works.
We don't publicly release documentation for the sqbutility function. If you want to find the licensing status for an instance, you can use this:
<div>DECLARE @type INT
<span style="background-color: transparent; color: inherit; font-size: inherit;"><font face="Roboto, Helvetica Neue, Arial, sans-serif">DECLARE @version varchar(16)</font>
</span><span style="background-color: transparent; color: inherit; font-size: inherit; font-family: Roboto, "Helvetica Neue", Arial, sans-serif;">DECLARE @serial varchar(32)</span></div><div><br></div><div>EXEC master..sqbutility 1021, @type OUTPUT, @version OUTPUT, @serial OUTPUT
<span style="background-color: transparent; color: inherit; font-size: inherit; font-family: Roboto, "Helvetica Neue", Arial, sans-serif;">SELECT @type, @version, @serial</span>
</div>Possible values for @...: 0 = expired trial 1 = active trial 2 = standard license 3 = professional license
/ comments
We don't publicly release documentation for the sqbutility function. If you want to find the licensing status for an instance, you can use this:
<div>DECLARE @type INT
<span style="background-colo...
The version number returned in the result sets header is the version of the SQL Backup extended stored procedure library (xp_sqlbackup.dll) installed on the SQL Server instance. There isn't a way to retrieve this information via a function. The version of the SQL Backup Agent service (SQBCoreService.exe) can be retrieved using the following: DECLARE @version varchar(16) EXEC master..sqbutility 1030, @version OUTPUT SELECT @version You might sometimes run into situations where the version of the extended stored procedure library differs from the SQL Backup Agent service e.g. when the extended stored procedure library was locked during an upgrade process. / comments
The version number returned in the result sets header is the version of the SQL Backup extended stored procedure library (xp_sqlbackup.dll) installed on the SQL Server instance. There isn't a way ...
Try changing the SQL Server Agent service startup account to an account that is a member of the SQL Server sysadmin fixed server role. / comments
Try changing the SQL Server Agent service startup account to an account that is a member of the SQL Server sysadmin fixed server role.
Are your running the verification task using SQL Server Agent or the Windows Task Scheduler? / comments
Are your running the verification task using SQL Server Agent or the Windows Task Scheduler?
I believe most users use Windows Task Scheduler to run SQL Server Express 'jobs'. The SQL Backup GUI isn't designed to connect to a machine's Task Scheduler service to create/edit/query Task Scheduler tasks. / comments
I believe most users use Windows Task Scheduler to run SQL Server Express 'jobs'. The SQL Backup GUI isn't designed to connect to a machine's Task Scheduler service to create/edit/query Task Sched...