Perry Whittle (8/8/2012)

---

Because the log backup went to a location outside of the log shipping backup...

anthony.green (8/7/2012)

---

Nothing, Logshipping issues BACKUP LOG commands like you would do normally.

You have missed one key point out of your process.

When you change the database to SIMPLE, to shrink the...

didi77 (8/7/2012)

---

I have to be faster than sql to work If I try to understand.

here my step of the test.

One database, one logshipping, one update query (to grow the LDF...

I have to be faster than sql to work If I try to understand.

here my step of the test.

One database, one logshipping, one update query (to grow the LDF file),...

oh 😀

ok

now I see "nothing"

I let you know, I will make the same test than this morning.

thanks, i've got it,

select log_reuse_wait_desc from sys.databases where name = ''

it's return nothing, so I will re test again and again until a broke the logshipping sequence...

I let you know

could you tell me how to do that "You will need to query sys.databases and when it returns 'nothing' then you can shrink."

because maybe the sql server was not finish...

Today, I retest the same thing of yesterday always on my test server...

i'm totaly lost

what was working yesterday wont today...

with this error message at the restore of the logshipping job...

in fact, because i'm lazy, i've just...

anthony.green (8/6/2012)

---

didi77 (8/6/2012)

---

anthony.green (8/6/2012)

---

Shrink the file, but dont use truncate only.

You will need to ensure that the reuse desc is set to nothing to shrink it down as low as...

I will

thanks

anthony.green (8/6/2012)

---

Shrink the file, but dont use truncate only.

You will need to ensure that the reuse desc is set to nothing to shrink it down as low as possible, otherwise...

So on my sql test server,

I create a quick logshipping, with a data base witch have already a hudge LDF file.

I made a tsql backup log like that :

"BACKUP...

anthony.green (8/6/2012)

---

If you have such a big log after 30 minutes, then change it to 15 minutes.

You can shrink the log in full recovery, but you will have to wait...

anthony.green (8/6/2012)

---

This is standard behavour, the log will become larger than what you are used to as it is not marking the log as re-usable until a log backup occurs.

How...