Solved

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

Posted on 2011-02-24
6
989 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
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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Mssql SQL query 14 45
Caste datetime 2 50
Insert Salary Period that has 2 months 11 22
Storage Spaces 3 37
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Facing problems with you memory card? Cannot access your memory card? All stored data, images, videos are lost? If these are your questions...than this small article might help you out in retrieving your lost or inaccessible data.
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…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

932 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now