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 |
|
s_hasan
Starting Member
1 Post |
 Posted - 2007-11-03 : 04:02:15
|
| Dear all,How can I resize SQL -2005 log file ?Please help meHasanHasan |
|
|
evilDBA
Posting Yak Master
155 Posts |
Posted - 2007-11-03 : 07:45:30
|
| What do you mean be 'resize'?Make it bigger - allocate some space in advanceMake it smaller - shink (if there is enough free space in the log -> it is backed up) |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-03 : 20:25:30
|
| Just search 'shrink log' here, you can find lot of related threads. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-04 : 02:23:23
|
| See: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Database%20Shrinking,Shrinking,Shrink |
|
|
|
|
|
|
How can I resize SQL -2005 log file