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

MS Sql Server LazyDBA home page