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!