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
5
votes
4 answers

Log Shipping to an Existing Database

We have a few huge databases we would like to log ship on SQL Server 2008. Unfortunately the link between primary and secondary servers is fast enough to handle log shipping but the initial backup/copy would tie up bandwidth for days, if not weeks,…
4
votes
1 answer

Migrate SQL 2008 database to Azure

I am migrating a SQL server 2008 R2 production database to Azure SQL database service in the cloud. Is it possible to mirror/replicate the Azure database from the 2008 R2 database? So I can just switch over to just using the new one. Instead of…
Andreas
  • 299
  • 1
  • 5
  • 15
3
votes
1 answer

SQL Server Replication only for Enterprise Edition? Does it require Enterprise on both sides? Other solution?

My situation: I've been looking for an option of data replication for my SQL Server (I'm not expert on it, I should say it - neither on English Language). I've seen a few options, like Log Shipping and SQL Replication. For Log Shipping, I've read…
3
votes
1 answer

Postgresql 9.3 Log Shipping on a Hot Standby

My setup I've just set up streaming replication in postgres for the first time (9.3.5), and while the streaming is working as I expect, I'm struggling to get my standby to run the archive_command so I can store all of the log files. Master…
3
votes
1 answer

Queries re SQL Backup, log files and Log Shipping

I was given a MS-SQL server backup .bak file to restore on my machine which was about 25mb in size , but required 10Gb of free disk space because the log file was that size, which indicates that they log file is not getting backed out nor truncated.…
sgmoore
  • 652
  • 5
  • 10
2
votes
1 answer

How to Configure SQL Server 2008 R2 Log Shipping

I need to set up a standby server using SQL Server Log Shipping. This is my first time doing this, so I'm following the instructions in the SQL Help step by step. Of course, I ran into a problem at the first step. The help file says: Right click…
2
votes
1 answer

Can I log ship from SQL Server 2008 R2 to Sql Server 2008 "R1"?

I have two sql server instances, on is SQL Server 2008 R2, one is the first release of SQL Server 2008 ("R1"), is it possible to log ship from the R2 machine to the R1 machine? If is not possible, is mirroring possible? If that is not possible, is…
2
votes
1 answer

Implementing Automatic failover with SQL Server 2008 R2 Web Edition

I am trying to implement automatic failover for an ASP.NET MVC website running on Windows 2008 R2 Web Edition / SQL Server 2008 R2 Web Edition. I know that this is not supported out of the box, but I have to make do with the software licenses which…
2
votes
4 answers

Log shipping on select tables

I know I am most likely using incorrect terminology so please correct me if I use the wrong terms so I can search better. We have a very large database at a client's site and we would like to have up to date copies of some of the tables sent across…
Scott Chamberlain
  • 1,445
  • 2
  • 21
  • 37
2
votes
1 answer

SQL log shipping DR strategy

I have been tasked to come up with a workable DR solution for our SQL environment. However, the DR box has a major restriction as the data drive is 2.25TB as opposed to a 3.50TB drive used in production. Obviously, this contravenes the fundamental…
Mark G
  • 149
  • 5
2
votes
2 answers

SQL Server Log Shipping: Replace Copy Job with Manual Compress & Copy

I have two instances of SQL Server 2005 STANDARD edition, Server A in New York and Server B in California. Server A has a large database; for DR/BCP purposes, I would like to use Log Shipping to keep a warm backup on Server B. Unfortunately, the…
Hythloth
  • 235
  • 2
  • 7
1
vote
2 answers

Cannot generate SSPI context

I'm trying to connect between two SQL Servers to set up log-shipping. I'm getting the following error when connecting from the Publisher to the Subscriber: Cannot connect to DRBOX Additional information: Cannot generate SSPI context. (Microsoft SQL…
SuperCoolMoss
  • 1,252
  • 11
  • 20
1
vote
0 answers

Unable to configure SQL Server log shipping, latch error

SQL 2008 R2, SP1 CU8 both servers, next to each other in the rack, ~10 small databases (total under 50GB). I found that log shipping was broken (for a long time), rebooted secondary as a troubleshooting step. Tried to setup the log shipping…
FredS
  • 53
  • 1
  • 1
  • 11
1
vote
2 answers

Is this the correct way to wait for an idle database catalog before restoring a log (for Sql Server log shipping)?

I want to have a separate instance of Sql Server dedicated to a "reporting" role. I've decided to populate that server via Log Shipping (since mirroring won't work, and Availability Groups is crazy-expensive). I've worked out that I simply need to…
Granger
  • 1,150
  • 2
  • 10
  • 26
1
vote
2 answers

Creating shared folder between two servers

I need to create an SQL log shipping between 2 databases, The source is on an AWS EC2 instance running Windows Server 2008 R2 and SQL Server 2008 The destination is on an Azure VM running Windows datacenter 2012 and SQL Server 2012 This process…
1
2 3