Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Chipeaux
Starting Member
2 Posts |
 Posted - 2007-03-08 : 20:40:17
|
| I recently used SQL Server to rationalise a very large data set from a client into an online inventory. For convenience, the raw data was in one database - kept on an external hard drive (300Gb). The final result was transferred to a seperate database which was stored on a local drive.Now I have noticed that SQL Server Service Manager will not start my service unless the external hard drive is connected. I have removed the 'raw' database (which lived on the external HDD) from from SQL Server Group, but SQL Server still strangely needs connectivity to the external drive!I'm running SQL Server Enterprise Manager v8.0.Anyone else had a similar problem or can suggest a solution? |
|
|
Chipeaux
Starting Member
2 Posts |
Posted - 2007-03-14 : 03:31:59
|
| Solved! I had modified the location of the tempDB to be stored on the External HDD. SQL Server wasn't trying to locate the extinct DB, it was trying to establish the tempDB there. |
 |
|
|
|
|
|
SQL Server retaining extinct link to external HDD