Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

11d: Migrating from SQL 2000 to SQL 2005

Updated: 21 May 2010 | 1 comment
Rufguy's picture
Rufguy
0 0 Votes
Login to vote

 Hi,

We have Backup Exec 11d for our Small Business Server 2003 Premium box. We're going to be upgrading the SQL 2000 that came with the Premium version of SBS to the SQL 2005 that comes with SBS 2003 R2. I need to know how to migrate the BE 11D database to SQL 2005.

I've seen http://seer.entsupport.symantec.com/docs/271620.htm but this seems to assume that the existing database is still functional and in my situation, SQL 2000 must be uninstalled before SQL 2005 can be installed.

Thanks in advance.

John

Discussion Filed Under:
, ,

Comments

Symantec Employee - SPR's picture
20
Jun
2007
0 Votes 0
Login to vote
Symantec Employee - SPR
Symantec Employee
Accredited

Hello John,

Thank you for selecting Symantec's online support.

You can accomplish your goal by using the following guidelines.

  1. Make note of the SQL Instance name currently being used.
  2. Stop the Backup Exec services.
  3. Detach the BEDB database.
  4. Copy the BEDB_DAT.MDF and BEDB_LOG.LDF files used by the SQL database BEDB.
  5. Uninstall SQL 2000.
  6. Install SQL 2005 with the same instance name from step 1.
  7. Attach the BEDB_DAT.MDF and BEDB_LOG.LDF files as BEDB.
  8. Start the Backup Exec services.

SQL 2005 will upgrade the database files to the new format when you attach them.

Technical Support

Symantec.com

Store

Community Stats

Total Content Items
Members
270,017