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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-06-16 : 08:46:02
|
| Naveen writes "I received the error message "log file for database PROD_TUNING full. Backup the transaction log to free up some space." And need help to find where I can find the Transaction Log Files." |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2006-06-16 : 16:37:23
|
| Naveen, each database in sql server should have a data file (.mdf extension) and a log file (.ldf extension).Check the diskspace and increase the logfile to some amount. This is temporary fix.Take the database FULL backup of database and Shrink the Log file if you dont require ...Backup database abc to disk = '<PATH>'goDBCC SHRINKDATABASE ( database_name [ , target_percent ] [ , { NOTRUNCATE | TRUNCATEONLY } ] )With RegardsBSR |
 |
|
|
|
|
|
Help Regarding Transaction Log File