(Msg. 1) Posted: Tue Aug 05, 2008 2:11 pm
Post subject: database maintenance Add to elertz Archived from groups: microsoft>public>outlook>bcm (more info?)
we are sharing a bcm database with 50 users. when we look at the pc of the
users, the local copy of the file grows to 1+GB. If we use dbcc shrinkfile
on the local user's pc, the size goes to about 200MB. What is the best way
to automate dbcc shrinkfile on each user's computer? vbs script, sqlcmd?
does anyone have a sample?
(Msg. 2) Posted: Wed Aug 06, 2008 5:32 pm
Post subject: Re: database maintenance Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Aug 5, 2:11 pm, lmo <l... RemoveThis @discussions.microsoft.com> wrote:
> we are sharing a bcm database with 50 users. when we look at the pc of the
> users, the local copy of the file grows to 1+GB. If we use dbcc shrinkfile
> on the local user's pc, the size goes to about 200MB. What is the best way
> to automate dbcc shrinkfile on each user's computer? vbs script, sqlcmd?
> does anyone have a sample?
You could look into the Scheduled Tasks applet in Control Panel. Have
it run sqlcmd.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office