• it is not necessary to upgrade, no; the database backup is the same, regardless of service pack, version, and that's what you would backup/restore. the service packs / CU change how the engine behaves, and not how the backup is stored.

    one thing i'd mention is to make sure you update statistics; the stats are used differently between engine versions, and not updating statistics often leads to reports of "the new super server with 40 petabytes of RAM is slower than the old server" until that is done.

    something like this is what i've suggested int eh past:

    DECLARE @Exec VARCHAR(MAX)

    SELECT @Exec = ''

    SELECT @Exec = 'UPDATE STATISTICS '

    + QUOTENAME(schema_name(schema_id))

    + '.'

    + quotename(name)

    + ' WITH FULLSCAN ; '

    + CHAR(13)

    + CHAR(10) + @Exec FROM sys.tables ORDER BY name DESC

    PRINT LEN(@Exec)

    PRINT @Exec

    EXEC(@Exec)

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!