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 |
|
carrlos
Starting Member
8 Posts |
 Posted - 2012-05-14 : 05:05:30
|
| Hi,Maintanance plan for transaction log is running everyday butdate of SQL transaction log file "idf" doesn't changed , What could be the reason?I would be grateful for helpThanksCarrlos |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-05-14 : 05:35:50
|
Look for LDF maybe that is the reason?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
carrlos
Starting Member
8 Posts |
Posted - 2012-05-14 : 05:41:47
|
| the problem concerns LDF of course - my mistake sorryAny ideas? |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-05-14 : 15:52:58
|
| The date modified on the file only changes when SQL Server is started. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-05-14 : 16:16:59
|
| Sounds scary..What kind of maintenance plan do you run everyday on a ldf file ? Hope so its not shrinking..After Monday and Tuesday even the calendar says W T F .... |
|
|
|
carrlos
Starting Member
8 Posts |
Posted - 2012-05-14 : 20:03:40
|
| SQL serwer is started, mdf is updated but ldf isn't, I have two maintanance plans one for backup and one for TransactionLog... |
|
|
|
|
|
|
date of idf file doesn't changed