Web Wiz Forums - SQL server upgrade from 2000 to 2008

Print Page | Close Window

SQL server upgrade from 2000 to 2008

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=29969
Printed Date: 01 April 2026 at 1:00am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL server upgrade from 2000 to 2008

Posted By: Christie
Subject: SQL server upgrade from 2000 to 2008
Date Posted: 21 November 2011 at 1:08pm

I have a licensed version 8.05 and have had it sitting happily on a SQL 2000 box for a number of years, but due to new hosting requirements, we want to move the sql to a SQL 2008 R2 box. I've migrated the data across, but notice that I can no longer log into the forum to "configure" as my administrator account password isn't recognized.

Do I need to use the SQL upgrade tool? I don't wish to upgrade the forum, just the SQL version the data is stored in.

We are a charity and don't have easy access to funds for a new license hence why we're still using version 8.05.

Any help you can offer greatly appreciated!

Replies:

Posted By: WebWiz-Bruce
Date Posted: 21 November 2011 at 5:22pm

It sounds like you may have used the Import/Export Tools in SQL Server Studio Manager to migrate the data. This does not work as much of the database schema is dropped.

What you need to do is create a backup of your SQL Server 2000 Database (.bak file). You then move the backup file to your new database server where you restore the database in SQL Server Studio Manager.

By doing it this way you keep all the database schema as well as the data.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting