The other day I had a situation where the drive containing the files for a log shipping secondary database was full and the log restores were failing. Normally for an online database you modify the file locations, take the db offline, physically move the files, and then bring the db back online. However if the database is in restoring mode it will not allow you to take it offline. Luckily we can work around this. In this case modify the file locations and then stop sql. Physically move the files and then restart sql. When sql starts it will find the files in the new location.
-Jeremy
no comment untill now