Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alan_g23
Starting Member
2 Posts |
 Posted - 2001-02-02 : 19:30:02
|
| Hi all,My first post and my apologies if I sound like a rookie. Anyway, we are in the process of upgrading our SQL server machine (both hardware and software) from 7.0 to 2000. Since this is our production environment, I would like to do this with as little down time as possible. Hence the topic of log shipping. I am in the middle of testing this and am currently "stuck." According to the documentation, log shipping between 7.0 (source) and 2000 (destination) is possible by doing a manual setup. Here's what I have done so far:1. On the 7.0 SP2 server, I've turned set the following db_option to "upgrade pending" to "True".2. Made a full backup of the DB.3. Restored the backup to the 2000 server with a standby option I received the following errors, "Msg 3108: This backup cannot be restored using WITH STANDBY. A database upgrade is needed. Reissue restore without the WITH STANDBY option."4. That didn't work so I restored the database with NORECOVERY so that I'll be able to restore the trans log backups.5. That went well and manually setup log shipping using the "sp_add_log_shipping_plan" and "sp_add_log_shipping_plan_database" stored procedures in Msdb.6. the log shipping job fails stating the same errors as number 3.Anyone have any ideas? Or is this even possible?Your help is very much appreciated. ThanksAlan GarciaDatabase Administrator |
|
|
|
|
|
Upgrading to 2000 using log shipping