It wasn't a SQL problem but I'll post here in case any others use Backup
Exec.

In the Backup Exec Registry Settings there are DB entries for both
Database server and Database file path. I hadn't changed this last
entry when I moved the datafiles. So on service startup it couldn't
find the MDF and LDFs where it was expecting them. It also looks like
it removes the DB from Enterprise Manager when it has this problem.

Thanks
Pat


-----Original Message-----
From: Patrick Delaney
[mailto:mssqldba-ezmlmshield-x18264767.[Email address protected]
Sent: 28 October 2005 10:14
To: LazyDBA Discussion
Subject: Moving Datafile Problem

Hi All,

This may not be a SQL problem but any ideas?

I'm in the process of tidying up one of our servers and I'm in the
process of moving all the datafiles to one location instead of dotted
around the partitions. My process is as follows

- sp_detatch DB
- move db MDF and LDFs
- sp_attach DB

This has worked great on all DBs except our Backup Exec DB. I can do
the above fine and the DB comes back online. However, there are 4
Backup Exec services and I can start the 1st OK but when I try to start
the remaining 3 they fail with a DB doesn't exist error.

Whats weird is that when I get the error the DB disappears from EM and I
have to re-attach. Moving the files back to the original locations
fixes the issue totally.

Any thoughts?

Thanks
Pat


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page