Monday, February 20, 2012

Log Shipping (SQL 2000) btwn OS versions?

Has anyone noticed any problems logshipping in a SQL 2k Ent. Ed.
environment with Windows 2k to a SQL 2k Ent. Ed. with Windows 2003?
Thanks!yellowbug wrote:
> Has anyone noticed any problems logshipping in a SQL 2k Ent. Ed.
> environment with Windows 2k to a SQL 2k Ent. Ed. with Windows 2003?
> Thanks!
>
Care to be more specific? What sort of problems?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||We are doing a data center migration to a new location and I was hoping
to upgrade our disaster recovery servers to windows 2003 during this
migration. However the front end machines will be on windows 2000 for
at least a few more months. So I thought I'd throw a feeler out there
and see if anyone has had any problems with this type of configuration.
Thanks :)|||yellowbug wrote:
> We are doing a data center migration to a new location and I was hoping
> to upgrade our disaster recovery servers to windows 2003 during this
> migration. However the front end machines will be on windows 2000 for
> at least a few more months. So I thought I'd throw a feeler out there
> and see if anyone has had any problems with this type of configuration.
> Thanks :)
>
SQL backups are just files to the OS, nor does the OS have anything to
do with the restore of those backups. Are you using a home-grown log
shipping method, or the wizard-driven stuff that SQL provides? Either
way, I don't foresee that you'd have any problems due to the different
OS versions.
Tracy McKibben
MCDBA
http://www.realsqlguy.com

No comments:

Post a Comment