Solved

Sql Server 2008 64bit and 32bit software

Posted on 2009-07-11
3
414 Views
Last Modified: 2013-12-01
Hi ,

I am currently running a windows 2003 and asp.net 3.5 and sql server 2005 standard. all of them are 32bits.
Now I am planning to upgrade a new server . and willing to go with windows 200864bit and sql server 2008 64bit.
Can I do that ?
the development env will still in Vista 32bits and VS2008 32 bits.

questions:
Can I replication between 2008 64bit and 2008 32bit express to keep a copy of database?
Can I running the 32bits asp.net program with 64bits Sql server?
0
Comment
Question by:GordonLiq
  • 2
3 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 24830144
>> Can I replication between 2008 64bit and 2008 32bit express to keep a copy of database?

No Issues. You can do replication between 2008 versions without considering bit versions

Can I running the 32bits asp.net program with 64bits Sql server?

Yes..ASP Application will connect to SQL Server irrespective of its bit versions.
Bit versions are applicable for SQL Server Installations only. Once it is Installed, then everything becomes a SQL Server 2008 database only.

Hope this helps.
0
 

Author Closing Comment

by:GordonLiq
ID: 31602387
Thank you , soulds like I can upgrade to 2008 64 system and database without any problem.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24833430
Yes.. You can upgrade to 64 bit version of SQL Server 2008 without any problem.
Request you to use the Upgrade Advisor to upgrade without any issues:

http://www.microsoft.com/downloads/details.aspx?FamilyId=F5A6C5E9-4CD9-4E42-A21C-7291E7F0F852
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now