Moving SQL databse of Bigfix to different location on the BigFix Serve

Usage and Config Platform
1

(imported topic written by sharad91)

Hi :slight_smile: ,

The BigFix Server and the SQL Server are installed on the same partition. Now the disk partition is full and there is no space available on the partition. So i want to move the database to another partition where lot of free space is there.

In this case disaster recovery will not help, as i am not uninstalling the BigFix Server and only moving the database to another location.

Any one knows the solution for the issue, if you have any best praactices please provide.

Regards

Sharad

2

(imported comment written by BenKus)

Hi sharad,

You will want to follow standard instructions online for moving a database (backup/restore will work or detaching/reattaching will work… I prefer the backup/restore method…) After it is moved, you can change the ODBC settings on the server and consoles to use the new server. If you are using NT Autentication, you will need to change the login users for the FillDB, GatherDB, and Web Reports services to be a user with access to the database.

Ben

3

(imported comment written by sharad91)

Hi Ben,

To backup/restore i have to follow the instructions of Microsoft SQL, once it is moved to other location how we will be configuring the BigFix Core to use the new database. Do you any such document from bigfix ? Please provide.

Thanks

Sharad

4

(imported comment written by BenKus)

Hi Sharad,

Here is how to add a new ODBC connection for your consoles:

http://support.bigfix.com/cgi-bin/kbdirect.pl?id=118

Here is some more info on ODBC DSNs:

http://support.bigfix.com/bes/install/odbcguide.html

Ben

5

(imported comment written by sharad91)

Hi Ben,

Thanks for the support. The issue got resolved.

Thanks again

Sharad