I have detached the backup file 6 months back and machine was 64 bit os. Now we are strugling to attach this file to our new system which has 32 bit os.Is it possible to attach from 64 bit os machine to 32 bit?
I have detached the backup file 6 months back and machine was 64 bit os. Now we are strugling to attach this file to our new system which has 32 bit os.Is it possible to attach from 64 bit os machine to 32 bit?
Hi,
The SQL Server on-disk storage format is the same in the 64-bit and 32-bit environments. Therefore, attach works across 32-bit and 64-bit environments. A database detached from a server instance running in one environment can be attached on a server
instance that runs in another environment. If you use SQL Server 2008, you could use attach operations to upgrade a user database from SQL Server 2000 or SQL Server 2005. It will work fine.
Honnappa
Participant
1112 Points
534 Posts
Database attach/Restore Problem
Apr 26, 2012 06:10 AM|LINK
I have detached the backup file 6 months back and machine was 64 bit os. Now we are strugling to attach this file to our new system which has 32 bit os.Is it possible to attach from 64 bit os machine to 32 bit?
How to over come from this problem?
My Profile
Chen Yu - MS...
All-Star
21598 Points
2493 Posts
Microsoft
Re: Database attach/Restore Problem
Apr 27, 2012 09:26 AM|LINK
Hi,
The SQL Server on-disk storage format is the same in the 64-bit and 32-bit environments. Therefore, attach works across 32-bit and 64-bit environments. A database detached from a server instance running in one environment can be attached on a server instance that runs in another environment. If you use SQL Server 2008, you could use attach operations to upgrade a user database from SQL Server 2000 or SQL Server 2005. It will work fine.
Detaching and Attaching Database:http://msdn.microsoft.com/en-us/library/ms190794(v=sql.100).aspx
Thanks.
Feedback to us
Develop and promote your apps in Windows Store