The log-shipping tag has no wiki summary.
0
votes
0answers
44 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
votes
1answer
39 views
Directory lookup failed during log shipping
I have configured log shipping for all our SharePoint 2010 databases. All worked well since Friday and today Monday I ran this query:
SELECT *
FROM [msdb].[dbo].[sysjobhistory]
WHERE [message] like ...
1
vote
1answer
17 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
78 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
41 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
111 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 ...
0
votes
2answers
151 views
Resume Logshipping after Primary database restored
We have Database (D1) as a primary database and Log shipping setup to the secondary database called (LS_D1). Now what we are doing is taking backup of D1 database and restore it on D2 database. We do ...
0
votes
1answer
144 views
Getting timeouts and backup errors after mirroring and log shipping is setup
OS is Windows Server 2003 32 bit. SQL Server is SQL Server 2008 SP3 32 bit
Today I finished configuring database mirroring and log shipping for 3 databases on this SQL instance and started receiving ...
3
votes
2answers
210 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
60 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 ...
2
votes
0answers
389 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 ...
2
votes
0answers
123 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
62 views
Can I run a Report Server and a Mirror server from a working Log Shipping secondary instance?
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
72 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
75 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 ...
