x

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

more ▼

asked Dec 09, 2009 at 09:47 AM in Default

user-720 (google) gravatar image

user-720 (google)
32 2 2 2

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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.

more ▼

answered Dec 09, 2009 at 10:36 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

Definitely - a concrete example being the OBJECT_SCHEMA_NAME function which wasn't in 2005 RTM, but appeared in SP2.
Dec 09, 2009 at 12:25 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

No, it should be just fine.

more ▼

answered Dec 09, 2009 at 10:23 AM

Rob Farley gravatar image

Rob Farley
5.7k 16 18 20

(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Dec 10, 2009 at 04:55 AM

Abdul 1 gravatar image

Abdul 1
1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

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

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1951
x103

asked: Dec 09, 2009 at 09:47 AM

Seen: 2353 times

Last Updated: Dec 09, 2009 at 11:17 AM