If you want to keep your log size small, take backups more frequently and ship the logs right away.

If you need to keep an older copy of your database, you...

You could wait for the job to complete in a loop from QlikView.

It can be done quite easily in a stored procedure.

I rarely use maintenance plans, also for this reason.

Use a plain T-SQL script in a job step instead.

Question withdrawn?

Indexes have to be scripted manually from publisher to subscriber. Maybe a powershell script could help you.

Index maintenance has to be run on both publisher and subscriber.

32 GB is not a huge amount of RAM: get more if you can. Obviously, unless your databases are so small that they fit in RAM anyway.

As far as bus...

Sure. Give us some data in a consumable format and you'll get the answer right away.

Read the first article...

RESTORE VERIFYONLY is what you're looking for.

Relevant info here:

http://technet.microsoft.com/en-us/library/ms188902(v=sql.110).aspx

http://www.mssqltips.com/sqlservertip/1093/verifying-backups-with-the-restore-verifyonly-statement/

And the question is?

Moreover, this is a SQL Server forum: no Oracle experts here.

I'm not sure I understand what you mean.

Maybe this?

WITH sampleData AS (

SELECT *

FROM (

VALUES

(32, 123, 'test', 'A'),

(32, 124, 'test2', 'A'),

(55, 125, 'test', 'B'),

(55, ...

The easiest tool for this job is an audit.

More information can be found here: http://msdn.microsoft.com/it-it/library/cc280386.aspx

Good luck with that...

There's a tool that does the exact opposite, but I don't know if Oracle provides one.

Oooops! I hit the wrong button...

cdm33.com (7/30/2014)

---

SQLRNNR,

This code has hundreds of lines to it. I've got no clue what it does. I'm not going to put something like this on a production server...

Thanks for correcting me, Gail.

I remember I had...