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 |
|
putane.sanjay
Yak Posting Veteran
77 Posts |
 Posted - 2006-12-01 : 05:19:59
|
| Hi how to remove transaction logs when itb is 100% and we have marketing datrabase it's maxsize is 80 mb, now the size of the database is 65 mb how to increase the size of the databaseplease help meregardsP.M.SANJAY |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-01 : 05:24:32
|
YOU CAN'T REMOVE TRANSACTION LOG!!If you want to keep log size to the minimum, use SIMPLE recovery model (although it's not recommended on Prod database). quote:
how to increase the size of the database
You can use ALTER DATABASE MODIFY FILE option to change MAXSIZE parameter.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2006-12-01 : 06:15:00
|
| why do you wnat to increase the size of your datrabase then ? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-01 : 06:16:17
|
| If you are need to use FULL Recovery Model then backup the transaction log frequently - every 10 minutes would be a good choice. Then over time the transaction log will grow to a size needed to accommodate your "busiest 10 minutes"Kristen |
|
|
|
|
|
|
remove logs