Please don't post independently in multiple newsgroups. You can add the
other newsgroups in the "Newsgroups" section in the header and it will show
up in all those simultaneously as will the answers. See my reply in the
Andrew J. Kelly
SQL Server MVP
Quote:> How to clone an existing production running SQL2k SP2 on a
> Different Machine running SQL2K with SP3. Transfer all
> user logins and security roles and all other objects.
> Basically I'm trying to clone Production environment.
Guess what? Developers didn't test properly and we found compatibility
problems on SQL2K SP3.
In our test envirnoment, we have had no problems restoring a SP3 database
back to a SP2 environment. Is this an "allowed practice"? Does anyone know
of any potential problems with this?
Many thanks in advance.