"Thomas Malia" wrote:

> I need to do the following and want to know if anyone knows of a reason why
> this might be problematic:
>
> 1) Backup a set of databases on a SQL 2005 Server Entperise Edition  (32
> bit)
> 2) Restore those backups to a SQL 2005 Server Enterprise Edition (64 bit)
> 3) Perform some application specific upgrade
>     a) Specifically, We are upgrading Microsoft Dynamics SL database from
> version 5.5 to version 7.0 SP1
> 4) Backup the upgraded database on the 64 bit server
> 5) Restore the upgraded databases back on the 32 bit server
>
> The step that has me particularly concerned is step 5.  Is there any problem
> with restoring a database that had been on a 64 bit SQL Server to a 32 bit
> SQL Server?  Are there issues with datatypes or anything?
>
> Thanks in advance,
> Tom Malia
>
>
>

> AFAIK, there's no problem with that
>
> --
> --
> Un saludo
> -------------------------------www.navento.com
> Servicios de Localización GPS
>
>
>
> "Thomas Malia" wrote:
> > I need to do the following and want to know if anyone knows of a reason why
> > this might be problematic:
>
> > 1) Backup a set of databases on a SQL 2005 Server Entperise Edition  (32
> > bit)
> > 2) Restore those backups to a SQL 2005 Server Enterprise Edition (64 bit)
> > 3) Perform some application specific upgrade
> >     a) Specifically, We are upgrading Microsoft Dynamics SL database from
> > version 5.5 to version 7.0 SP1
> > 4) Backup the upgraded database on the 64 bit server
> > 5) Restore the upgraded databases back on the 32 bit server
>
> > The step that has me particularly concerned is step 5.  Is there any problem
> > with restoring a database that had been on a 64 bit SQL Server to a 32 bit
> > SQL Server?  Are there issues with datatypes or anything?
>
> > Thanks in advance,
> > Tom Malia- Hide quoted text -
>
> - Show quoted text -

"Thomas Malia" <tomma***@worldnet.att.net> wrote:

> I need to do the following and want to know if anyone knows of a reason why
> this might be problematic:
>
> 1) Backup a set of databases on a SQL 2005 Server Entperise Edition  (32
> bit)
> 2) Restore those backups to a SQL 2005 Server Enterprise Edition (64 bit)
> 3) Perform some application specific upgrade
>     a) Specifically, We are upgrading Microsoft Dynamics SL database from
> version 5.5 to version 7.0 SP1
> 4) Backup the upgraded database on the 64 bit server
> 5) Restore the upgraded databases back on the 32 bit server
>
> The step that has me particularly concerned is step 5.  Is there any problem
> with restoring a database that had been on a 64 bit SQL Server to a 32 bit
> SQL Server?  Are there issues with datatypes or anything?
>
> Thanks in advance,
> Tom Malia
>
>

"Aaron Bertrand" <aaron.bertr***@gmail.com> wrote in message
news:C550602D.62B9%aaron.bertrand@gmail.com...
>I am not sure about problems with Dynamics after said upgrade, but as for
> SQL Server itself, we do this and have not encountered any issues yet.
>
>
> On 11/24/08 10:20 AM, in article #S661gkTJHA.1***@TK2MSFTNGP02.phx.gbl,
> "Thomas Malia" <tomma***@worldnet.att.net> wrote:
>
>> I need to do the following and want to know if anyone knows of a reason
>> why
>> this might be problematic:
>>
>> 1) Backup a set of databases on a SQL 2005 Server Entperise Edition  (32
>> bit)
>> 2) Restore those backups to a SQL 2005 Server Enterprise Edition (64 bit)
>> 3) Perform some application specific upgrade
>>     a) Specifically, We are upgrading Microsoft Dynamics SL database from
>> version 5.5 to version 7.0 SP1
>> 4) Backup the upgraded database on the 64 bit server
>> 5) Restore the upgraded databases back on the 32 bit server
>>
>> The step that has me particularly concerned is step 5.  Is there any
>> problem
>> with restoring a database that had been on a 64 bit SQL Server to a 32
>> bit
>> SQL Server?  Are there issues with datatypes or anything?
>>
>> Thanks in advance,
>> Tom Malia
>>
>>
>

"Thomas Malia" <tomma***@worldnet.att.net> wrote in message
news:%23S661gkTJHA.1332@TK2MSFTNGP02.phx.gbl...
>I need to do the following and want to know if anyone knows of a reason why
>this might be problematic:
>
> 1) Backup a set of databases on a SQL 2005 Server Entperise Edition  (32
> bit)
> 2) Restore those backups to a SQL 2005 Server Enterprise Edition (64 bit)
> 3) Perform some application specific upgrade
>    a) Specifically, We are upgrading Microsoft Dynamics SL database from
> version 5.5 to version 7.0 SP1
> 4) Backup the upgraded database on the 64 bit server
> 5) Restore the upgraded databases back on the 32 bit server
>
> The step that has me particularly concerned is step 5.  Is there any
> problem with restoring a database that had been on a 64 bit SQL Server to
> a 32 bit SQL Server?  Are there issues with datatypes or anything?
>
> Thanks in advance,
> Tom Malia
>

"Thomas Malia" <tomma***@worldnet.att.net> wrote in message
news:OYTYxFqTJHA.1172@TK2MSFTNGP03.phx.gbl...
> Fantastic!
>
> Thanks all!
>
> Follow-up question.... what are your thoughts about simply detaching
> the database files from one server and moving them to the other then
> reattaching there instead of going through the time and trouble of
> running backs and restores?
>
> One of the databases is currently something like 175 Gigs and it
> takes for ever to backup, then forever to copy the BAK files then
> forever to restore.... if I could get this from "3 forevers" to just
> "1 forever" it would help an awful lot.
>
>
>
> "Thomas Malia" <tomma***@worldnet.att.net> wrote in message
> news:%23S661gkTJHA.1332@TK2MSFTNGP02.phx.gbl...
>>I need to do the following and want to know if anyone knows of a
>>reason why this might be problematic:
>>
>> 1) Backup a set of databases on a SQL 2005 Server Entperise Edition
>> (32 bit)
>> 2) Restore those backups to a SQL 2005 Server Enterprise Edition
>> (64 bit)
>> 3) Perform some application specific upgrade
>>    a) Specifically, We are upgrading Microsoft Dynamics SL database
>> from version 5.5 to version 7.0 SP1
>> 4) Backup the upgraded database on the 64 bit server
>> 5) Restore the upgraded databases back on the 32 bit server
>>
>> The step that has me particularly concerned is step 5.  Is there
>> any problem with restoring a database that had been on a 64 bit SQL
>> Server to a 32 bit SQL Server?  Are there issues with datatypes or
>> anything?
>>
>> Thanks in advance,
>> Tom Malia
>>
>
>