Nope  There is no way to automatically have compression apply to all tables or indexes in a db. but If the database is not in Simple Recovery mode, then you...

• This reply was modified 3 years, 3 months ago by  Dunne15.