Gazareth (9/8/2016)

---

Ah well, there may be someone along soon with a better answer, even from the Redgate side - there's plenty of Redgate people around here!

Full snapshots that frequently are...

Thanks for reply.

Yes, I'm afraid there...

Gazareth (9/8/2016)

---

Try trace flag 3226 https://msdn.microsoft.com/en-us/library/ms188396.aspx

Although I'm not sure if it works for third party backups.

Don't think you can stop entries going into msdb tables, but they can be purged...

John Mitchell-245523 (7/22/2016)

---

But you said in your original post

Are you now saying it exists on all servers? If it does, try setting up...

John Mitchell-245523 (7/22/2016)

---

Surely your stored procedure is attempting to execute sqlbackup at the remote server? I'm guessing that the domain group in question has permissions on it on server1...

Brandie Tarvin (7/22/2016)

---

I have a T-SQL job backing up databases to a snapvault-mirrored NAS share. What snapvault means is we can write to the NAS share, but we cannot delete...

How this can be possible?

I ran this TSQL script ...

SELECT o.name AS 'Object', u.name AS 'User_or_Role', dp.state_desc, dp.permission_name

FROM sys.database_permissions AS dp

JOIN sys.objects AS o

...

This is driving me insane...

Still getting this error:

Msg 229, Level 14, State 5, Procedure sqlbackup, Line 3

The EXECUTE permission was denied on the object 'sqlbackup', database 'master', schema 'dbo'.

There is...

Wow

I am testing the logic only with a smaller client which same table but its only 30GB of size (whole database is about 90 GB) . The CREATE INDEX statement...

It won't happen soon, we are still testing, but...

With the 2nd method...

Jeff Moden (7/20/2016)

---

sql-lover (7/20/2016)

---

GilaMonster (7/20/2016)

---

sql-lover (7/20/2016)

---

Does above command will still apply if the new cluster index is different than the original one? Let's say... existing Index is on col1,...

GilaMonster (7/20/2016)

---

sql-lover (7/20/2016)

---

Does above command will still apply if the new cluster index is different than the original one? Let's say... existing Index is on col1, col2. New one...

GilaMonster (7/20/2016)

---

CREATE CLUSTERED INDEX ...

WITH (DROP_EXISTING = ON)

will probably be the least disruptive, but the log impact will not be small (estimate 2x the size of the data), you'll need...

I have all the space ll I need. Expandable LUNs from a new SAN we bought. I'm not worried about space, space is not a problem. I am trying to...