Thank you so much. That is exactly what I wanted.

Thank you both for getting back to me.

SQLRNNR, what version of Avamar are you running and have you contacted EMC with this issue? If so, what was their response.

Steve,...

Steve Jones - SSC Editor (2/4/2013)

---

I haven't used Avamar, but if the log file is growing, either you have a growing workload that needs more log space, or the log...

Hi

Thank you that was very helpfull,

Using Expression in SSRS, how can I select Min and MAX dates?

In other words, is it possible to do the below SQL queiry in...

Gila you are the best!!! It worked. Thank you so much!

By the way I went thourh the steps and i'm getting the error message below when I run the scrip below

CREATE CLUSTERED INDEX X1_ACTION ON ACTION (PERSONID, ACTIONSTATUSDT, ACTIONSTATUSID,...

GilaMonster (8/29/2012)

---

You're not trying to add a filegroup (FG4 already exists).

You're not trying to add an existing file to that new filegroup. As I already said, you cannot move files...

I tried the script below, but I get the error message below.

ALTER DATABASE TestDB

ADD FILEGROUP FG4;

ALTER DATABASE TestDB

ADD FILE

(

NAME = FG4,

FILENAME = 'C:\TestDB\dbfile4.ndf',

SIZE = 2000,

FILEGROWTH = 10%

)

TO...

Hi Gila,

I have been trying to do this, but unsuccessful. Is there any example scripts you can share?

Thanks

GilaMonster (8/21/2012)

---

No. You'll have to create a new file in a new filegroup, then shrink the one you want to remove with the EMPTYFILE option and then drop it. The...

This a duplicate and can be deleted.