Rank: PA User
You have been a member since:: 23/06/2010(UTC)
Objave: 12
|
|
|
|
|
|
|
Rank: PA User
You have been a member since:: 23/06/2010(UTC)
Objave: 12
|
Pozdrav,
htio bih smanjiti velicinu baze koja ima oko 10 GB. Uradio sam shrink baze, ali mi je to smanjilo svega 150 MB. Tabele loga promjena the_move_undo, the_moveitem_undo...sam obrisao, ali mi se baza dodatno povecava.
|
|
|
|
|
|
Rank: Datalab
You have been a member since:: 24/04/2009(UTC)
Objave: 204
Was thanked: 2 time(s) in 2 post(s)
|
Ima opciju shrink database i trancaction log (ldf file). Shrink transaction log ste uradili?
|
|
|
|
|
|
Rank: Datalab
You have been a member since:: 24/04/2009(UTC)
Objave: 204
Was thanked: 2 time(s) in 2 post(s)
|
|
|
|
|
|
|
Rank: PA User
You have been a member since:: 23/06/2010(UTC)
Objave: 12
|
shrink database i trancaction log mi je smanjio veličinu baze za 500mb.
Ne bih mijenjao recovery model na simple.
Hvala na savjetu.
|
|
|
|
|
|
|
|
Message was deleted by a Moderator. | Reason: Not specified
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
Orange-Grey Theme Created by Ingo Herbote (WatchersNET.de)Powered by YAF 1.9.6.1 Under DNN |
YAF © 2003-2025, Yet Another Forum.NETThis page was generated in 0.677 seconds.