Post reply

Restore 32bit sql database on 64bit windows 7

  • June 1, 2011 at 8:35 am

    #241356

    I'm using 64-bit windows 7 and installed Microsoft 32-bit SQL server on my machine. I have a backup of a database that I want to restore onto the 32-bit instance of the SQL server but I can't because I can't enable FILESTREAM when running SQL server in the WOW64 environment. Is there some way to get the data from the 64-bit instance of SQL server to the 32-bit instance?

  • June 1, 2011 at 8:43 am

    #1332532

    dts (import export), bulk copy, ssis package, or use a redgate data compare tool to compare the tables of the database that is running on a 64 bit machine to a database on your 32 bit machine.

    Another option is to run a virtual machine of the database server on your win7 desktop.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply