Database Restore for SQL 2005 Enterprise...
-
Good Afternoon!
The department I work for is moving to SQL 2005 Enterprise 64 bit enviroment. One question that pop up is that can a SQL 2005 Enterprise 64 bit database restore on SQL Enterprise 2005 32 bit environment or should we be we stay within the same enviroment for the restore?
Any information will help.
Thanks,
Javier L.
-
It is my understanding that a non system db that is on 64 bit can be detached/attached from 64 to 32 bit as well as backup restore as well. I think it is the 'binaries' that are pure 64 bit.
-
If you are restoring database for QA/test better to use 64bit...
MohammedU
Microsoft SQL Server MVP -
- for the data-part the is no difference for 32 or 64-bit OS / SQLServer
- however if you are using the CLR, I guess it would be nice to avoid the 32-bit emulation. So implement 64-bit versions of your clr-routines. These routines might not work when restoring your db at a 32-bit environment.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply