But I have configured the jobs through maintenance plans.

How do I make this change?

Thanks.

But what would happen if the scenario is like this:

There are 2 nodes NodeA and NodeB and there is one instance called Inst1

NodeA is active and NodeB is passive.

I install...

without scale-out deployment ,how does this work.

I mean, Can I install SSRS on just active node and deploy the report server database on the clustered instance?

Going by common sense, I...

Friends,

Can I please get some help on this?

I found an article which was talking almost similar to my requirement. Can this work out?

http://www.mssqltips.com/sqlservertip/2778/how-to-add-reporting-services-to-an-existing-sql-server-clustered-instance/

The clustered SQL setup is already there.

I just need to put a SSRS and put the report server database in clustered instance

Hi Jony,

I am not bothered if its cluster aware or not. All I need to do is make sure the report server DB sits on the clustered instance 😛

I managed to modify a script which will take backup with time frame.

--Full backup using datetime file name

DECLARE @devname varchar(256)

DECLARE @DirLocationPre varchar(256)

DECLARE @DatabaseName varchar(256)

SET @DirLocationPre = 'D:\DBName\'

SET @DatabaseName...

ALZDBA (10/2/2013)

---

some may consider the extra space a security feature :crazy:

Simplest way is to modify the job step command and remove the space.

If you cannot rename the database (which may...

friends,

any inputs on the above issue?

Heard this from application owner:

The dbs were not able to do any work because all temporary space was full. The resolution was to restart the server, releasing the temp space...

Thanks Gail.

Is there a query for the 2nd point?

Thanks for the update.

Is there an article I can read more about such cases?

oh ok. DB's are on SAN. I spoke to my SAN admin yesterday and he told me that he doesn't see any issues from SAN side. Typical answer from them...

Ok. Any major insights as such from the error messages

Please Find the error messages attached