Upgrading SQL Server 2005 to SQL Server 2008

We are trying to upgrade SQL Server 2005 to SQL Server 2008 which is an in-place upgrade. We have a database which is in OFFLINE mode. Can someone tell me whether we need to change the status of this database to ONLINE before we start the upgrade or it will be upgraded without any issues eventhough it is in OFFLINE mode or it will be upgraded only when the database is made ONLINE after the upgrade?
Srinivas_VengalaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

blandyukCommented:
Shouldn't make any difference as the databases will still be in compatibility 90 (SQL 2005) after the upgrade anyway. To change it after, simply right-click DB, "Properties", goto "Options" and change compatibility to 10 (SQl 2008).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Srinivas_VengalaAuthor Commented:
But for the other user databases which are ONLINE, when the upgrade runs, it upgrades those databases to SQL Server 2008 though the compatibility level is still 90 after the upgrade. It records the following in the SQL Error LOG.

Converting database 'Test1' from version 611 to the current version 655.

It will not record this for the database which is OFFLINE. Instead it records the below message.

Cannot open database [Test2]. The upgrade of replication security meta-data could not be performed. Run sp_vupgrade_replsecurity_metadata again from the [master] database when the [Test2] is accessible.

After upgrading the SQL Server ,when I changed the OFFLINE database to ONLINE and compatibility level to 100, it is not recording anything about the upgrading that database (like converting the database...).

Any further information on this highly appreciated.
0
blandyukCommented:
If you are worried about this database, simply bring it online and restrict acces to "SINGLE_USER" mode. Then preform your update.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Srinivas_VengalaAuthor Commented:
I am not worried about a single database. But my question is, will the OFFLINE database be upgraded when it is made ONLINE (after the SQL Server upgrade) without any further steps or does it require some special attention?
0
blandyukCommented:
I have attached a database from an SQL Server 2005 server instance to a SQL Server 2008 instance with no issues what-so-ever. On this basis, I doubt you'll have any issues BUT having never performed an upgrade on an SQL server where a database if OFFLINE, (mainly because I'd bring them ONLINE as part of the upgrade), I don't know.
0
dethbyltCommented:
Not necessarily.  You could:
1. Backup the database.
2. Save the data files to a different location.
3. Detach the database prior to the upgrade.
4. Upgrade to SQL 2008.
5. Restore or attach it to the SQL 2008 server, post-upgrade.

If you have problems, you could bring the db online and then put it in single user mode (like bland said).  When it is in single user mode, it is fully functional for administrative purposes...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.