You can use dsmaint to change your datastore, as documented in the Admin Guide.
If the SQL server goes down, you have 48hrs to get it up again, since the Data Collector will maintain the information locally. With FR2 this is increased to 96 hours.
Alternatively, many large installations have clustered database servers for this eventuality.
I hope this helps
CitrixEngineer@yahoo.co.uk