More Related Resource Links

Hi all
I have 6 cluster environments and 10 standalone servers and mix
of 32 bit
64 bit.
As I know In place Upgrade not possible SQL2k 32 bit to SQL2008 64 bit.
What I want to know is………
1. If I purchase SQL Server 2008 Ent edition that will have both 64 bit and 32 bit edition
or I have purchase separately ?
2. How to do side by side upgrade in Cluster environment
I mean I can’t ask my company to provide other cluster to do side by side upgrade.
If I do installation in same cluster machines, I can’t provide same Instance name for SQL Server 2008 Instance.hance it is very difficulty for application connectivity
Please some body provides me best approach to drive in Upgrade from SQL2k to SQL2008.
Thanks in Advance
SNIVAS

I have Two Windows Server 2008 SP1 Servers installed in a Fail over Cluster mode. SOL Server 2008 SP1 is running in the Fail Over Cluster in ACTIVE / PASSIVE Mode. Now I need to upgrade the SOL server 2008 SP1 to R2. How do I proceed for that? Please help
me to proceed.

Hello SQL Support group,
I have SQl server 2008 R2 installed on a Win 2003 R2 and it is for our SharePoint and Project server 2007 environment.
Today I noticed that we have only 75 days left! Seems like we installed it on evaluation mode. Here what we have on Helpàabout
:
Microsoft SQL Server Management Studio Complete (expires in 75 days)
10.50.1352.12
We do have MSDN account, and we have the KEY that comes with the SQL server 2008 R2 enterprise. We would like to assign the key to our SQl server ( we want to
have enterprise edition). It is in a production environment now. I would like to know how we can do it with minimum of down time.
I found this link:
http://blogs.technet.com/b/sqlman/archive/2010/03/16/sql-server-2008-upgrading-to-standard-enterprise-edition-from-evaluation-edition.aspx
On the internet, but doesn’t say anything that we are losing any data after upgrade or not.
Please let us know the best way to assign the key, and if it has any impact in our data.
Thanks
Bahram

Hi all
Can some body share with information about "Why upgrade is required from SQL Server 2000 to SQl Server 2008?"
This question was raised by my Boss why upgrade is required.
I stared saying
My: there is no more
support for SQL Server 2000 from Microsoft
Boss: what you will do as DBA, Why Required Microsoft support
My: 2008 having very good features where 2000 not have...like Compression, resource governing. .Etc..
Boss: do you mean Database backup compression take full backup and compresse it using ZIP
Finally He (Boss) told me that give document proof why I have go for SQL Server 2008 and what down time you required?
Some body help me why really SQLServer 2008 is required and what are benefits
I have a link; please provide your greatest ideas so that I can convince my Boss.
http://www.mssqltips.com/tip.asp?tip=1462
share your greate Ideas please....
Thanks in Advance
SNIVAS

When I try to bring SQLAGENT Online, I get the following errors:
EventID:53
[sqagtres] StartResourceService: Failed to start SQLSERVERAGENT service. CurrentState: 1
[sqagtres] OnlineThread: ResUtilsStartResourceService failed (status 435)
[sqagtres] OnlineThread: Error 435 bringing resource online.
I just did a fresh SQL Cluster install as well. When I installed the cluster, the service account was good to go. I cant figure out what is going on. SQL Server Engine starts fine. Any ideas?

Hello,
We have SQL 2005 Report Server in a Windows 2003 64 bit server box. We want to create a copy of this report server database somewhere in the domain, so that we can access it for a different purpose.
My question is, will there be any complications with this? I'm thinking about the encryption key that's needed to access the database.
If we are successful with this, we might also want to upgrade to SQL 2008.
Thanks for your help,
Elizabeth K.

I have a production two-node cluster with sql server 2008 sp1 cu7 running over windows server 2008 sp2.
If I were to install a new named instance on this live environment, would it impair the default sql server instance functionality? I'm not referring to processor/io while the install is in progress. My question specifically is would the install process by
its nature bring down the default instance.
I'm pretty sure it won't, but don't see any documentation that would confirm this. thanks.

guys,
I have upgraded my Databases from SQL Server 2000 SP4 to SQL Server 2008 SP1 x64 on Itanuim and used most common best practices but my queries was running on 2000 in shap now running very slow in SQL 2008 keeping in mind my current HW is very good and can't
even comparing with 2000 server HW
pls Advice , thanks in advance

Hello all,
Looking for the definitive answer with supporting documentation (link).
Does a SQL server 2008 cluster have to be installed as or run as a domain service account or can local accounts be used? I looked for a document that stated yes or no and could not find one.
If anyone can provide info it would be much appreciated.
Have all ready looked at these 2 links of interest.
http://msdn.microsoft.com/en-us/library/ms143504.aspx#Service_SID
http://technet.microsoft.com/en-us/library/cc731002(WS.10).aspx
Thanks in advance,

we have a cluster with 2 nodes and we are thinking to add another instance so that node 1 takes care of instance 1 and node 2 takes care of instance 2, and at anytime they are watching each other's back.
How is this done???? what is the procedure? thanks.

Hello Every body
Please advise me the steps i am following are correct I need to improve some more...
I want upgrade from sql server 2000 to SQL Server 2008,
Plese confirm the steps
1.Setup Test SQL Server 2000 similar to Production SQLServer 2000.
2.Setup other server with SQL Server 2008.
3.Install the Upgrade advisor in SQL Server 2008 system
4.Select the Play back(under "sql server 2000 server") in Upgrade advisor tool and fill the SQL Server2000 Server name and authontication.
5.Click on Capture play back(take the all the backups run some top 10 queries or application on top of SQL server 2000)
6.Please in shared drive(whcih can access by the SQL Server 2008 server)
7.Now click the "setup the test server"
8.Now click the upgrade test server 2008..
9.camapre the trace files
10.View the Trace files differance.
some body help me and plese confirm those steps are correct...I am in right direction..SNIVAS

I use the wizard "Maintenance > Edition Upgrade". When I choose the instance of SQL Express 2008 and click Next I get the error "Rule SQL 2008 edition upgrade failed. The selected SQL Server instance does not meet upgrade matrix requirements."What can I do to ugrade ?

Hi,
Currently, we use SQL Server 2008 standard edition. We are planning to improve the performance of our application. The application is built by 3<sup>rd</sup> party
and we can’t change/modify database objects and they seem to be designed fine.
The options are spending our budget to upgrade to sql server hardware, or upgrade to SQL Server Enterprise edition.
I am a bit confused over the benefits of SQL Server Enterprise edition. The following chart suggests that SQL EE includes “Parallel Index Operations”
and “Enhanced Read-ahead and Scan”:
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
How significant are “Parallel Index Operations” and “Enhanced Read-ahead and Scan”?
Considering the fact that new hardware is cheaper than sql enterprise license, Should I spend budget to upgrade enterprise edition instead of buying as server with
faster CPU and RAM?
Thank you,
Max

upgrading from 2008 r2 eval to 2008 r2 enterprise.
Use the maintenance option from setup. Get pretty far along in the process. But then the following error. ( an additional note. setup warns that I am running sql server on a domain controller server. )
The link the error message points to has nothing to say. Why would my sql server upgrade fail? If I have to reinstall, will I lose my database data?
thanks,
TITLE: Microsoft SQL Server 2008 R2 Setup
------------------------------
The following error has occurred:
Access to the path 'C:\Program Files\Microsoft SQL Server\100\License Terms\SQLServer2008R2_License_ENT_1033.rtf' is denied.
Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.
For help, click:
http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.1600.1&EvtType=0x60797DC7%25400xBB814387

Hi
I am ready with In-Place and went to Sr.DBA Manager,
He rejected and he want 100% Database guarantee and 100% safe, down time does not matter for him and recommended me go a head with Side by Side.
1.If detach Database from SQL2k and attach to SQL2k8,I don't think it is possible to attach back...is it correct
2. Is it required Create new cluster group for SQL2k8?
3. In 2 case what are the cluster groups I have to Create
4. Is it required to change connecting string from application?
5. If it is where i have to modify the connecting string in application level or in Database server level?
6. What are the settings can I take care after installing new sql server instance?
7. Is it required new virtual instance name for new installation (Instance)?
8.Is there any way to use existing virtual instance name for New instance?(so I belive no Need to change connecting string in application)
10.Is it possible to change instance name?(Old instance name to some other name and new instance name as existing instance name).
SNIVAS