Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Restore from SQLServer2008-32 bit to 2012-64 bit

Author  Topic 

paramu
Posting Yak Master

151 Posts

Posted - 2013-06-19 : 05:53:55
Hi,
I have data in sql server 2008- 32 bit system. Now I wish to restore it in sql server 2012 - 64 bit machine...

For that any directions will be helpful...

restore database 'My_DbName' from disk='G:\SQL\MyBakup.bak'
???

Thanks & Regards
Parmu @ Paranthaman

Paramu @ PARANTHAMAN

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-19 : 05:58:07
There's nothing special to be done for that. As I understand there's nothing written into mdf,ldf ,bak files to indicate the architecture used ie x64,x86 etc. so you should be able to use them interchangeably for backup,restore,attach,detach etc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-19 : 06:01:42
also i guess the path specified is a path (mapped drive/shared folder etc) in your 64 bit machine where you've the bak file

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

paramu
Posting Yak Master

151 Posts

Posted - 2013-06-19 : 06:19:02
Thanks for tips Visakh....All your helps are very much useful....

Simply I changed to move command with folder MSSQL11.MSSQLSERVER, Then it works fine...

Thanks again...

Paramu@ Paranthaman

Paramu @ PARANTHAMAN
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-19 : 06:24:29
welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -