Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
raky
Aged Yak Warrior
767 Posts |
Posted - 2009-08-25 : 06:20:11
|
Hi,When iam trying to alter any procedure it is giving errormessage asThe transaction log for database 'submit' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases . Please suggest what to do... |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-08-25 : 06:27:06
|
Backup your database. |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-08-25 : 06:39:37
|
Appears your transaction log is full on your submit database.Would suggest you get a backup of the database. Ensure you keep 40% freespace in the database at all times and take nightly backups going forward.There are different ways to do this:MethodsDBCC SHRINKFILE (' {Enter your DATABASE} ',TRUNCATEONLY)BACKUP LOG {Enter your DATABASE} WITH NO_LOGWhen doing SHRINKFILE, BACKUP LOG operations one more activity has to be considered. Anyway the Transaction Log reduced. "Page Fragmentation also will increase". -------------------------R... |
|
|
|
|
|