• Here are my error messages interspersed with the SQL that caused them.

    -- try just to use the database

    use cfs_vehicle_backups

    Msg 945, Level 14, State 2, Server CFSDB02, Line 3

    Database 'CFS_Vehicle_Backups' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

    use master

    Changed database context to 'master'.

    -- try to add space to the tran log

    alter database cfs_vehicle_backups add log file (name=TranLog2, filename='E:\SqlData\Cfs_Vehicle_Backups.log2', size=20MB)

    Msg 945, Level 14, State 2, Server CFSDB02, Line 3

    Database 'CFS_Vehicle_Backups' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

    -- try to set the database offline

    alter database cfs_vehicle_backups set offline with rollback immediate

    Msg 5069, Level 16, State 1, Server CFSDB02, Line 3

    ALTER DATABASE statement failed.