BigFix User Group

sharad · 2009-11-06 04:37:51

Hi ,

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

Ben Kus · 2009-11-06 20:52:16

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

sharad · 2009-11-06 22:00:24

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

Ben Kus · 2009-11-07 19:11:47

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

sharad · 2009-11-10 20:49:21

Hi Ben,

Thanks for the support. The issue got resolved.

Thanks again

Sharad

BigFix User Group

#1 2009-11-06 04:37:51

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

#2 2009-11-06 20:52:16

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

#3 2009-11-06 22:00:24

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

#4 2009-11-07 19:11:47

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

#5 2009-11-10 20:49:21

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

Board footer