how opening 64bit sql2008 database by 32bit sql2012

  • hi I want open 64 bit sql2008 database by 32 bit sql2012 but can't please help me ?I want convert data from first database to another database thx;-)

  • Database files aren't processor-architecture specific. A database file for a 32 bit instance is identical to one for a 64 bit instance.

    You're trying to attach a SQL 2008 database on SQL 2012? Or restore backup?

    What error are you getting?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • hi and tanks foe you reple

    the error is:

    "

    TITLE: Microsoft SQL Server Management Studio

    ------------------------------

    Attach database failed for Server 'CONTROLFANI-PC'. (Microsoft.SqlServer.Smo)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.3000.0+((SQL11_PCU_Main).121019-1322+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

    ------------------------------

    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    Unable to open the physical file "F:\Passport\db\Passport.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.2100&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

    "

    :crazy:

  • I find my problem I have security problem not file format

    tanks for your notification

Viewing 4 posts - 1 through 3 (of 3 total)

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