Schema Changes in 2005 SP3? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Schema Changes in 2005 SP3?

Author

Topic

dbthj
Posting Yak Master

143 Posts

Posted - 2010-10-13 : 12:53:17

Does anyone know if it is safe to move a database from
a 2005 SP3 instance to a 2005 SP2 instance?

Yes, I know I should be applying SP4 everywhere, but this is a production environment and we have extra red tape for that kind of thing. It would be a lot quicker to just take a backup here, and restore it there.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-13 : 13:00:02

SP4 doesn't exist yet.

I don't think restore supports going down level from SP3 to SP2.

I would say that this is unsafe though as the minimum build for production SQL Server 2005 servers should be 4262, which is SP3 + last October's critical security hotfix.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-13 : 13:22:35

Databases created in SQL 2005 SP3 will restore just fine to SP2 installations.

That said, I agree with Tara that you should upgrade ASAP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources