database maintenance

L

lmo

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?
 
L

Luther

we are sharing a bcm database with 50 users.  when we look at the pc ofthe
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 bestway
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top