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 |
|
locked_db
Starting Member
2 Posts |
 Posted - 2007-11-22 : 18:05:51
|
| My database is set to retricted file growth to 10MB. My application stops appending records and giving an error "Database Insertion Error".I observe that the transaction log reaches to its limit. When I setup the transaction log to unrestricted file growth and click apply. the settings is not taking effect. --- are there any way to rollback the restricted file growth to unrestricted? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-22 : 22:46:28
|
| Do you have permission to do that? |
 |
|
|
locked_db
Starting Member
2 Posts |
Posted - 2007-11-23 : 02:12:21
|
| yes, I use windows authentication mode during the installation of sql 2005. How can i set transaction log from restricted file growth to unrestricted? Thanks. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-23 : 03:30:01
|
Have you tried doing this without the GUI?alter database dbname modify file (name = <physical_filename>, maxsize=UNLIMITED, filegrowth=10MB)GO |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-24 : 00:53:54
|
| What kind of permission do you have in sql server? |
|
|
|
|
|
|
Transaction Log Problem