Is it possible to backup a SQL Server 2000 database using 64-bit and restore
it into
SQL Server 2000 32-bit database?
Thanks,SQL Server 32 bit and 64 bit are having the same data and log structure for
file format and architecture as far as storage is concerned. So, Backup and
restore between editions are supported.
Thanks
Hari
SQL Server MVP
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:C8297123-EDA7-43B9-9E28-385CE9B8D19E@.microsoft.com...
> Is it possible to backup a SQL Server 2000 database using 64-bit and
> restore
> it into
> SQL Server 2000 32-bit database?
> Thanks,
>
Showing posts with label 32bit. Show all posts
Showing posts with label 32bit. Show all posts
Tuesday, March 20, 2012
Restore Database 64bit into 32bit
Is it possible to backup a SQL Server 2000 database using 64-bit and restore
it into
SQL Server 2000 32-bit database?
Thanks,SQL Server 32 bit and 64 bit are having the same data and log structure for
file format and architecture as far as storage is concerned. So, Backup and
restore between editions are supported.
Thanks
Hari
SQL Server MVP
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:C8297123-EDA7-43B9-9E28-385CE9B8D19E@.microsoft.com...
> Is it possible to backup a SQL Server 2000 database using 64-bit and
> restore
> it into
> SQL Server 2000 32-bit database?
> Thanks,
>
it into
SQL Server 2000 32-bit database?
Thanks,SQL Server 32 bit and 64 bit are having the same data and log structure for
file format and architecture as far as storage is concerned. So, Backup and
restore between editions are supported.
Thanks
Hari
SQL Server MVP
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:C8297123-EDA7-43B9-9E28-385CE9B8D19E@.microsoft.com...
> Is it possible to backup a SQL Server 2000 database using 64-bit and
> restore
> it into
> SQL Server 2000 32-bit database?
> Thanks,
>
Restore Database 64bit into 32bit
Is it possible to backup a SQL Server 2000 database using 64-bit and restore
it into
SQL Server 2000 32-bit database?
Thanks,
SQL Server 32 bit and 64 bit are having the same data and log structure for
file format and architecture as far as storage is concerned. So, Backup and
restore between editions are supported.
Thanks
Hari
SQL Server MVP
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:C8297123-EDA7-43B9-9E28-385CE9B8D19E@.microsoft.com...
> Is it possible to backup a SQL Server 2000 database using 64-bit and
> restore
> it into
> SQL Server 2000 32-bit database?
> Thanks,
>
it into
SQL Server 2000 32-bit database?
Thanks,
SQL Server 32 bit and 64 bit are having the same data and log structure for
file format and architecture as far as storage is concerned. So, Backup and
restore between editions are supported.
Thanks
Hari
SQL Server MVP
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:C8297123-EDA7-43B9-9E28-385CE9B8D19E@.microsoft.com...
> Is it possible to backup a SQL Server 2000 database using 64-bit and
> restore
> it into
> SQL Server 2000 32-bit database?
> Thanks,
>
Saturday, February 25, 2012
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.
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.
Subscribe to:
Posts (Atom)