Red Gate forums: SQL Backup Previous Versions

Run SQBConverter.exe from SSIS

bob.powell — Tue, 14 May 2013 16:42:54 GMT

We currently have an SSIS package that restores a database from a SQL SERVER BAK file. Our backups are now being preformed with RedGate. How do I get SSIS to execute the SQBConverter.exe to convert an SQB file into one BAK file?

RE: COPYTO to network share fails from time to time

petey — Thu, 31 Jan 2013 13:20:31 GMT

It may be due to intermittent network outages on your server box.

RE: COPYTO to network share fails from time to time

petey — Thu, 31 Jan 2013 12:53:12 GMT

It may be due to intermittent network outages on your server box.

RE: Convert archive MTF to SQB

petey — Thu, 31 Jan 2013 12:50:40 GMT

Sorry, that conversion isn't possible.

RE: Convert archive MTF to SQB

Gladiatr — Wed, 05 Dec 2012 22:19:40 GMT

Hi,

Is there a way to convert SQLBackup 5 (.SQB) file format to SQLBackup 6 or higher file format.

I would like to use the SQLVirtual Restore to mount the .sqb files that were backed up in SQLBackup 5.4.

Thanks.
-Muneeb

COPYTO to network share fails from time to time

knockout — Sun, 18 Nov 2012 23:15:26 GMT

Hi,

I am using RedGate SQL Backup Pro v5.3 on SQL Server 2005 running on a Windows Server 2008 R2 x64 server with 96GB of RAM.

I am seeing COPYTO failures (warning 141) every now and then. I searched the forums and tried setting MAXDATABLOCK and MAXTRANSFERSIZE parameters to the lowest possible setting, but that did not seem to help fix it. I have verified that it is not a permissions issue because the COPYTO goes through sometimes without failing.

We have the same version of SQL Backup Pro running on other Windows Server 2003 servers where we do not see any such errors.

Here are the contents of the log file:

Code:

SQL Backup log file 5.3.0.178

-SQL "BACKUP LOG [DB6] TO DISK = '<AUTO>' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', INIT, COMPRESSION = 2, MAXDATABLOCK = 65536, MAXTRANSFERSIZE = 65536, MAILTO_ONERROR = 'DGG_DBA@corp.fanbox.com', COPYTO = '\\itbackup.colo.sms.ac\E$\Backup\SQL03\DB6' "

----------------------------- ERRORS AND WARNINGS -----------------------------

11/18/2012 2:41:00 PM: Warning 141: COPYTO error: Unable to copy Y:\Backup\SQL03\DB6\DB6_LOG_20121118_143801.sqb to \\itbackup.colo.sms.ac\E$\Backup\SQL03\DB6\DB6_LOG_20121118_143801.sqb (The operation completed successfully).

----------------------- PROCESSES COMPLETED SUCCESSFULLY --------------------

11/18/2012 2:38:00 PM: Backing up DB6 (transaction log) to:
11/18/2012 2:38:00 PM: Y:\Backup\SQL03\DB6\DB6_LOG_20121118_143800.sqb

11/18/2012 2:38:01 PM: BACKUP LOG [DB6] TO VIRTUAL_DEVICE = 'SQLBACKUP_9564169D-6D3B-4535-AC49-E0211C378C2A' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 65536, NAME = N'Database (DB6), 11/18/2012 2:38:01 PM', DESCRIPTION = N'Backup on 11/18/2012 2:38:01 PM Server: SQL03 Database: DB6'

11/18/2012 2:40:37 PM: Backup data size : 2.497 GB
11/18/2012 2:40:37 PM: Compressed data size: 908.147 MB
11/18/2012 2:40:37 PM: Compression rate : 64.49%

Processed 326527 pages for database 'DB6', file 'DB6_Log' on file 1.
BACKUP LOG successfully processed 326527 pages in 154.645 seconds (17.297 MB/sec).

Informational Messages

rtrahan — Mon, 29 Oct 2012 15:44:47 GMT

In earlier versions of SQLBackup, was the output generated ever sent as SQL informational messages?

I ask because we have an older application that handled log shipping and it verified the backup was successful by reading an informational message sent from the SQL command.

However, now I see that restores only do select statements to generate output messages. Is this (relatively) new?

Thanks

RE: RedGate Backup job always fails

Brian Donahue — Fri, 01 Jun 2012 08:15:09 GMT

As it mentions in the post that you quoted, it is necessary to install sqbsetlogin manually, as it is not configured with the shipped version of SQL Backup.

Code:

EXEC master..sp_addextendedproc sqbsetlogin, 'xp_sqlbackup.dll'

RE: RedGate Backup job always fails

SQL_ME_RICH — Thu, 31 May 2012 20:20:31 GMT

petey wrote:

The SQL Backup Agent service logs in to SQL Server using either Windows authentication or SQL Server authentication.

The default mode is Windows authentication, where the SQL Backup Agent service will log in using the credentials of the service startup user.

To log in using SQL Server authentication, you need to use the sqbsetlogin extended stored procedure e.g.

Code:

EXEC master..sp_addextendedproc sqbsetlogin, 'xp_sqlbackup.dll'
EXEC master..sqbsetlogin 'sa', 'sapassword'
EXEC master..sp_dropextendedproc sqbsetlogin

This will set up the SQL Backup service to log in using the sa user. To revert back to Windows authentication, run sqbsetlogin with blank values e.g.

Code:

EXEC master..sqbsetlogin '', ''

Try running sqbsetlogin without any values, in case the SQL Backup Agent service has been set up to use SQL Server authentication. Then try running a backup, after setting up the service startup user to be an account you know has sysadmin rights to SQL Server.

This appears to be the solution to a problem I am having in getting my SQL Backups to run (they keep erroring out saying that they cannot log in with the sa account, and that the password is wrong). This makes sense as I just recently changed the sa password on 2 diiferent servers and instances, and now this won't work - but I really do not want SQL Authentication being used to run the RedGate service/backup with anyway. So - I tried to run the code above to reset it back to Windows Authentication, but all I get is a 'Could not find stored procedure 'master...sqbsetlogin'. If this is a PROC - it's definitely not in the master db of the instance I am trying to fix...Does this work for SQL Backup 7? I am using SQL Backup 7 (7.0.5.1).

Thanks

RE: Multi-Server Install of Backup using SQL Multi Script

mdgraves — Tue, 03 Apr 2012 19:19:42 GMT

I am attempting to run the silent install for the latest update to SQL Backup 6.5.

Below is my command string (server names, logins and passwords masked).

When I run, I get the "select the tools to install" window pop-up. How can I avoid this / any interaction windows?

"D:\DBA_Installs\SQL Backup 6.5\v6.5.0.73\SQL_Backup_6.5.0.73.exe" /VERYSILENT /SUPPRESSMSGBOXES /SQBMINIMAL /LOG /SVCUSER *****\***** /SVCPW ******/I *********

Input string was not in a correct format

ROOYEVAAR — Wed, 22 Feb 2012 12:52:09 GMT

Hi,
I'm installing SQL Backup 5.4 on a new server, but I get this error every time I try to install the server components.
First it fails completely, but if I leave that window open, install SQBServerSetup, and then press retry, it says Input String was not in a correct format at the 'Updating SQL Server information' item.

I uninstalled, reinstalled, uninstalled, only installed the server components, installed from a remote server, but nothing helps.

Please advise... I need this server up and running....

RE: full backup works, differential fails

jacw2000 — Mon, 13 Feb 2012 16:42:31 GMT

I had the same problem. I retook the Full backup, and then the diff backup worked fine. Not sure why it lost track of the full backup though.

RE: Warning 300: Backup failed, VDI Error 1010

petey — Mon, 16 Jan 2012 01:39:19 GMT

Could you please post the contents of the SQL Backup log file for the backup that failed? The default folder where the logs are stored is C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name> on Windows 2003 and older, and C:\ProgramData\Red Gate\SQL Backup\Log\<instance name> on Windows Vista and newer.

Thank you.

RE: Warning 300: Backup failed, VDI Error 1010

epetro — Wed, 14 Dec 2011 19:12:45 GMT

If you suggest another topic, please provide a link. Some of us end up on the same thread.

RE: Remote backup over VPN?

Ayelen — Tue, 06 Dec 2011 13:40:52 GMT