Hello,
I want to setup SQL Log Shipping btwn two servers.
- Do the servers have to run same version of Windows? Can one be Win2003 and
the other Win2K Server? Or one Win2k Advanced and one Win2k Standard Server?
- Do I have to run the same version/build/ServicePack of SQL Server?
many thanks
christos
If you are using the Enterprise Edition of SQL Server's Log Shipping
functions both SQL Server's have to be Enterprise Edition. If you are
rolling your own version of Log Shipping, there are no SQL Server version
requirements or OS requirements (other than NT workstation/server, XP
professional, Win2k server/professional, Windows 2003).
"Christos Kritikos" <ChristosKritikos@.discussions.microsoft.com> wrote in
message news:D025AB19-599D-4806-9817-2804C182F38A@.microsoft.com...
> Hello,
> I want to setup SQL Log Shipping btwn two servers.
> - Do the servers have to run same version of Windows? Can one be Win2003
and
> the other Win2K Server? Or one Win2k Advanced and one Win2k Standard
Server?
> - Do I have to run the same version/build/ServicePack of SQL Server?
> many thanks
> christos
>
Showing posts with label btwn. Show all posts
Showing posts with label btwn. Show all posts
Friday, March 23, 2012
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
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
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
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
Subscribe to:
Posts (Atom)