have you checked sql agent error log?

xp_ReadErrorLog 0, 2, NULL, NULL

go

xp_ReadErrorLog 1, 2, NULL, NULL

post the results for this.

forgot to mention scott 's thought is good allocate the growth size that fits your reuirement.

dont reduce it do low as db growth requires lot of resources and time. check...

so logs will not clear/reused untill a log backup happens.

check the log file size and act accordingly.

run dbcc sqlperf(logspace)

see if you DB's log file is huge then you can clear log file. make sure that you have a full backup or log file not required.

never...

yes create the table script with "Include if not exists" as yes then table wont be created but index will be created.

Daxesh Patel (7/26/2012)

---

dakshinamurthy-655138 (7/26/2012)

---

Thanks for the Quick Response.

It worked for us Successfully.

Again i need one more clarification, assuming that i used the command STOPAT and then if i have iterate...

is there any reason...

Is the slow backup job have enabled any of the reliablity settings like verify backup or perform checksum?

i hope sql process wont delay the backup timings may be log...

experts advice pls?

is 2932 through ?

when did the sql service restarted last?

How come .mdf files after first file?

How about delaying the log files deletion say after a day .

We have only one instance in that development server.

Lowell,

My SQL browser service is stopped, still the above thing happens.

anthony.green (7/12/2012)

---

Yes it is normal for it to delete log files.

Secondary server cannot restore TX4 as it needs to first restore TX3 which is cant as the TX3 file doesnt...