Post reply

Compressed Backups- SQL Server 2008 32 bit to SQL Server 2014 64 bit

  • March 24, 2017 at 7:45 am

    #328896

    Hello,

    I wanted to know if we use the compressed backups option  ( full backup with compression ) to move  large production databases during a migration project  from 32 bit SQL Server 20008 to SQL Server 2014 64 bit will it cause any data issues?

    I know CPU will be pegged, which we can live with.

    Will it be intact like  aFULL BACKUP without compression is my question.

    Thanks in Advance

  • March 24, 2017 at 8:04 am

    #1934759

    You shouldn't have issues, just keep in mind, the databases will be upgraded during restore on 2014, so keep the 2008 backups until your migration is signed off as successful. 
    not sure what you mean with "Will it be intact like aFULL BACKUP without compression is my question."

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • March 24, 2017 at 8:34 am

    #1934776

    Restoring a backup from a 32 bit install to a 64 bit install shouldn't be a problem, I've done that myself a number of times during upgrades like this.  You can check it with RESTORE VERIFYONLY to double check it but there's no reason other than bad media that it would not be in-tact. 
    https://msdn.microsoft.com/en-us/library/ms188902.aspx
    Compression won't harm the integrity of the data in any way, just spend some CPU cycles for I/O savings.

  • March 24, 2017 at 9:33 am

    #1934800

    sqlguy80 - Friday, March 24, 2017 7:45 AM

    Hello,

    I wanted to know if we use the compressed backups option  ( full backup with compression ) to move  large production databases during a migration project  from 32 bit SQL Server 20008 to SQL Server 2014 64 bit will it cause any data issues?

    I know CPU will be pegged, which we can live with.

    Will it be intact like  aFULL BACKUP without compression is my question.

    Thanks in Advance

    There is no difference in the files between 32 and 64 bit or the way the data is compressed onto disk

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply