Hi

Did the log backup now.

It's about 75Gb.

Transaction logs remaing 141Gb with about 30% free

What now ?

ok, thx !!

i'm already running a trasnaction log backup

Thought a full backup did it !

Many thanx

In the maintenance plan a full back up is made, but no space is freed.

It's now running up to 131Gb

We make a backup once a day.

When is it moved...

Hi there

I know I give few info and I am asking a lot.

We are not running big queries. There are no deadlocks.

Database is running on disk, transaction log is running...

Hi

it was in fact null values

but mean while i did find the solution.

It was a report field error

kind regards

Jeff

As i was posting, i just got the idea 🙂

So don't bother any longer and help some other guys and girlz !!!

Thx !

ok, unfortunately replication is now running and there is no way of backing up the transaction log now.

But when I look into the activitity monitor I see that the following...

ok, and how can i check this ?

I've launched the replication monitor and nothing is running.

Hi, log reader is new to me.

How can i find out it's running ?

thx in advance

Sorry but it doesn't work !

Message is this :

Cannot shrink log file 2 (NAV_SEPIA_Log) because all logical log files are in use.

DBCC execution completed. If DBCC printed error messages, contact...

We've dropped the publication once and then we could truncate.

But then we of course have to setup replication again.

Anyone got a clue ?

It's running fast.

thx

today

but it won't shrink.

Try this one :

http://www.cryer.co.uk/brian/sqlserver/error21776.htm

Did you copy the database ?

Good luck !

many thanx !!

Hi

On which server did u install this ?

On the SQL server or the client/citrix side ?

Many thanx

Jeffrey