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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

log shipping sql2000

Status
Not open for further replies.
needscoop

needscoop

Programmer
Nov 13, 2002
29
US
in a nutshell (another person is working on this, not me)

SqlServer2000
log shipping transfers trans logs to secondary server, but
restoring the trans logs on secondary server works for awhile, but then seems to hang.

What could cause this? nonlogged transactions? anything else come to mind? (there are no users to contend with)
 
Sort by date Sort by votes
never mind... KB #314515 gave us some insights about it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Auguy
  • Locked
  • Question
SQL 2014 Truncate Log File
Replies
2
Views
114
Auguy
Auguy
Jago11
  • Locked
  • Question
When to use 1=1 logic 1
Replies
7
Views
220
Andrzejek
Andrzejek
Marclem
  • Locked
  • Question
Get Opinio Last Login Data
Replies
5
Views
206
Andrzejek
Andrzejek
EM1107
  • Locked
  • Question
Restore a database with a backup having a damage transaction log.
Replies
3
Views
100
gmmastros
gmmastros
ghbeers
  • Locked
  • Question
Using the below tables and the logi
Replies
2
Views
47
ghbeers
ghbeers

Part and Inventory Search

Sponsor

Back
Top