The CLR

It is rather quick.

Andrew

Very nice, that is perfect.

Really fast and works perfectly

Andrew SQLDBA

Thanks WildCat

I figured it out right after another coffee.

I will keep your sample code for future queries.

Thanks again

Andrew SQLDBA

The company that I am currently contracting with uses VM, it absolutely sucks when it comes to running SQL Server on it. Some of the databases are in the 5Tb...

Wayne

I never once said the secondary box was not on a network, of course it is. I stated that was not on the same network. Meaning it is on a...

Yes, because the secondary box is a DR box that is on a separate network that has only one way communications. I can only see the secondary box from the...

This is to keep a secondary DR box up with the Primary box.

I want to restore the Full from the primary box to the secondary box once a week

Restore the...

What I meant was, can I restore each type of database backup without messing up the log chain?

Restore the Full every friday afternoon, and continue with the logs, restore the...

I must have totally mis-understood what I have read in the SQL BOL.

So I can restore those other databases in a continuous loop, right after they are taken, and everything...

I never place anything of SQL on the same drive as the OS, in fact, nothing ever goes on the same spindle as the OS.

As far as databases, I keep...

This is only part of it, you can use the C# documentation to use the different classes for files, and file control. This code compares the file time, not the...

That tell me the next time the job will be fired off, it does not tell me the frequency. Such as "Every 15 Minutes"

Is this done by a calculation?

Andrew SQLDBA

Sure, anything is possible. I have written this type of code. I used the "Script Task" and written the code in C#.

Andrew SQLDBA

You should really use a bit data type if that is all you expect to return. I would also use the SET command to set the value, and then the...

Yes, ISNULL does require only two arguments, you are trying to use 3 arguments.

ISNULL ( check_expression , replacement_value )

Andrew SQLDBA