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.
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.
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.