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...

jugo.pinky (7/12/2012)

---

Hi,

I had configured log shipping before one month.it was working fine.secondary server had shut down due to some reason.when i restarted secondary server restore job is not working.error is...

Hello,

i am confused i have changed the port in my test server and asked a developer to give a desktop application which will allow me to enter port number and...