Restore to different version of 2003 OS

Hello,
I have a client with a database and want to use a second server as warm spare.
Primary server is 2003 Std and the spare is 2003Ent.
I've heard that the OS must be the same to restore.
I can understand the SQL needs the same version 2000 and service pack level
on each server but what about the OS?
Thanks in advance
Kevin
"Kevin1aB" <Kevin1aB@.discussions.microsoft.com> wrote in message
news:5B30FD35-4E84-474F-8240-E812C27E548A@.microsoft.com...
> Hello,
> I have a client with a database and want to use a second server as warm
> spare.
> Primary server is 2003 Std and the spare is 2003Ent.
> I've heard that the OS must be the same to restore.
> I can understand the SQL needs the same version 2000 and service pack
> level
> on each server but what about the OS?
>
The OS can be different.
David
|||To restore a system database, the SQL build numbers must match exactly. To
restore a non-system database, the major levels must match (I.E 7.0, 8.0,
9.0 etc). The operating system does not matter as long as it is supported
for that release of SQL.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Kevin1aB" <Kevin1aB@.discussions.microsoft.com> wrote in message
news:5B30FD35-4E84-474F-8240-E812C27E548A@.microsoft.com...
> Hello,
> I have a client with a database and want to use a second server as warm
> spare.
> Primary server is 2003 Std and the spare is 2003Ent.
> I've heard that the OS must be the same to restore.
> I can understand the SQL needs the same version 2000 and service pack
> level
> on each server but what about the OS?
> Thanks in advance
> Kevin
|||While I agree with what the others have posted, you are going to test this
all first, right?
"Kevin1aB" wrote:

> Hello,
> I have a client with a database and want to use a second server as warm spare.
> Primary server is 2003 Std and the spare is 2003Ent.
> I've heard that the OS must be the same to restore.
> I can understand the SQL needs the same version 2000 and service pack level
> on each server but what about the OS?
> Thanks in advance
> Kevin
|||Thanks to all who posted. I will test it in the next week or so.
Regards,
Kevin B
"ChrisR" wrote:
[vbcol=seagreen]
> While I agree with what the others have posted, you are going to test this
> all first, right?
> "Kevin1aB" wrote: