We were lacking diskspace on our SQL-cluster (F-drive) and added a new one (H-drive).
Then we detached a database and now want to attach it. However, the H-drive is not visible when we choose "attach". I read somewhere you can set the default location of database so new database will go to the new drive, but this seems a bit tricky. Won't SQl look for all its database on the H-drive then?
I would prefer to just reattach from H-drive, moving database by database.
Thanks for your feedback.