sql server - Set offline failed for database 'MyDB' -

my program failed exception:

system.data.sqlclient.sqlexception:  transaction log database 'mydb' full.  find out why space in log cannot reused, see log_reuse_wait_desc column in sys.databases 

i noticed tables doesn't load in sql management studio , cann't open database properties window

then try change log file autogrowth statement:

 alter database mydb  modify file  (name=mydb_log,maxsize=2tb,filegrowth=20mb); 

this statement executed doesn't me recover database try set offline mydb operation failed exception set database in single user mode exception still exists try statement:

alter database mydb set emergency; go alter database mydb set single_user go dbcc checkdb (mydb, repair_allow_data_loss) all_errormsgs; go alter database mydb set multi_user go 

this statement failed on first line.

and don't know should do.

follow following steps.

• open sql management studio , connect database server
• right-click database
• click properties
• click options link
• set recovery model simple follows

• click ok
• once complete, right click on database again
• click tasks>shrink>files
• on shrink database window select file type 'log' . file name appears in filename drop down databasename_log follows:

the space used versus space allocated displays. after set recovery model simple, majority of space in transaction log released.

• ensure release unused space radio button selected.
• click ok on window shrink transaction log.

you might want read through short post http://sqlity.net/en/556/t-sql-tuesday-25-%e2%80%93-sql-server-tips-tricks/