November 10, 2009 at 6:51 am
Hi all,
I am having a DB backup (from 64-bit server). Is there ay way of using this DB backup on a 32 bit server by restoring other DB with this 64-bit DB backup.
Thanks in advance,
Venu Gopal.K
Software Engineer
INDIA
November 10, 2009 at 7:49 am
Sure you can restore a backup from a 64-bit server to a a 32-bit server. The file formats are the same.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 10, 2009 at 9:11 pm
Hi Thanks for your advice, But while restorina a 32Bit DB with 64Bit DB Backup , it is throwing an error like follwing:
The media family on device 'C:\Documents and Settings\xyz\Desktop\CICMT DB Backups For Deployment\Database1.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
Please help me in this.
Thank you,
Venu Gopal.K
Software Engineer
INDIA
November 10, 2009 at 9:18 pm
Whether it is 64- or 32-bit makes no difference. What does matter is the version of SQL Server.
You can't restore a backup from a 2008 SQL Server to a 2005 SQL Server for example.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
November 10, 2009 at 9:20 pm
Have you successfully restored this backup on a 64-bit server? It could be your backup is no good.
Or as Paul says are you on the same version.
-edit to reference Paul's post.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply