Newbie Question - Service Manager / Win 2003

Hi,

I'm running a Microsoft Windows 2003 Server computer, which is using a MS SQL server to feed our office application, OfficeTalk.

Due to the extreme size of the database, we have decided to install an external 1TB drive, and move the database to it.

The difficult bit we're finding is how to make it so that the service loads the new data source.

In other words, how do you use Service Manager to parse an argument to dbsvr.exe in order to change the database location?

Regards,
Matthew.Hi Mathew and welcome to TSDN MSSQL forum,

If you have an agreed maintenance slot where you can take the MSSQL server down, I would suggest do the following:

Back everything up
using enterprise manager detach on the database you want to move
copy the database to the new location
using enterprise manager attach the database by browsing to the new location.

If you get problems, backout by detaching the database in the new location and attach the old one.

Suggest you also try it out on a test DB, northwinds etc before you go for it for real..

Regards Purple