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)
 Size log file increase

Author  Topic 

brinster
Starting Member

8 Posts

Posted - 2006-07-06 : 04:54:14
Hi

What is the parameter in sqlserver 2000 who stop the increasing of file datafile log
?


Regards

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-07-06 : 05:00:27
In EM you can specify maximum file size under Restrict file growth (MB) option or in Create/Alter database statement with the MAXSIZE clause.

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-07-06 : 05:27:38
or where you looking at recovery model - simple

--------------------
keeping it simple...
Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-06 : 06:31:32
See
http://www.nigelrivett.net/SQLAdmin/TransactionLogFileGrows_1.html

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -