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.
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 & RegardsParmu @ ParanthamanParamu @ 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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
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@ ParanthamanParamu @ PARANTHAMAN |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-19 : 06:24:29
|
welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|