Hi SQL Noob,

In a previous post, you said it was buggy...

Does that mean that you are happy to buy a buggy database backup software :crying: or that it's not buggy...

Well, I have a little stored procedure that, given another stored procedure name, generates a simple test harness.

Nothing rocket science: begin tran, declare all required parameters, set values (NULL by...

I must spend a bit of time looking into the factless fact idea. I am in no rush.

However, if I went for the initial solution, I suspect I still need...

I know you can set options regarding Snapshot isolation (allowing) and whether you want READ COMMITTED to be implemented via snapshot but I don't think there is more...

The backup drive is roughly 340Gbs and there is at least 120Gbs free when backing up.

The data drive is about 50% full (or empty...).

Having said that, we actually ran out...

Kind of... Makes me think!

I suggested to use a datamart instead of fullfilling the client's report request one by one and we are not planning to use Analysis Services (cubes)...

You may be right

I'll have to go back to his books (which I have read some time ago)

Thanks

Arati,

I don't have the answer to your question but I would question whether it's a wise idea to fire an SSIS package from within an ASP.Net page.

If what that package...

Which one?

Professional SQL Server 2005 Integration Services

or

Expert SQL Server 2005 Integration Services (Programmer to Programmer)

Ok, got it!

Many thanks 🙂

What about if you create tempdb in the "same" location on both nodes...

For instance ona D:\TempDb folder?

The only thing that would get out of step is the actual size of...

Maybe you could setup a server side trace on database growth for the tempdb database...

That might help finding out who is requiring that space.

Actually... It works fine if I use the Ado.Net provider instead of OleDb

Thanks

Eric:D

I tried that but it seems to ignore the parameter names... and falls down if they are in the wrong order

:ermm:

Thanks