With my current hosting i got this second time for this
Message: The transaction log for database 'horrorclub_net_DB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
this problem can resolve by runt two command.
DBCC SHRINKFILE ("HorrorClubStandUp_log", TRUNCATEONLY )
BACKUP LOG horrorclub_net_DB WITH TRUNCATE_ONLY
Yes Shrinkfile and backup it.
look like my database grow up everyday.
ref url : http://blog.nerdbank.net/2006/07/how-to-empty-sql-server-database.html
ไม่มีความคิดเห็น:
แสดงความคิดเห็น