Log Shipping - Other source

Forum for users of Redgate's SQL Backup tool

Log Shipping - Other source

Postby raadee » Mon May 05, 2014 10:05 am


I've run in to a question about log shipping.

The source database is backed up via TSM today, the hosting partner would like TSM to handle all the backups.

If TSM provides the log backups in a folder for the log shipping process, is it possible not to use the backup job that Red Gate creates. But only to copy these (native backup files) and restore them on the secondary?

Or should I go Native all the way for that process? (if that is even possible?)
Posts: 2
Joined: Mon May 05, 2014 9:57 am

Postby eddie davis » Tue May 06, 2014 1:42 pm

Thank you for your forum post.

I assume TSM stands for Tivoli Storage Manager and not Taiwan Semiconductor Manufacturing.

SQL Backup has its own file format for the backup files it creates, therefore will only restore backup files created using SQL Backup.

The choice is yours, insist to your hosting company that they use SQL Backup to backup you source log shipping database or databases. Or switch to using TSM or native SQL Server backups files for your log shipping solution.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
Posts: 1148
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Postby raadee » Tue May 06, 2014 2:07 pm

Yes your assumption is correct, when talking backup software and TSM you can almost always assume that it is Tivoli.
Not to be confused with TSMC (Taiwan Semiconductor Manufacturing) that have absolutley nothing to do with backup software.

The choice made was to go with database mirroring and snapshots so that we do not have to mess with backup/restore SLA's and resonsibilities.

Thanks for your reply.
Posts: 2
Joined: Mon May 05, 2014 9:57 am

Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests