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 - 2005-01-26 : 08:32:56
|
| Nathan writes "The Last Modified dates for the transaction log and database files aren't changing, yet we continue to use the database for Sharepoint/WSS.Is this related to poor performance of the WSS file system?How do I (safely) force the database to update from where this info is cached?(Is this a hard question -- or is it only difficult because it involves WSS?)Thanks,NathanSQL2000sp3aWSS/SPS2003" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2005-01-26 : 13:22:03
|
| I'm not sure exactly what you are talking about, but I think checkpoint is the command you are looking for.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-01-26 : 13:50:03
|
| The modification date of a datafile does not change on inserts/updates/deletes. It only changes if the datafile is resized in some way.There might be some other reasons for the modification date changing that I'm not aware of, but just inserting data will not do it.-ec |
|
|
|
|
|
|
Sharepoint's SQL Transaction Log and DB not being updated