SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Restore from SQLServer2008-32 bit to 2012-64 bit
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

paramu
Posting Yak Master

151 Posts

Posted - 06/19/2013 :  05:53:55  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 06/19/2013 :  05:58:07  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 06/19/2013 :  06:01:42  Show Profile  Reply with Quote
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 - 06/19/2013 :  06:19:02  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 06/19/2013 :  06:24:29  Show Profile  Reply with Quote
welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000