Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Log Shipping

Status
Not open for further replies.
JoshuaThompson

JoshuaThompson

Technical User
Aug 7, 2008
50
US
I have two servers that are running SQL 2005. One acts as a primary db server the other is the secondary db server.

Log shipping has been configured and is working perfectly. The secondary server is in sync with the primary (within 15 minutes).

If I reboot the primary server will this break log shipping? I know that the secondary will get a little out of sync while the primary is rebooting but will it eventually catch back up?
 
Sort by date Sort by votes
I have log shipping between two servers that has been running for several years. I've rebooted both many times without any problems.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

GCL2007
  • Locked
  • Question
Simple Recovery model - Huge Trans Log
Replies
0
Views
160
GCL2007
GCL2007
JScannell
  • Locked
  • Question
SQL login on Classic ASP localhost site
Replies
0
Views
166
JScannell
JScannell
RRinTetons
  • Locked
  • Question
SQL Server 2008 R2 login auditing
Replies
0
Views
155
RRinTetons
RRinTetons
RRinTetons
  • Locked
  • Question
Logging into a database using SSMS from non-domain machine
Replies
1
Views
207
fredericofonseca
fredericofonseca
simian336
  • Locked
  • Question
Logins Per Second
Replies
0
Views
63
simian336
simian336

Part and Inventory Search

Sponsor

Back
Top