Log shipping is a feature in MS SQL Server 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.

learn more… | top users | synonyms

1
vote
2answers
46 views

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 ...
1
vote
2answers
972 views

Creating shared folder between to 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 ...
0
votes
1answer
76 views

Restore backup from SQL 2008 to 2008R2 with standby

We are looking to replicate our production database to another instance so that when reports are run, it doesn't slow down the application to the point of being barely usable. I had limited success ...
1
vote
1answer
41 views

How do I change the number of days a copied transaction log is kept in a log shipping configuration?

I think this is a pretty simple and perhaps stupid question. I've established log shipping between two SQL Server 2008 servers using the GUI (i.e. the SQL Server Management Studio). It's been ...
2
votes
1answer
716 views

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 ...
3
votes
1answer
256 views

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 ...
2
votes
1answer
424 views

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 ...
0
votes
2answers
424 views

Log Shipping breaking daily on SQL Server 2005

I am facing a somewhat serious problem with Log Shipping on SQL Server 2005 and I am having trouble to correct it, so I will try some help from SF's experts. I have a Windows 2003 Server (PROD) that ...
1
vote
1answer
399 views

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 ...
0
votes
1answer
350 views

How to change the email address where SQL Server sends log shipping warnings to?

Years ago, I set up log shipping in our main database. I'm sure that I had to enter my email address somewhere, because every time when something bad happens now (for example, when the secondary ...
2
votes
4answers
253 views

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 ...
1
vote
1answer
382 views

Biztalk 2009 logshipping with SQL 2008

I am setting up biztalk logshipping for Biztalk 2009 database. Following http://msdn.microsoft.com/en-us/library/aa560961.aspx article, I am doing the following to setup biztalk logshipping on ...
0
votes
1answer
61 views

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 ...
1
vote
1answer
178 views

Setup secondary server for Transaction Log Shipping without connection to primary server

I'm having a hard time with SQL Transaction Log Shipping with the following premisses: Server A, where data gets loaded to the database Server B is on a remote location The two servers never share ...
2
votes
1answer
165 views

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 ...
3
votes
4answers
2k views

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 ...
0
votes
1answer
250 views

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 ...
0
votes
1answer
35 views

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\ ...
1
vote
1answer
150 views

Is there a convenient way to manually copy the Log Shipping *.trn files from one SQL 2008 server to another?

We have a remote SQL 2008 server (ServerB) that needs to keep a warm (15 minute interval is OK) copy of production data (ServerA). ServerA is also SQL 2008. Log Shipping looks like it will do the job. ...
1
vote
1answer
201 views

log shipping of biztalk database on SQL server 2008 standard edition

I want to do log shipping for biztalk databases on SQL server 2008 standard edition (server A) to another SQL server 2008 standard edition (server B). I was told that for biztalk, logshipping is not ...
2
votes
2answers
906 views

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 ...
0
votes
1answer
230 views

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, ...
1
vote
2answers
473 views

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 ...
0
votes
1answer
458 views

Changing from database mirroring to transaction log shipping

I'm considering dumping database mirroring and go with transaction log shipping on our SQL Server 2008 Standard server instead, because there's a noticeable performance hit due to the principal being ...
0
votes
2answers
2k views

SQL log shipping for reporting

I would like to create a read-only copy of my SQL Server 2008 database on a secondary server for reporting and analysis. I've been testing log shipping, configured to run every 5 minutes or so. ...
1
vote
5answers
1k views

SQL Server 2008 Log-shipping: Without a UNC drive: how? [closed]

My real question here is... is there a tool I can use? (E.g. I have a lot to do, and would prefer not to script it all up myself!) Anyone using the redgate (hmmm, they had a tool for this, but I do ...