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 |
|
wided
Posting Yak Master
218 Posts |
 Posted - 2014-02-20 : 11:51:40
|
| Hello, I have a database that has become enormous. I trvaillé before with the old version of SQL and I used the command: DUMP TRANSACTION WITH DBNAME no_log Then I use the instruction Shrink Database With vesion 2008, I have not found the equivalent of instruction DUMP I already posted this problem and told me that I should save the database with simple recovery. But I can not do this operation Thank you for helping me. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-02-20 : 13:02:46
|
| You have only two choices:1. Change the recovery model to SIMPLE (which you said you cannot)or2. Backup the log file (and schedule regular log backups).In either case, after you have done it, shrink the log file to some reasonable size.Exact instructions to do either of these should be available if you google for it, but if you need more help, post back. |
 |
|
|
|
|
|
DUMP A LOG FILE