-
Hoping someone can help with scripting this...
Novice when it comes to SQL...
We have a number of databases we need to weekly shrink...yes, I know that more drive space would be the best thing, but that is not practical, at this time...
we do a query on each db as such..
DUMP TRAN (db) With NO_LOG (yes, I know...we back them up nightly)
dbcc updateuseage (db)
after doing this for each db, we then run a shrink on each one...
What I would like to do is to somehow script this activity, to run easily and not so tediously...
Can anyone help?
Thanks!
-
Auto shrink option doesn't work?
-
auto shrink?
Again, a newbie...can you explain how to auto shrink?
-
When the AUTO_SHRINK option has been set to ON, the Database Engine automatically shrinks databases that have free space.
AUTO_SHRINK ON | OFF
If ON is specified, the database files are candidates for automatic periodic shrinking.
-
You can set that by right click the db in enterprise manager and go to properties -> options tab, check auto shrink.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|