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 |
|
prodigy2006
Yak Posting Veteran
66 Posts |
 Posted - 2009-12-01 : 13:58:45
|
| The database is in Simple recovery mode.MDF=1 GigLDF=13 GigI just took a full backup hoping that the trans log file size would be reduced, but the log file's size remains the same. Will this work if I execute the below statement:"BACKUP LOG xyz WITH NO_LOG"and then shrink the file. I don't want to lose any data. Just curious what will this "BACKUP LOG xyz WITH NO_LOG" do? Will this truncate the log file and the MDF's size would increase?Please suggest. |
|
|
prodigy2006
Yak Posting Veteran
66 Posts |
Posted - 2009-12-01 : 14:34:12
|
| Someone please reply. If my question isn't clear, I'll try to reprase it but I need your help pretty urgent... |
 |
|
|
john.burns
Posting Yak Master
100 Posts |
Posted - 2009-12-02 : 11:45:52
|
| -- Truncate inactive portion of logbackup log hhapp with truncate_only--)Shrink Tlog file to recover spaceUSE hhappGODBCC SHRINKFILE (hhapp_log, 500)GO |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Log file growth