473,320 Members | 1,699 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Log shipping in sql server 2000

What are the reasons to failure of log shipping ?
Aug 12 '07 #1
0 772

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: ^CrAsH^ | last post by:
Hi to all, i've a "problem" with log shipping in sql server 2000 sp3. My log shipping works fine, but the task does not update log_shipping_primaries table on secondary server, and so log shipping...
0
by: Eric | last post by:
Hi, Ive a few questions and would be grateful for any assistance/comments from experience as Ive not that much dba experience , we have 3 servers all containing sql 2000 standard edition, two...
7
by: Steve Wechsler | last post by:
I thought I'd give the SQL Server 2000's log shipping wizard a try (in the past I've always done it with Perl scripts), so I attemted to set it up on one of my servers. But in the maintenance plan...
4
by: Jason Huang | last post by:
Hi, In the MS SQL 2000 Server, if the log shipping is set up right, does that mean data in primary server changed will mapped to secondary server later on? Thanks. Jason
1
by: Jennie | last post by:
I am implementing Log Shipping. I have the transaction logs copying to the standby server and applying to the standby database with no errors. However, I am having problems with the role...
0
by: InProcess | last post by:
We have successfully implemented Log Shipping between two MS SQL Server 2000 servers (bothe SP3). The problem we are having is two fold: 1) The tran log on the primary server is not being truncated...
8
by: clintonG | last post by:
Membership is broken and who knows what else. Does anybody have any referrals to current documents that explain what was changed and how one might respond? <%= Clinton Gallagher...
1
by: GB | last post by:
Hello: I'm using MS SQL Server 2000 developer edition and trying to implement log shipping to the secondary server. I copied a database MDF and LDF files from primary to secondary server and all...
1
by: theSpinel | last post by:
Is it possible to failover a single or a selected number of databases onto a standby server? We're currently log shipping about 12 databases to a standby and I was wondering if it was possible to...
0
by: Julie Graham | last post by:
I'm having issues setting up log shipping on a remote server. We have a very large production database that needs to be migrated offsite. The db is 9 GB backed up. It takes about 4 hours to copy...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.