GilaMonster (1/11/2011)
Henrico Bekker (1/11/2011)
If your source SQL Server is on a newer Service Pack level, your destination needs to be the same.You can, in the vast majority of cases, restore from a higher service pack number to a lower, providing the two servers are the same major version. ie SQL 2000 SP4 -> SQL 2000 SP2 is fine. SQL 2005 -> SQL 2000 is not ok.
The exception is SQL 2005 SP2 to lower service packs of SQL 2005 if vardecimal storage has been enabled.
Thanx for clearing that up Gail.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle