maintenance plan shrink DB job fails

[maswien]

We have some jobs created by maintenence plan, one of the them is shrink the database on daily basis, it used to be work fine, but recently it fails, I don't know the reason.
Where can I get the error of the failure? Thanks

 

[mrdenny]

You would need to look at the log from the job.

What are you trying to accomplish by shrink the database daily?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[maswien]

Thanks denny,

since the database increase the size every day, so we want remove unused space to protect the database grow too fast, can you give me some advice on this issue?

 

[mrdenny]

The database only grows when the file is full. If you grow the file to have 100 Megs free and the file grows at the rate of 10 Megs per day, then the database won't grow for 10 days.

I'd remove the shrink command, and let the database grow as it needs to.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[Corran007]

if you are worried about it growing to fast, change the increments of the increase. be warned that by doing this will create a fragmented file. The only reason you really need to shrink a db file is if things are being delete from it on a large basis