Restore 32bit/64bit

Hello,
I am completely SQL ignorant, so please be gentle!!!
Are SQL 2005 64 bit databases constructed differently to SQL 2005 32
bit databases? For example, could I restore/import a database created
in the 64 bit version to a 32 bit version of SQL 2005?
ThanksThere is no restriction in restoring backups made from a 32 bit or 64
bit instance of SQL Server to the opposite. The same is true for
DETACH and ATTACH. The databases are internally identical.
Roy Harvey
Beacon Falls, CT
On Tue, 29 Apr 2008 08:59:08 -0700 (PDT), tvmo <tvmo@.hotmail.co.uk>
wrote:
>Hello,
>I am completely SQL ignorant, so please be gentle!!!
>Are SQL 2005 64 bit databases constructed differently to SQL 2005 32
>bit databases? For example, could I restore/import a database created
>in the 64 bit version to a 32 bit version of SQL 2005?
>Thanks|||No problem. The two are compatible with each other.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"tvmo" <tvmo@.hotmail.co.uk> wrote in message
news:188289e5-d993-4294-94cd-d183a0c22ed7@.25g2000hsx.googlegroups.com...
Hello,
I am completely SQL ignorant, so please be gentle!!!
Are SQL 2005 64 bit databases constructed differently to SQL 2005 32
bit databases? For example, could I restore/import a database created
in the 64 bit version to a 32 bit version of SQL 2005?
Thanks|||Thanks very much both.
So the only difference is how the application interacts with the
hardware?
Cheers.|||If you by "Application" mean SQL Server, then yes. The application is 64 bit with 64 bit
instructions etc. To be more specific, though, we should say that the app interacts with the
operating system, which in turn interacts with the hardware.
Note that you should be careful if you go down-level in edition, since the database might use some
feature in a higher edition - which isn't available in the lower edition.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"tvmo" <tvmo@.hotmail.co.uk> wrote in message
news:faee31f3-c5dd-4c77-99c8-7c5e15f6cbf0@.f63g2000hsf.googlegroups.com...
> Thanks very much both.
> So the only difference is how the application interacts with the
> hardware?
> Cheers.|||Thanks very much all.