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
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Ms sql server backup problem

Author  Topic 

eclipce051
Starting Member

5 Posts

Posted - 2011-09-07 : 09:31:55
Hello guys,

This time i am here to point an issue i have identify, ir you run a backup of sqlserver 2008 64 bit to One of it's dB you won't be able to restore that specific backup to The 2008 32 bit it would crash under The error of structure problem. How Everest ir you do a full backup you will have it complete with out Any error of this cain. Of you have a way of getting it load for an specific dB torne 32 bit post it here.

Best regard.

Life is short get a rest and go out with some chiks :P

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2011-09-09 : 14:17:40
you should provide more information like dump files or sql error log entries...
according to this, it should work, I'll probably test that on my hyperv machine as I am curious as well

http://msdn.microsoft.com/en-us/library/ms191239.aspx
quote:

The SQL Server on-disk storage format is the same in the 64-bit and 32-bit environments. Therefore, backup and restore work across 32-bit and 64-bit environments. A backup created on a server instance running in one environment can be restored on a server instance that runs in the other environment.



--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -