as an alternative and easy solution  :    create readable snapshots based...

another thing to check :

select * from sys.configurations where name = 'backup compression default'

Hi Theo!

Thanks for your perfect solution. Couple of years ago it helped me and inspired to create SSRS report with similar functionality.

Also, it is possible to run it as Custom...

Try the following to see if it shows anything:

=IIF(Globals!ReportServerUrl=Nothing,

"/Images/SSRS_DDWA_Logo_Stacked_Green.png",

"/Images/SSRS_DDWA_Logo_Stacked_Green.png"

)

If it doesn't , remove "IIF" and hardcode the "/Images/SSRS_DDWA_Logo_Stacked_Green.png".

Simple step-by-step debugging either from top to bottom or contrariwise.

• This reply was modified 5 years, 7 months ago by  Andrey.

Jasona, you're welcome.

Also, perhaps you find it useful - SSRS report which shows activity of a SSRS server (usage of reports).

https://github.com/ASamykin/PerformanceReports/blob/master/Report%20Project1/SSRS_overview.rdl

Right now, I've got my SSRS instances sitting on the same servers as the databases they service.  There's some things that might be related to this (first time in...

Preview mode  uses cached data (in the same folder with report files but with .data extension)

Four ways to address the "issue"

1) refresh the page (doesn't help much),

2) delete appropriate .data...

hi

NTLM will be used for local connections via shared memory

KERBEROS is for  TCP connections

at least I haven't seen the opposite for years

check:

select net_transport,auth_scheme,count(1) [sessions]
from sys.dm_exec_connections
group by net_transport,auth_scheme

I could find , one of the table is having million of records and when we tried to open index fragmentation for same table sql server is not responding...

Arooj, hi

I'm pretty sure that this finding doesn't relate...

Thanks for your response Sue, But my major question was to DBAs not about using tools. The major question was, does anybody using Transparent Data Encryption in SQL Server...

Arooj,

if your tempdb files are configured to autogrow and...

Agree with Jeff - it's not worth to change db owner to SA automatically.

It may affect ex-owner to lose access to the database.

Ex-owner should be created in the database...