Post reply

restoring an mdf from a 64Bit system to a 32 bit system..it is possible no?

  • February 15, 2011 at 8:23 am

    #245651

    I am running SQL Server 2005 on a 64bit OS. I need to restore a backup to my local laptop which is running SQL Server 2005 on a 32 bit OS. Is this discrepancy an issue when it comes to doing a restore?

    Thanks!

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • February 15, 2011 at 9:40 am

    #1287152

    no problem...the format for a backup , or the mdf, is standard between the same versions...2005;

    the service that answers requests to access the database may be 32 bit, 64 bit etc, but the SQL version does not change how the data is stored.

    do a backup from one server, and restore it on another.

    you cannot restore a 2008 backup to a lower version like 2005, but you can go the other way...2005 to a higher version of SQL

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 15, 2011 at 10:30 am

    #1287182

    That's greatnews! Thanks Lowell!

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • February 15, 2011 at 10:50 am

    #1287201

    just keep in mind you cannot restore Ent edition backups to Std edtion if you are using Ent Edtn features ! (partitioning, ...)

    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