Tnx for the answers, really helped me.

Tnx for answering, Aiden. I had something similar, but was hoping for a more elegant solution. I can't find it, so I guess I'll have to use the brute-force approach....

Right, tnx. I looked here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&DisplayLang=en

Right, I will try that then. Out of curiosity: what does ObjectID here refer to? Funny thing is, when I did a Select * from Table it showed up in...

Tnx for the info, found them indeed. Starnge though, that sp_trace_getdata is simply under the Stored Procedures...

But never mind that, tnx again.

OK, I was too quick to ask this question. Decided to click the show all columns button....

It seems I can only select DatabaseID now......

I managed to remedy the problem by completely deleting publication and setting it up with slightly different articleproperties. Duno why, but got me a config which works now...

Why don't you give the users of that database db_datareader role...

That we be the best way to do this. However, the company I'm working currently has NO info written...

Hi guys, tnx for responding.

Dont't worry, I can code a solution, the question is: what solution would be better.

The re-occurring sequence is like I gave an example of, and it...

Snapshot would pose problems. Users wish the targetdb to be up te date realtime...

Some suggestions:

If you have a backup from before this increased growth, you could load it, compare it with your current db and try to figure what has increased. You say...

Hi Robert,

Tnx for responding. An example:

I receive a box of cards, factory shuffled. This means, that the cards are quasi-randomized put into the box in a certain order. Say you...

Hi Holger, tnx for responding.

I am confused, however. I can not see a Maintenance Wizard as you describe. We ARE talking about SQL Server 2005, right?

EDIT:

Found it, sorry...

Tnx for answering, SBlock. I was confused too. I have checked this, adding DENY-permissions to a user with SA rights, but I noticed no restrictions. Probably someone had played around...

Found it. It seems I need to create a NEW Backup Database Task and then choose Transaction log as a backup type. Confusing, but that's what you get when you...