Since File/Database/Expand is replaced with File/Database/Alter… When I select Alter, I get an ODBC error… Database is invalid or cannot be accessed. State ID: HY024 What is the correct process here? ?
Well, normally you don’t need to expand a SQL database; it expands by itself (dynamically).
But only in situations, you have only one DB file… if you have more files, please, expand them manually, because autogrow change size only for one file… Check, if your account is DB_Owner on the MS SQL…
Also - if you have Autogrow on, the users will all of a sudden experience a huge slow-down in performance - that can take a while.