Backing up SQL2005 server after upgrade from SQL2000

Posted on 2006-11-20
Last Modified: 2008-04-03
We had a production server that was recently upgraded to SQL2005 running peoplesoft.  This project was really for a peoplesoft upgrade, but the SQL version went to 2005 as well.  We have Veritas Backup Exec 10 installed on this server as well and were backing up the data files and SQL DB.  After the upgrade to SQL2005 we can no longer backup SQL server through backup exec.  The error when browsing selections on this server, specifically when you try to expand SQL2005 is:

"Microsoft SQL Server does not appear to be running or network connections are preventing acccess to it"

I triple checked and SQL 2005 is running and everything else works in Backup Exec, except for backing up SQL2005 now.  Has anyone else upgraded to SQL2005 from an older version and run into problems backing up the databases?  I tried browsing SQL2005 from Backup Exec 10.1d from Symantec now, which we have running on a separate server, but I get the same exact error, which leads me to think that its a problem with SQL2005 not with Backup Exec or Windows server.  

Any ideas?

Question by:MCPJoe
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
  • 3
  • 2
LVL 16

Expert Comment

ID: 17983000
Hi MCPJoe,

While I've not used Backup Exec 10, there appears to be a hotfix for supporting sql 2005 (info here:  Have you applied this?


Author Comment

ID: 18020681
I am going to try this, but I have to uninstall Backup Exec from the target server first.  I am running into issues where its telling me to contact support for a manual uninstallation.  So it is going to take me a while to get this done.
LVL 16

Expert Comment

ID: 18022758
No worries - let us know how you go.
[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

LVL 16

Expert Comment

ID: 18263885
I was interested in seeing if this worked :(

I would say this one has been abandoned by the poster, delete.

Author Comment

ID: 18267220
Sorry, I got really busy and couldn't update this post.  

What I ended up doing was uninstalling Backup Exec from the SQL server itself, and using a consolidated backup server to remotely backup its contents.  I did install the SQL hotfix mentioned above on backup exec on the consolidated backup server and am now able to backup successfully.  Backup exec was pretty badly screwed up on the SQL server, so I had to uninstall it, which was also complicated.  Anyway, the hotfix does appear to work, as I can now backup SQL 2005 from backup exec 10 on another server.


Accepted Solution

DarthMod earned 0 total points
ID: 18449704
PAQed with points refunded (500)

Community Support Moderator

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

627 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