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 |
|
suman.reddy39
Starting Member
34 Posts |
 Posted - 2008-07-10 : 04:43:33
|
| dear all, my t.log file is full for 1 of my DataBase.and it says that i can not resuse the t.log file again. i dont know why? please let me know how to see the t.log file and how to delete the data from it, so that i can reuse it.thanking you in advance.subbi |
|
|
suman.reddy39
Starting Member
34 Posts |
Posted - 2008-07-10 : 05:53:56
|
| i got the solution just now. take the full back up of the database to which log file is full and then take a transactional backup of that db.Don't go the way Life takes you, Take the Life the way you gosubbi |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-10 : 23:18:01
|
| You should backup log in more frequent schedule. |
|
|
|
|
|
|
Log file is full