Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [log-shipping]

Log shipping is a feature that replicates a database by taking regular incremental backups, transporting them files and restoring on a destination server. The destination database can be accessed in a read-only mode.

This is commonly used for off-site backup or reporting purposes, so that heavy reports can be run against the destination database rather than adding load to the praimary (usually customer facing) server.

The destination database can be accessed as a read-only database during the gaps between the database restore.

This technique is supported by Microsoft SQL Server, 4D Server and PostgreSQL.

36 questions
0
votes
1 answer

SQL Server 2000 -- Log Shipping reliability?

I've been asked to look into log shipping for SQL Server 2000 (yes, 2000): something in my memory tells me that I looked at this years ago and there were question marks over it's reliability. I'm trying to google stuff, but given the age of 2000 now…
Chris J
  • 1,218
  • 18
  • 32
0
votes
2 answers

SQL Log Shipping Two Databases using the same shared folder

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…
Gabriel Guimarães
  • 425
  • 5
  • 18
0
votes
1 answer

Copy Transaction Log backup from Primary to non secondary server

I have a SQL Server 2005 log shipping set up, with a primary server and two secondary servers. The process goes like this: Primary backs up to independent network drive (not on any of database servers) Secondary(s) copy from network drive to local…
MrEdmundo
  • 291
  • 5
  • 14
0
votes
1 answer

SQL Server Log Shipping - individual folders for backups, or all in the one place?

When setting up log shipping for an active/passive environment, I always try to keep the files neat, by dumping the log backups into their own folders: C:\TransLogs\Database1\ C:\TransLogs\Database2\ C:\TransLogs\Database3\ etc. However a database…
Mark Henderson
  • 68,316
  • 31
  • 175
  • 255
0
votes
2 answers

Log Shipping & Target Database filenames

I have a production and disaster recover ('DR') server and have been using log-shipping on a single database ('DB1') between the two servers without issue for a few months. Recently I've had to duplicate an instance of the application and this…
Daniel
  • 13
  • 6
0
votes
1 answer

Recovery models, log shipping and log backup frequency in SQL05

Trying to get a sense of the optimal setup in our environment. I have a large SQL05 DB (500+GB) that is log shipped to a read-only system over a WAN. I'm currently running in FULL recovery model, with log dumps every 5 minutes during peak hours and…
paulland
1 2
3