Not really.

I was almost clueless 😀

Can you please help me if you can

I also see stack dumps getting generated.

Am planning to engage MS to decipher the stack dump.

Makes sense?

Same database had got corrupted a fortnight back and dbcc checkdb(‘DB-NAME’,REPAIR_ALLOW_DATA_LOSS) did fix the inconsistencies.

I also see a stack dump which has got generated in SQL Server error logs.

GilaMonster (8/26/2013)

---

Firstly why did you repair rather than restoring a clean backup? Repair is typically the last resort, not the first solution.

Do you know how much data was lost?

Do...

repair_rebuild didn't fix any errors.

what must be the next step?

No issues with the account permissions though.

I will find out if the object exists

Thanks Robert. It did work.

can someone help me with this?

I could not run a database consistency check on this database. I had to do the following things to recover the database:

1. Put the database in single user mode with...

I dont need to know the procedure to create Linked Server. However, I know it.

I would want to let a user create linked server on his own. Does he need...

Can I get some help please

Thanks.

Hi,

My SQL Instance is already there on the cluster. i would want to make the SSRS use that instance to...

This is what I have thought to go ahead with:

1. Install SSRS seperately on all 3 nodes of the cluster.

2. Put the databases on one of the instances.

Is there a...

Steveyam90 (8/6/2013)

---

Install SSRS on each node, Add the other nodes into ssrs through the scale out deployment tab on each server and initialize it. Without doing it i cant remember...