log file on windows server 2003

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

log file on windows server 2003

Author

Topic

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2005-10-10 : 05:28:01

since my sql erver was moved to a windows 2003 server the log file increases dramaticly!
why is that?
i have a db with size of 5 GB and log of 8 GB!!!!!!
which i erase all the time why i that?
thnaks in advance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

Kristen
Test

22859 Posts

Posted - 2005-10-10 : 06:31:02

Sounds like your Transaction Log is not being backed up.

if you don't need the Transaction Log to be backed up (i.e. you are happy to recover from Full backups only, NOT to recover to a point in time) change the RECOVERY MODEL (on that database) to SIMPLE

Kristen

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2005-10-10 : 06:55:14

how do i do that?

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2005-10-10 : 07:34:12

Using EM (Enterprise manager) it's an option that can be set/changed on each database, under it's properties (+ options) tab.
It can also be done via a system StoredProcedure (sp_dboption?). I'd advise that you read BOL for more info.

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2005-10-10 : 07:40:36

quote:
change the RECOVERY MODEL (on that database) to SIMPLE

i have ound the transaction log but didnt find the how to switch to simple - the only thing is to cancel the growth of the log

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

Kristen
Test

22859 Posts

Posted - 2005-10-10 : 08:11:12

Its in
PROPERTIES : Options
when you Right Click the database (in Enterprise Manager).

Kristen

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2005-10-10 : 08:48:21

found it thanks alot:)

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources