Thanks to all. More clear now.

If you look at it in the regard that a heap is index type of 0, then you could make the argument that the heap...

Analysed and Issue resolved by scheduling Log backup at proper intereval.

Client applications is doing that much huge transactions.

So frequent log backups are essential.

Thanks to all the valuable inputs.

I did that and everything got imported and new solution is created.

I am facing another problwm now, when I open CUBE I get the following error.

"The DDS Layout contains an...

Thank you soo much.

May be I was searching with diff keywords.

Thanks again. Hope I can make a copy of the cube and mofiy the way I want without modifying...

I opened BIDS.

File ==> Open ==> Analysis Service Database.

Selected the database I wanted.

Think I can edit the cube. Did I do it right ?

Is there any other way to do...

Fine. I will try to get the cubes and modify it as well.

I don't know if am on right direction. But I got to do it somehow.

Thanks again. You realy...

That's OK with me. Since I am new to this, it's better copy somewhere and play with it.

Well, I opened the project without any pbm. Now in the "Data" tab,...

Yes, it's on the remote server.

I downloaded the "rsscripter" you mentioned and took the project and datasource files for few reports. Copied and opened in local server. Checking now...

I found...

anthony.green (3/6/2012)

---

easiest option would be to get your ssrs admins to give you report builder access that way you can modify them direct on the server.

if that's not an option...

anthony.green (3/6/2012)

---

did you open the report in report builder which is the bottom option when you use the drop down menu when you hover over the report item?

or did you...

Thanks.

What I did was, right clicked on repot name and Edited.

It asked for the location to save and saved it.

I opened it in studio and icnluded this .RDL file...

Ok.. Thanks a lot Gila.

I inserted some sample recs in my test DB and just tried to open and see. 🙂

Can't make anything out of it. :w00t:

Thanks again.

Think that's what happening in this case.

look at what those procedures are doing,...

@Gianluca Sartori

Thank you so much !. That part is clear, Scripts are awesome.

But still I dont know what exaclt is stored in Log.

Gila, I notice that my log...

Jack Corbett (2/10/2012)

---

Okay so there are no scheduled jobs on that server. Is there an SSIS package or something else on another server that is doing a...