Re: Will SQL 2k 64bit ed dump files load on 32bit SQL2k?



Hi

Yes. The backup, database and log files are the same on disk and are 100%
compatible across 32/64 bit.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@xxxxxxxxxxxx

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

<jaykwon72@xxxxxxxxx> wrote in message
news:1125346260.710167.210560@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi there. I apologize if this topic had already been covered. I'm
> trying to find out whether I can load up a data dump files, generated
> off of a 64bit SQL server on Itanium, to a 32bit MSSQL 2K server. If
> anyone has tried this before, please let me know your findings. Thank
> you very much in advance folks.
>
> j
>


.



Relevant Pages

  • Re: Moving SQL 2005 DBs
    ... Microsoft SQL Server MVP ... The confusing part is that at install, ... > not have an option to specify where I wanted my log files to go, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Transact sql to remove space
    ... > Mike Epprecht, Microsoft SQL Server MVP ... > Zurich, Switzerland ...
    (microsoft.public.sqlserver.programming)
  • Re: Electing NAS or SAN?
    ... Mike Epprecht, Microsoft SQL Server MVP ... Zurich, Switzerland ... > How is best performance and support.? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Active/Passive in front of a SAN--best practices
    ... Mike Epprecht, Microsoft SQL Server MVP ... Zurich, Switzerland ...
    (microsoft.public.sqlserver.clustering)
  • Re: Profiler counting table selects?
    ... SQL Server Profiler/Trace is your only way. ... Mike Epprecht, Microsoft SQL Server MVP ... Zurich, Switzerland ...
    (microsoft.public.sqlserver.tools)