Tagged Questions
1
vote
1answer
46 views
What are the hazards of upgrading a SQL Server service pack?
Are there any specific pitfalls/standard considerations when upgrading an instance of MS SQL Server to a higher service pack? Is there anything special that is generally done besides making sure there ...
0
votes
0answers
44 views
SQL Server 2000 Trace Template for SQL Server 2008 R2 Upgrade Advisor
My current database is SQL Server 2008 R2 with compatibility level 80 (SQL Server 2000). I need to upgrade compatibility level to 100 (SQL Server 2008/R2). I have installed SQL Server 2000 Enterprise ...
0
votes
1answer
90 views
SQL Server 2005 upgrade to Service Pack 4 (SP4) via command line
I have been wracking my brain over upgrading SQL Server 2005 to SQL Server 2005 SP4. I have a script for installing new instances of SQL Server for all versions and they all work wonderfully. Problem ...
3
votes
2answers
194 views
Identify NON-ANSI joins in SQL Server 2008 R2 on a Database that's in 2000 (80) compatibility mode
We have a very old database running on SQL Server 2008 R2. The database is running in 2000 (80) compatibility mode and has oodles of NON-ANSI joins in stored procedures, views and functions.
We need ...
25
votes
2answers
2k views
Are SQL Server in-place upgrades as ill advised as they used to be?
I have been working with SQL server on and off since SQL Server 6.5, the old advice that still rings in my head was never to do an in-place upgrade.
I'm currently upgrading my 2008 R2 DEV and TEST ...
1
vote
1answer
82 views
Software/Hardware Upgrade
I've been working on a software/hardware upgrade from SQL2005 on win 2003 to SQL2008 R2 SP2 on win2008. The new hardware has 48 cores with 128 gig of ram whereas the older server 16 cores with 32Gig ...
4
votes
1answer
278 views
Why would a SQL Server 2008 R2 database disable a table index when upgraded to SQL Server 2012
I've restored a database backup in a new SQL Server 2012 server from a .bak made in SQL Server 2008 R2, and one of the tables has it's primary key index disabled. This doesn't happen when I restore to ...
1
vote
1answer
189 views
Is it possible to do an in-place upgrade of SQL Server 2005 Standard to SQL 2012 Enterprise?
At the moment, I have a SQL 2005 Standard box. I'd like to upgrade it to SQL 2012 Enterprise in-place. When I say in place, I mean an install similar to Office 2010, e.g. it removes the older (Office ...
1
vote
2answers
873 views
How to update SQL Server 2012 from Evalutation to Developer edition?
During the installation of a new development infrastructure, I had to install many SQL Server instances on different machines. Some were of course dedicated for production and some other for ...
4
votes
1answer
120 views
Is there a standard approach to rolling out database schema changes?
A developer said I should simply wrap all my database upgrade scripts in a transaction. If it fails, just roll back all changes. All my instincts tell me this is wrong, especially when it comes to ...
1
vote
4answers
1k views
upgrading sql server 2000 database to sql server 2012
Seeking some advice about an oudated database system we're working with.... hope this is an appropriate place to post this question.
I work with a city government arts program. In 2004, we ...
4
votes
2answers
196 views
What is an advantage or disadvantage for not upgreading database server?
I have a legacy database server. The person who wrote it is long gone. There is no documentation at all just some comments in the code. Luckily, it is not that complicate but if I want to fix it ...
0
votes
2answers
280 views
Upgrading Instances with Mirroring
If you want to upgrade or install a patch on two separate instances that house both the principal and mirrored database, how can you go about that? If the database that is being mirrored needs to be ...
