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 |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2005-04-18 : 04:15:31
|
| The log file of one of my database has gone upto 60GB ??? I have tried to shrink the database but the log file size remains the same.Any clues how I can handle this? If I delete the lof file will it cause any problem? Will appreciate help.Many TIA |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-04-18 : 04:44:00
|
| do you need point in time recovery?if no, a. backup the log with truncate_onlyb. shrink the fileif yes,a. backup the log (make sure you have enough space)b. shrink the filethen,create maintenance jobs to maintain the log size to manageable level--------------------keeping it simple... |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-04-18 : 08:32:51
|
| If you don't need point in time recovery, just set the database recovery mode to simple and shrink the file. Do a full backup after doing this.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Joozh
Posting Yak Master
145 Posts |
Posted - 2005-04-19 : 00:35:45
|
| Thanks for the help.I do not ned point in time recovery but do not know how to go about your suggestion i.e. How to set the database recovery mode to simple. Via query Analyzer by running some command????Shrinking is easy = Just right click on the database, and from the options select the Shrink option. Right? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-04-19 : 01:29:41
|
| from enterprise manager, right click your database, select properties, go to options tab and select 'simple' recovery mode.-ec |
|
|
|
|
|
|
Huge size of log file???