Restoring DB to SQL Server 2005 SP3 from SQL Server SP2

I am migrating data from one SQL Server to another.
The old server is SQL Server 2005 SP2 and the new server is SQL Server 2005 SP3.

Is anyone aware of any issues with the above? Do both servers need to be at the same SP level for the backup from one and restore to another to work?

Thanks

asked Dec 09 '09 at 09:47 AM in Default

user-720 (google)
32 ● 2 ● 2 ● 2

(comments are locked)

3 answers:

Moving up generally works just fine. Moving down can be problematic or might even fail. It's best to keep all your servers up to the same service pack and hot fix level.

answered Dec 09 '09 at 10:36 AM

Grant Fritchey ♦♦
64.9k ● 13 ● 20 ● 66

Definitely - a concrete example being the OBJECT_SCHEMA_NAME function which wasn't in 2005 RTM, but appeared in SP2.

Dec 09 '09 at 12:25 PM Matt Whitfield ♦♦

(comments are locked)

No, it should be just fine.

answered Dec 09 '09 at 10:23 AM

Rob Farley
5.7k ● 14 ● 17 ● 19

(comments are locked)

Thanks guys I tried it and it worked just fine - no issues

answered Dec 10 '09 at 04:55 AM

Abdul 1
1

(comments are locked)

Your answer

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Topics:

sql-server-2005 x1843
restore x95

asked: Dec 09 '09 at 09:47 AM

Seen: 1559 times

Last Updated: Dec 09 '09 at 11:17 AM

Restoring DB to SQL Server 2005 SP3 from SQL Server SP2

Follow this question

Related Questions