Solved

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

Posted on 2011-02-24
6
1,029 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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
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 500 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

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Amazon RDS migrate to SQL Server 3 35
SQL trigger 5 37
DNS/WINS in a domain 10 49
SQL syntax question 6 45
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
When speed and performance are vital to revenue, companies must have complete confidence in their cloud environment.
In this Micro Tutorial viewers will learn how to use Windows Server Backup to create full image of their system. Tutorial shows how to install Windows Server Backup Feature on Windows 2012R2 and how to configure scheduled Bare Metal Recovery backup.…
In this Micro Tutorial viewers will learn how to restore single file or folder from Bare Metal backup image of their system. Tutorial shows how to restore files and folders from system backup. Often it is not needed to restore entire system when onl…

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