Home / server / Questions / 202891
Accepted
Gabriel Guimarães
Asked: 2010-11-18 03:59:02 +0800 CST

SQL Log Shipping Two Databases using the same shared folder

  • 772

I will configure Log Shipping for more than 1 database on single a server. And I wan't to know If I can use a single Shared Folder or if I have to create a Folder For Each Database.

What I mean is:

  • Does SQL know what backups to copy If I use a Shared Folder?
  • How about the copy destination, can it be the same for more than one database?
sql-server log-shipping sql-server-2008-r2

2 Answers

  1. Best Answer

    Each database will have its own job and will only copy the dbname_*.trn, so they can share the same source and destination folder. The jobs format the log backup file names in such a way that they can distinguish the LS backups from regular backups and will only copy the LS formatted ones for that database.

    • 1

  2. While I haven't ever log shipped multiple databases (only one) from the primary, I would implement with each log shipping install have its own shared backup and copy folders.

    • 0