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 |
|
Jeff_visualsolutions
Starting Member
1 Post |
 Posted - 2005-01-05 : 23:44:35
|
| How to schedule a job in SQL Server 7.0 which can shrink the log? |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-01-06 : 00:40:06
|
| If you shrink the log it will grow back again - which will take some effort for SQL.I shrink the log after some unusual activity (such as deleting masses of records), but not at other times.Is there a specific reason you need to schedule shrinking the log files?Kristen |
 |
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2005-01-06 : 00:40:19
|
| Use DatabasegoDBCC SHRINKFILE ( { Log file_name | Log file_id } { [ , target_size ] | [ , { EMPTYFILE | NOTRUNCATE | TRUNCATEONLY } ] } )Schedule the SQL statement in Agent.does it help (???)Hemanth GorijalaExchange a Dollar, we still have ONE each._______Exchange an Idea, we both have TWO each. |
|
|
|
|
|
|
SQL SERVER 7.0