Instructions for Moving the Checkbox SQL Database

[BahamaER]

Our SQL server currently ran out of space and we now need to move it to new drive, has anyone ever done this before? I would like instructions on moving the Checkbox SQL server from the C drive to the D drive. Are there any special configurations for IIS as well?

[hans.nilsson]

Our SQL server currently ran out of space and we now need to move it to new drive, has anyone ever done this before? I would like instructions on moving the Checkbox SQL server from the C drive to the D drive. Are there any special configurations for IIS as well?

If you only want to move the Checkbox database to D:, you should be able to use Detach/"Move Checkbox MDF/LDF files"/Attach.

SQL Server Help states the following:

The data and transaction log files of a database can be detached and then reattached to the same or another instance of SQL Server. Detaching and attaching a database is useful if you want to change the database to a different instance of SQL Server on the same computer or to move the database.

Look under "Detaching and Attaching Databases" in SQL Server Help

/Rgds, Hans

PS.
If you need to move the whole SQL Server installation it?ö¼?öñs a little more work...

[spatters]

We'll be switching to a different server\instance in the near future. Is there a way to just specify a different connection string to do this?

[ncushing]

To point Checkbox to a different database and/or database server, you can edit the connection string named DefaultConnectionString stored in the <connectionStrings /> section of the Checkbox web.config.

[BahamaER]

Thankyou for the responses, I was able to use the detach/attach method.