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 |
|
senthilkmd
Starting Member
4 Posts |
 Posted - 2003-03-04 : 10:58:35
|
| Hi Friends, Greetings... I am begineer to SQL.I Came with One problem.I have here 162MB DataBase and 791MB Transaction Log.I want to reduce the size of Transaction log file and i want to maintain the same file with particular size.Here i am using SQL Server 7.0 with Win NT Server. Expecting Reply from experts...with advance thanksSenthil. |
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2003-03-04 : 12:03:21
|
| Senthil,You need to implement a backup strategy for this database that includes regular full database backups and transaction log backups.Your transaction log is probably growing in size because it has not been backed up enough.There is an article in the Books Online explaining various backup and recovery strategies. Search for "Choosing a Backup and Restore Strategy". You will find a link to the Books Online in the SQL Server group on the Start menu.-- monkey |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-04 : 15:16:21
|
| If your system isn't production or if you don't care about being able to restore to a point in time, then just change your database recovery model to simple. You can do this in EM by going to the properties of the database.A quick way to modify the transaction log file size is to detach it and then reattach it. The database will be unavailable when you do this though, but only for a couple of seconds.Tara |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-03-10 : 23:36:42
|
| Simple Recovery doesn't exist in 7.0. You should set truncate log on checkpoint if you don't care about restoring tran log backups.-Chad |
|
|
|
|
|
|
To control the Transaction Log file size