2000 vs 2005

[yetanotherjo]

Dilema - I have 2 databases, each to be administered by different locations. They will share backups between them so each has a recent copy of the other. We were going to upgrade both to 2005 Express as one is getting too big for MSDE but that office is now getting a new server, with Small Bus so SQL 2000 standard. This solves the file size problem there, but what of versioning issues if the remote site is 2005 Express???....My conclusion was all too hard, ignore the fact we now have 2000 at one site and still have both on 2005 Express. Any other ideas, anyone? (Replication is not a good option at this point in time due to communication technology issues hence the .bak files flitting across the countryside).

 

[mrdenny]

If you will be sharing backups between the servers they will both need to be the same version.

Check out SQL 2005 Workgroup edtion. It's a bigger version that SQL 2005 Express, but not as expensive as SQL 2005 Standard.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[yetanotherjo]

Will do. Thanks Denny.

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com