i am and you're welcome.

if you rememeber, i gave the 2nd option with the 'echo' statement so you could see what files would be deleted.

i thought it might help you if you could see...

if you are concerned about what the command will do ( i understand, you don't know me from Adam )

just make one small change.

exec master.sys.xp_cmdshell 'PushD "\\YOUR\UNC\PATH" &&("forfiles.exe" /S /M...

this is more than likely a DNS issue.

trouble shoot by using ping or nslookup on the witness and make sure they both resolve.

/S means it will instructs the forfiles command to search into subdirectories recursively.

there are limitations with DB mirroring that you have to be aware of before you get started down that road.

1. DB mirroring is NOT application agnostic. (meaning the application must...

from what little I have read on the ReFS in Server 8, it appeared to that SQL databases will still reside on NTFS partitions.

maintenance plans for deletes when you backup to a network share are cumbersome.

just use the script below and it will take the entire share and delete log file backups older...

exec master.sys.xp_cmdshell 'PushD "\\YOUR\UNC\PATH" &&("forfiles.exe" /S /M "*.trn" /d -7 /c "cmd /c del @file") & PopD'

GO

remember it only works when you connect to a SQL 2008 or greater instance.

that sounds like you are connecting to the Database Engine.

Connect to Reporting Services instead.

does the SQL Server Agent Service also run as your domain user?

Look at you Mail Session properties to make sure it is active.

SQL Server Management Studio --> Connect to the SQL Instance in question.

Right Click on the SQL Server Agent. Click...

btw, there is also a difference between using http://localhost/ blah vs http://127.0.0.1/blah

try using localhost.

verify that your roles are properly set.

start up SSMS and connect to the SSRS instance.

Under Security --> System Roles, verify that the System Administrator has the proper settings.

Under Roles, verify...