Log Shipping - Other source

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Log Shipping - Other source

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

Hi,

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.

Question:
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?)
raadee
 
Posts: 2
Joined: Mon May 05, 2014 10:57 am

Postby eddie davis » Tue May 06, 2014 2: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
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby raadee » Tue May 06, 2014 3: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.
Rade
raadee
 
Posts: 2
Joined: Mon May 05, 2014 10:57 am


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests