May 19, 2008 at 4:56 am
HI Friends
One of server my job is getting fail. It will showing log speace is full but log speace is 24GB But actually my log file actual speace is 30GB How can i handile this isssue plz help me urgent
Thanks
MS
May 19, 2008 at 5:04 am
Hi
Is your DB set to FULL Recovery?
Do you have your logs backed up?
Can you set your DB's recovery mode to SIMPLE? - if yes then you can shrink Log File after that
Let us know
Thanks
Kevin
May 19, 2008 at 5:15 am
yes i can do the same thing but againg that job is failing.
1st One backup Job is running at 6:00 Pm
2nd job is running at 7:000 pm i can shrinke it.
Again it will fail any help plz
It will saying operating system error 112
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply