Tagged Questions
0
votes
1answer
42 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
29 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 ...
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 ...
1
vote
2answers
207 views
SQL Log Shipping Firewall settings [closed]
I'm attempting to setup log shipping between two differnet domains. When I attempt to connect to the secondary server instance the primary server fails to connect. If I turn off the windows firewall ...
3
votes
1answer
258 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 ...
2
votes
2answers
315 views
rebuilding indexes and logshipping?
We all know that index rebuilding creates lot of log growth..so what changes would you consider to your logshipping side to accomodate this log growth?
Do we increase the frequency of the ...
6
votes
1answer
168 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?
