Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how opening 64bit sql2008 database by 32bit sql2012 Expand / Collapse
Author
Message
Posted Friday, March 7, 2014 4:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 9, 2014 1:03 PM
Points: 3, Visits: 4
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
Post #1548924
Posted Saturday, March 8, 2014 6:33 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:45 AM
Points: 40,456, Visits: 36,911
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 2008, MVP
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

Post #1548966
Posted Sunday, March 9, 2014 11:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 9, 2014 1:03 PM
Points: 3, Visits: 4
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
------------------------------
"
Post #1549066
Posted Sunday, March 9, 2014 1:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 9, 2014 1:03 PM
Points: 3, Visits: 4
I find my problem I have security problem not file format
tanks for your notification
Post #1549073
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse