Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Move Backup Exec Database from SQL Server Express 2005 to another server with SQL 2008.

Posted on 2011-02-24
6
Medium Priority
?
1,072 Views
Last Modified: 2012-05-11
I currently have a Win2K3 server with Backup Exec Ver 12.5 installed. When I originally installed BU Exec, I used the default SQL install that comes with the installation to house the main database.

What I want to do is transfer the database to another server that has a full SQL 2008 server installed. I obviously want all the data to be transferred across.

What is the best way to accomplish this?
0
Comment
Question by:sydleg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 34976145
You are trying to Migrate SQL Server 2005 to SQL Server 2008 and hence the below steps using Mirroring are applicable.

http://www.mssqltips.com/tip.asp?tip=1936

If the application is not critical or downtime is available, then you can do the steps below:

1. Build & Configure your new SQL server 2008.
2. Bring your SQL Server 2005 Down and close it for applications.
3. Take a full backup of all user databases.
4. Take a Script backup of all your Agent Jobs, Maintenance Plans and Linked Servers if any.
5. Take a backup of your Logins using the script given below:
http://support.microsoft.com/kb/918992

6. Restore your User databases in SQL Server 2008 machine.
7. Restore Agent jobs, Maintenance Plans.
8. Restore Logins script in the destination instance.
9. Change Compatibility Level of all databases to 100.
0
 
LVL 7

Expert Comment

by:adiloadilo
ID: 34976499
please don`t do manual migration   , instead use this article to move your backup exec server

http://www.symantec.com/business/support/index?page=content&id=TECH67768
0
 

Author Comment

by:sydleg
ID: 34976602
Thanks adiloadilo, but I dont want to move the whole installation, just the database.
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 11

Expert Comment

by:MichaelVH
ID: 34977560
sydleg,

please take a look at this KB-article from Symantec:
http://www.symantec.com/business/support/index?page=content&id=TECH37752

This article explains how you can relocate the database using the beutility from backup exec.

Michael
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 34978736
>> I dont want to move the whole installation, just the database.

beutiltity mentioned by MichaelVH would suffice..
Do make sure you are copying the required logins to new instance if not taken care by beutility..
0
 
LVL 7

Accepted Solution

by:
adiloadilo earned 2000 total points
ID: 34981008
all is included in that article , you can move the database using the BEDB Tool , but you have to follow exactly the steps and channge instance accordignly :

http://www.symantec.com/business/support/index?page=content&id=TECH49757

0

Featured Post

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Learn about cloud computing and its benefits for small business owners.
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
In this Micro Tutorial viewers will learn how they can get their files copied out from their unbootable system without need to use recovery services. As an example non-bootable Windows 2012R2 installation is used which has boot problems.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question