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 |
|
Maxer
Yak Posting Veteran
51 Posts |
 Posted - 2007-12-11 : 09:13:38
|
| I'm on SSMS under Management --> Maintenance Plans --> (my transaction log backup plan)I right click and choose "View History" at which point the log file viewer window opens and it just sits there... with the progress circle runnning just saying "Initialize Log #2..."After roughly 5 to 10 minutes it returns results.Any suggestions on how I should resolve this or what to trouble shoot?Thank you. |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-12-11 : 11:00:39
|
| 2 things come to my mind, try to open the log manually by steering to that folder, if the size is big you could hvae that problem. Also sometimes if the folder is compressed, it plays tricks.RegardsParesh MotiwalaBoston, USA |
 |
|
|
Maxer
Yak Posting Veteran
51 Posts |
Posted - 2007-12-11 : 14:41:59
|
| I do have several thousand log files in that folder and some of them are 14 megs.How should I go about pruning those files out?Do I need to setup an automated / scheduled task to delete them after a time? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-11 : 22:28:36
|
| Plan's log files have timestamp in file name, just delete old ones. |
|
|
|
Maxer
Yak Posting Veteran
51 Posts |
Posted - 2007-12-12 : 08:52:02
|
| Is there a way to set it to automatically purge after X months somewhere though? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-12 : 22:40:55
|
| You have to write your own code, maintenance plan's file clean task doesn't delete plan log files. |
|
|
|
Maxer
Yak Posting Veteran
51 Posts |
Posted - 2007-12-13 : 08:50:43
|
| Ah, thanks. |
|
|
|
|
|
|
Log File Viewer hangs on "Initialize Log ..."