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 |
|
lisa_baria03
Yak Posting Veteran
60 Posts |
 Posted - 2007-10-14 : 12:44:43
|
| i am trying to add a transaction log file which is the same size and characteristics as the existing log file in sql sserverwould this be correct? im not sure what would be the maxsize or the filgrowth of an existing log file. Alter database db1Add log file( Name = db1 Filename = db1.log Size = 1MB, Maxsize = , Filegrowth = %) |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-14 : 16:20:58
|
| Why do that? It doesn't give you any performance gain. |
 |
|
|
lisa_baria03
Yak Posting Veteran
60 Posts |
Posted - 2007-10-14 : 16:49:48
|
| this is just to learn i just like to learn how it works and reason for adding an existing file also if the code is correct. i'm not too sure in what to set the filegrowth size of the logfileDo you know the size of an existing log file?thank u |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-14 : 16:59:58
|
| You better to take formal sql training to get basic sql server knowledge. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-10-14 : 17:50:00
|
| this informaton is covered in books online. |
|
|
|
|
|
|
adding log files