Just a little alternative to the above replies.

Maybe you can just create the backups on a local drive, in the last step of your local backup job, robocopy the .bak...

can you post the results of:

(sqlserver version info)

Select @@version

In the SSC article Mani Singh posted in the first the scripts are very visible to me.

There are two things with this/

1) the trigger supposes it will be fired after completen an update for single @cbmarq. If you update a table out of that "regular" oltp...

doing that with any clr proc will be at least 95% overhead !!

e.g.

create trigger trIU_mytable

as

begin

insert into myaudit_table

select 'I' as operation, *

from inserted

union all

select 'U' as operation

, *

from deleted

end

Doing...

Great article Gail.

I'll add it to my forum signature :w00t:

mick miller (6/19/2009)

---

Johan wrote:

: What happens if you execute that statement separately ?

: (is the error persistent ?)

When I run the query directly on the server, then I don't...

First of all thank you for posting these mishaps and the work around.

We didn't encounter these problems when upgrading from sp2 cu2 to SP3 on our 2-node sql-cluster (multiple instances)....

I haven't encountered that kind of errormessage yet.

BOL nor KB contain an exact ref.

What happens if you execute that statement separately ?

(is the error persistent ?)

Sorry for the alte response, I lost track of this thread :blush:

- In what way does your SRVDW(dom\sadb) differ from your other servers ?

- Are these databases in a lower...

Dean Jones (6/18/2009)

---

...

Sounds like a good idea, problem is that this means I will have to change 200 or so Procedures and I dont think this will get the seal...

that depends on your needs !

Do you need an aircraft or a T-bone steak ?

- I haven't seen a grant exec to a certificate. :unsure:

- if you drop a proc, all related grants also vanish !

What you might do is :

1) create a db...

We grant the exec to a db-role and add users in that db-role.

IMO you need to investigate why the proc needs to be re-created ?

If it already exists, just...

If the disk on which the data file resides is very busy, SQLserver may get a timeout on the extend operation.

It then raises this error.

In the background the OS is...

AFAIK All MC** stuff, you have to pass the required exams.

MVP is kind of an award MS grants you for a certain period and target area as a token of...