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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-08 : 09:16:00
|
| Vishal writes "Dear Sir,Iam Running Ms-SQL 2000 server, my database is in 2 years is 19.96MB but my Log file is 1.19Gb. And more offen i have to get the SQL offline to shrink the Log File, which is during the perk hour of bussiness. I did setup the auto-shrink function on the server but i seems not to be wprking at all, perhaps the codes i got is wrong.Please adive,Vishal" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-08 : 11:51:46
|
| What is your database recovery model set to? I suspect it is set to FULL and no transaction log backups are being performed? If you don't need the ability to restore to a point in time, then change your recovery model to SIMPLE. If you do, then start backing up the transaction log. DBCC SHRINKFILE can shrink the database files, but there must be empty space in the file to do so.Tara |
 |
|
|
|
|
|
database log shrinking.