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 |
|
ray-relish
Starting Member
2 Posts |
 Posted - 2009-01-23 : 06:45:47
|
| Hello dear developers,I came to a point where SQL Server 5 has been passed under my maintenance, however I have got no knowledge at all how to control it. I am totaly newbie in this field as i do code PHP, ASP, JSP, ActionScript etc.. but NO server administration skills. ZERO.Please help me with following issue and it wouldbe VERY helpful if you could guid my step by step.Company runs online shop and this morning i did get folowing message on browser: Microsoft OLE DB Provider for ODBC Drivers error '80040e14'[Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database '12345' is full. Back up the transaction log for the database to free up some log space. After some research I found that i should backup/truncate transaction file for '12345'. I don't want to mess around too much as I am afraid of loosing data or corrupting server.please advise!!! |
|
|
ray-relish
Starting Member
2 Posts |
Posted - 2009-01-23 : 07:05:42
|
well,i did mention same question in other forum an my question was answered in less than 20 sec. Problem is solved, unfortunetly no one on this forum could give me a clue what's wrong..sorry i'm out of here..  |
 |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2009-01-23 : 09:25:02
|
| Perhaps if you took those 20 seconds and did a forum search for your problem, which was how to back up the transaction log, you would have found your answer.[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQL or How to sell Used CarsFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-01-23 : 15:39:56
|
quote:
Originally posted by ray-relish
i did mention same question in other forum an my question was answered in less than 20 sec.
Did someone tell you to truncate the transaction log? I hope not.quote:
sorry i'm out of here..
We'll miss you. Not.Just in case you're still around, here's a primer on managing transaction logs.[url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-01-23 : 15:57:58
|
| Yeah. Some people seem to think this is a chatroom--Gail ShawSQL Server MVP |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-01-23 : 16:03:23
|
quote:
Originally posted by ray-relish
well,i did mention same question in other forum an my question was answered in less than 20 sec. Problem is solved, unfortunetly no one on this forum could give me a clue what's wrong..sorry i'm out of here..
wrong time dude, if vishakh was here you've had it in 0.2 secs |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-01-23 : 17:53:20
|
| apparently people on the other forum don't have jobs.Mike"oh, that monkey is going to pay" |
|
|
|
|
|
|
|
|
The log file for database '12345' is full