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.

Filter by
Sorted by
Tagged with
0 votes
2 answers
54 views

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 ...
user avatar
  • 13
0 votes
1 answer
377 views

SQL: server 2008 database stuck in Restore

I have two SQL Server 2008 R2 servers one for PROD and the other for DR. I am trying to add log shipping for a database called School. Steps so far Back up School database Restore with database ...
user avatar
0 votes
2 answers
37 views

How I can get db's current restore mdoe status by query?

So, my db can be in three differrent statuses. RECOVERY NORECOVERY STANDBY And I want to know current db's status by query. Can you help me ? The single what I've found is SELECT is_in_standby ...
user avatar
  • 101
4 votes
1 answer
117 views

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 ...
user avatar
  • 299
0 votes
2 answers
175 views

Log Shipping and Security for reporting

I have a SQL 2008 server with a database replicated via log shipping to a reporting server. The reporting server database gets updated once a day. The reporting server database is left in Standby/Read-...
user avatar
3 votes
1 answer
3k views

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 ...
user avatar
0 votes
1 answer
7k views

Bring back to restoring state an online database

I configured logshipping for a database. I did some tests and tried a controlled failover. During log shipping secondary db is in restoring state. To have a controlled failover i stopped the primary ...
user avatar
  • 107
1 vote
0 answers
257 views

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 ...
user avatar
  • 53
3 votes
1 answer
2k views

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 ...
user avatar
1 vote
2 answers
240 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 crazy-...
user avatar
  • 1,150
1 vote
2 answers
8k views

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 ...
user avatar
  • 191
0 votes
1 answer
166 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 ...
user avatar
1 vote
1 answer
82 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 ...
user avatar
2 votes
1 answer
1k 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 ...
user avatar
  • 1,728
3 votes
1 answer
810 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 ...
user avatar
  • 652
2 votes
1 answer
469 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 ...
user avatar
0 votes
2 answers
695 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 ...
user avatar
  • 5
2 votes
1 answer
655 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 ...
user avatar
0 votes
1 answer
920 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 ...
user avatar
2 votes
4 answers
750 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 ...
user avatar
1 vote
1 answer
590 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 ...
user avatar
  • 333
0 votes
1 answer
81 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 ...
user avatar
  • 1,218
1 vote
1 answer
559 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 a ...
user avatar
0 votes
2 answers
926 views

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: ...
user avatar
2 votes
1 answer
193 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 ...
user avatar
  • 149
5 votes
4 answers
5k 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 backup/...
user avatar
  • 161
0 votes
1 answer
653 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 ...
user avatar
  • 291
0 votes
1 answer
48 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\ ...
user avatar
1 vote
2 answers
3k views

How to achieve the following RTO & RPO with logshipping only using SQL Server?

Trying to come up with viable backup restore & logshipping solution for achieving the following: 15 minutes Recovery Point Objective (no more than 15 minutes data loss at any time) 5 minutes ...
user avatar
1 vote
1 answer
317 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. ...
user avatar
  • 45
1 vote
1 answer
263 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 ...
user avatar
  • 333
2 votes
2 answers
1k 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 ...
user avatar
  • 235
0 votes
1 answer
249 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, ...
user avatar
1 vote
2 answers
547 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 ...
user avatar
0 votes
1 answer
474 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 ...
user avatar
  • 133
0 votes
2 answers
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. Alas,...
user avatar