all site management is performed through Reporting Services Configuration manager. You'll need to setup appropriate dns entries and then apply the host header values on the virtual directory config in...

Pointless in my opinion, remove it before it fills up too much and then gets cemented in...

plamannkathy (12/8/2014)

---

Hi All

I have tried doing sql server backups to a file share and that has been taking too long. So I've decided to backup locally and then taking those...

on the SSRS instance properties you will need to enable host headers resolution.

IIS does not and indeed should not be used to manage SSRS instances, the configuration settings are...

There's just no helping some people!!

Conor Lillis (12/5/2014)

---

SQL to check all DBs for the file. Replace the appropriate segment below with your full file path

sp_msforeachdb '

--if (''[?]'' not in (''[master]'',''[model]'',''[tempdb]'',''[msdb]'',''[reportserver]'',''[ReportServerTempDB]''))

BEGIN

use [?] ;

--print ''Working on [?]''

select...

Why, what made you think this is even...

When you create the view on the primary its mirrored to any secondarys just as it would in database mirroring and log shipping.

Grant Fritchey (12/5/2014)

---

Perry Whittle (12/5/2014)

---

ian_massey (12/5/2014)

---

Thank you for the LSN explanation re the proprietary software - that makes sense to me.

But I don't have any access to the...

Try this

use MSDB

GO

SELECT bs.database_name

, bs.recovery_model

...

ian_massey (12/5/2014)

---

One question I do have : is it possible to find the actual Type of backup performed within SSMS.

CASE msdb..backupset.type

WHEN 'D'...

ian_massey (12/5/2014)

---

Thank you for the LSN explanation re the proprietary software - that makes sense to me.

But I don't have any access to the log file backups, the...

Nope, they're LSN based and are based on the last log backup hence the log...

temporarily add a new t-log file...

can you post details from the sql error log