| Author |
Topic |
|
kenpachi
Starting Member
5 Posts |
 Posted - 2009-02-25 : 01:45:23
|
| Hi, I have a website that uses a SQL Server 2005 database. I am allotted about 1GB for space, but when my transaction log hits 10MB I get a transaction log full error on my site. Is there some sort of command I could put in my stored procedures to stop those queries from being logged? Or is there a way to minimize or get rid of the transaction log. For my application I don't really need a transaction log. I mainly use the db for caching files.Thanks! |
|
|
soonyu
Starting Member
13 Posts |
Posted - 2009-02-25 : 04:47:56
|
| Make you initial transaction log much larger, I guess the transaction log no fast enough to expand. When we create new database, the initial log file = 1mb and file growth rate = 10 % where when expand only 0.1mb and need expand few time if to take my transaction. I put 500 mb for small database, some database i put the intial size 2 gb and some database log even more larger.Enterprise manager - > database -> transaction log file, just change the file size. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-25 : 07:32:15
|
quote:
Originally posted by kenpachi
Hi, I have a website that uses a SQL Server 2005 database. I am allotted about 1GB for space, but when my transaction log hits 10MB I get a transaction log full error on my site. Is there some sort of command I could put in my stored procedures to stop those queries from being logged? Or is there a way to minimize or get rid of the transaction log. For my application I don't really need a transaction log. I mainly use the db for caching files.Thanks!
You need Transaction Log no matter what recovery model you are using.Are you doing transactional log backup frequently? what is the recovery model of DB? |
|
|
|
kenpachi
Starting Member
5 Posts |
Posted - 2009-02-25 : 13:05:31
|
| Hi, I right-clicked on the name of my database and selected properties and found the following options:General -> Size = 56.19MBGeneral -> Size Available = 0.59MB Options -> Recovery Model = fullThe first two options don't make sense, my host should allow for 1000MB of storage on MS SQL Server 2005 not 57MB... Am I interpreting that correctly? I couldn't find any options relating to transaction logs. Where exactly are those options located? Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kenpachi
Starting Member
5 Posts |
Posted - 2009-02-25 : 18:00:14
|
| Hi tkizer, I want to email their support and notify them of this issue. Which options are not configured properly from the above and what should they be? I'm not very familiar with SQL Server configuration/administration. Thanks! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kenpachi
Starting Member
5 Posts |
Posted - 2009-02-25 : 18:57:25
|
| For the stored procedure, it returned the following:database_name: databasenamedatabase_size: 59.19 MBunallocated_space: 0.84 MBreserved: 58720 KBdata: 57920 KBindex_size: 624 KBunused: 176 KBIn the Database properties (right-clicked on databse name)" -> "Files" section there are no files or options. It just has the database name and owner. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kenpachi
Starting Member
5 Posts |
Posted - 2009-02-25 : 19:48:18
|
| There are no database files listed in the "Files" section. It just shows the database name, and owner. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
How to prevent logging to transaction log?