-2
votes
0answers
31 views

log shipping backup job getting failed frequently

Even i am facing similar issue some of the log backups are getting failed for the same reason stated above the first possibility that came to my mind was the same it could have been a network issue or ...
0
votes
1answer
52 views

Creating Users on secondary server in log shipping

I have a production Server say ServerA I have setup log shipping to ServerB which is left in read-only mode. The purpose of this log shipping is to lower the load on production server for some ...
0
votes
0answers
41 views

How to configure log shipping in SQL Server 2008 R2 Standard Edition

Could you please guide me on how to configure log shipping in SQL Server 2008 R2 Standard Edition for same hostname with two different IP's. (Primary and Secondary server) example: Primary machine ...
3
votes
1answer
58 views

Log Shipping in lieu of replication

I have two SQL Server 2008 R2 systems that, due to network restrictions, cannot use SQL Server replication. However, data needs to be shared between these systems. It may be possible to send a file ...
1
vote
0answers
51 views

Log shipping on secondary server

Log shipping fails with the below error. Sql agent on secondary server has access to the folder and files in security. It is not a firewall issue. I created the jobs using the LS scripts as it fails ...
0
votes
2answers
113 views

Resume log shipping from a specific transaction

Is it possible to force SQL Log Shipping to run from a given .trn file onward? I have two databases, where one ships to another this was working fine. However I had to restore the primary database ...
1
vote
1answer
113 views

Approaches for Real time copy of database on same SQL Server instance

I have a draft of requirements that look like this: Production database should be copied in real-time to "Pre-prod" database The Pre-prod database should be available to read and update It should be ...
0
votes
5answers
346 views

Mirroring vs. Log Shipping

The software company I work for is planning to migrating our infrastructure into the cloud. Our current focus is to find the best database replication method. Current Servers: SQL Server 2008 SE - ...
3
votes
1answer
388 views

How does Log shipping knows to keep track

I have set up log shipping between 2 SQL Servers (SQL Server 2008 and SQL Server 2012). At first i took a full backup of the first one and restored it on the other one and than i set up the log ...
0
votes
2answers
119 views

How does Log shipping knows to keep track [duplicate]

I have set up log shipping between 2 SQL Servers (SQL Server 2008 and SQL Server 2012), At first i took a full backup of the first one and restored it on the other one and than i set up the log ...
3
votes
1answer
368 views

Why does Log Shipping .TRN file copy just stop

I apologize in advance for a long post but I have had it up to here with this error of having to delete LS configuration and starting it over for any DB thats got this error. I have LS setup on 3 ...
0
votes
1answer
192 views

Create Log Shipping Step Failed After ServerName Changed

I was doing some test on server name change and encounter some errors. Here is the original setup: Server name - ServerA, SQL Server default instance - ServerA Changes: Server name - ServerB Before ...
0
votes
0answers
57 views

Copy tables from a stand-by database

I want to explain the following. I have a database that is a recovery db from our main environment. This database is kept up-to-date through log shipping. However, I want to copy all tables from this ...
1
vote
1answer
48 views

Inhibit Sql Server Log Shipping Alerts during certain times

There are batch jobs that occur in the middle of the night, which cause log shipping backups to be delayed such that they exceed the alert threshold, and alerts are then emailed. How can I disable ...
0
votes
2answers
126 views

which sql server edition is good for practice [closed]

Which SQL Server (free/trail) would be good to install, which requires minimum resource and have maximum features. I mean, I can practice mirroring,logshipping and replication. I found this link, but ...
0
votes
1answer
133 views

Can I deactivate log shipping jobs without raising errors?

I've set up log shipping from Server A to Server B. I then set it up from B to A when B was the primary. I've reverted back to A being primary and disabled the backup, copy and restore jobs ...
2
votes
2answers
271 views

Bandwidth comparison between log shipping and transactional replication

Which technique uses more network bandwidth: Log shipping Transactional Replication Can some one share any benchmarks for the same ? What would be the Memory and I/O impact on the Primary server ...
3
votes
2answers
755 views

Migrate SQL Server database to multiple files (shrinkfile emptyfile vs log shipping)

I have a SQL Server 2008 database in production that we are moving onto a new server. The current database has a single ~400GB .MDF file. The new server will be running SQL Server 2012, and we are ...
2
votes
0answers
85 views

Can the same database be log-shipping secondary and primary at the same time?

Here is my scenario: Database DB1 on Server1 is log shipping primary in data center. Database DB1 on Server2 is log shipping secondary; Server2 is in remote location. Logs are shipped from data ...
4
votes
1answer
2k views

Log Shipping - RESTORE WITH STANDBY - on SQL Server 2012 keeps breaking

We are using log shipping and RESTORE WITH STANDBY on SQL Server 2012 in order to restore the database in read-only mode for reporting purposes. However, the log shipping setup keeps breaking after ...
3
votes
0answers
259 views

SQL Server Database Hot Backups: Which Technique(s) to Use for Multi-Level Replication?

I'm reading the many other posts here about mirroring vs. replication, but I'd still appreciate it if someone with some experience would weigh in. My small development team needs to have local ...
1
vote
1answer
137 views

Can I run a Report Server and a Mirror server from a working Log Shipping secondary instance? [closed]

Our setup: City A - Primary server for logshipping City B - Secondary server for logshipping Now there is a lot of data being updated from A - B. And the server in City B is underutilized, and it ...
4
votes
1answer
160 views

What are the advantages of a monitor server for log shipping

I'm researching and implementing log shipping as part of disaster recovery for our SQL server. I've seen that a monitor server is recommended (but not required) for monitoring the log shipping ...
2
votes
2answers
86 views

Advice about Backup Solution

Our database Server is being hosted by another company. They provide a file level backup that occurs once per day. They also allow for Log Shipping. My company is taking advantage of their ...
2
votes
2answers
74 views

Log shipping and log file: Can the log on the master or slave every be truncated/shrunk?

SQL Server 2008, standard log shipping setup (well, using redgate, but it is a pretty normal flow). On the replica, the log file is pretty big. Wondering if on the backup/replica servers it is OK to ...
1
vote
4answers
2k views

How to prevent SQL Server database server from running out of disk space?

What are the best preventive approaches that we can do to prevent the SQL Server database server from running out of disk space ? Is there a way to set the maximum database file size (both the ...
1
vote
1answer
405 views

Logshipping alert emails are being sent out while there is no error

I have logshipping setup with a Primary and a Secondary, and this has been working fine for a long time. Yesterday I started reveiving these emails: The log shipping primary database ...
3
votes
1answer
566 views

Log shipping setup across domains

I'm running SQL Server 2008 R2 on a Windows machine. I've been tasked with setting up log shipping between our production site (managed by a service provider) and our QA environment which is hosted ...
1
vote
3answers
327 views

Does Log-Shipping need Transaction Log Backup from Primary Server?

In this video tutorial it is explained that we should use the transaction log backup of the primary server database and restore it into the secondary server database for log shipping. I was doing a ...
2
votes
1answer
198 views

SQL Server 2008 log shipping via JungleDisk

Has anyone used Jungle Disk as a common location for SQL Server 2008 log shipping? We use it for backup already and I think it can be used for taking log backup to our off-site location. It seems ...
1
vote
2answers
254 views

Is Log Shipping or Mirroring a better solution for Disaster Recovery?

I am planning an index rebuild, however my logs are prone to huge overblown sizes. In fact I was leaning towards doing an intelligent re-indexing, but since the fragmentation levels are greater than ...
6
votes
1answer
361 views

Can SQL Express be used as a Log Shipping monitor server?

I'm keen to setup a "Monitor Server". We have SQL 2008 R2 Enterprise edition on both primary and secondary servers. Can we use SQL Express in monitoring server setup for licencing purposes?
2
votes
2answers
363 views

Log-shipping : Broken Chain

If a write on log shipping transaction backup gets corrupted on one of the transaction file due to network or media issue, and hence the log shipping chain gets broken, is there any other way to ...
2
votes
1answer
357 views

log shipping backup fails every so often on only one server

I was asked to change the DFS share for our log shipping on all our SQL servers (SQL 2008 on windows 2008) to point to the new share due to some IO issues on the previous one. But now, ocassionally, ...
0
votes
1answer
5k views

How to Delete Restoring Database

I am running log shipping with SQL server 2008 R2. I have a situation where the secondary database drive ran out of space and was not applying log shipping transaction logs. The way I want to fix ...
3
votes
2answers
214 views

Reduce load off primary server by using log shipping, or mirroring, or something else?

I have previously asked the below question about LogShipping frequencies, but I think I might be approaching this problem incorrectly (LogShipping frequency) Problem I have a high volume site that I ...
2
votes
2answers
334 views

LogShipping frequency for backup/copy/restore

I wish to create a LogShipping job that runs every 5 minutes. What is the best way to do this so that the backup/copy/restore does not collide? Maybe Sql server knows how to handle this, but I was ...
3
votes
1answer
830 views

SQL Backups - Full vs Differential vs Log Shipping

I'm looking to refine our SQL backups utilizing Full, Differential, and Log Shipping. Currently, I am only performing full backups once at night. This process is taking so long that it is running ...