Moving Vault database

aldredge · Post by **aldredge** » Thu May 25, 2006 11:32 am

I have recently installed vault and SQL Express 2005 onto my server. I need to move the vault sgvault.mdf from the OS Drive to a higher speed raid drive.

I would like to move the file
From : C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
To: F:\vault\

Can anyone provide instructions on how to properly move this file? or at least point me in the right direction.

-> Vault Client Version: 3.1.8.3771
-> SQL Version: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition with Advanced Services on Windows NT 5.2 (Build 3790: Service Pack 1)

Thanks,
Lonnie

Post by **jclausius** » Thu May 25, 2006 12:10 pm

Perhaps the easiest thing to do is to detach the sgvault database, move the .mdf and .ldf files, and re-attach the database from the new location.

See 'How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server' for more information.