Thanks. I figured this out. I''m a db owner and cannot belong to both.

J.

Thanks grant. Food for thought all right.

Cheers,

J.

Thank you Grant - I found what I'm looking for. I notice that there is a verify only option to restore.

RESTORE VERIFYONLY FROM DISK=blah

Worth considering from my pov.

Thanks,

J.

Thank you Orlando - probably ignorance on my part (to answer your question).

I'm calling this from inside a maintence plan package. I will refactor and see if it works....

Hi, thanks for that. Actually I found that this works a treat for me in my env:

set @SqlCmd = 'powershell.exe Robocopy C:\share\testSource \"c:\share\test Destination\" *.bak /S'

Cheers & thanks,

J.

Thanks John for your comments. I got this sorted with this article:

https://www.mssqltips.com/sqlservertip/1618/using-the-forfiles-command-to-delete-sql-server-backups/

Thanks John - the problem is that the "filenameA.bak" changes name (there is a timestamp appended to it). I need some way to reference it. Can you help?

C:\exes\EncryptBackup.exe C:\DBBackup\FolderA Encypt...

Nice Lowell. Works like a charm.

Thank you.

Hi everyone,

Thanks for all the comments. The following script appears to work for my needs:

use DBName

select * from sys.synonyms

where base_object_name LIKE '%SearchString%'

Ideally, I would like the ability...

Hi,

Yes SQL Search is free, indexes fast and is easy to use but does not detects string in the synonyms 🙁

Thanks John,

I'm trying:

Use DBName

SELECT *

FROM sys.sql_modules

WHERE definition LIKE '%searchstring%'

but its not finding the string! I can see the string in question inside the synonym. What am I doing...

We got a solution. We set the relevant database to "TRUSTWORTHY" - the certs then started to work properly. I'm just investigating now if there are any negative ramifications of...

Thanks for the advice. We thought as much. Genuinely - we are having problems with the certificates on out new 2014 box. Here is some detail of the problem:

Background: We...

Thanks. I take it there fore I can update to SP1...??

Ok - thanks for the suggestions. I'm nearly sure we are using standard and are up-to-date with updates. Anyone else out there with anything to offer? Any suggestions.....