views:

194

answers:

1

I have just installed the excellent Search Server Express 2008 onto one of our servers.

As a default all the databases created are put into locations on the c: drive.

Does anyone know where all the databases are located and how they can be safely moved.

+1  A: 

The data files will be located within a subdirectory of the detault SQL Server Folder so

C:\Program Files\Microsoft SQL Server\100\

See How to: Install SQL Server 2008 (Setup)

In order to move your databases data files the most straightforward method would be the Detach/Attach Method

As always, please ensure that you either perform or already posses a backup of your database data prior to carrying out such administrative tasks..

John Sansom
This is not correct. The databases are not located here and a simple detach/attach does not take into account the search/sharepoint services that are running.