i performed a "DATA_COMPESSION" with PAGE level on my DB and i took a full backup with compressed before.
after the process finished, i took a full backup again(with compressed) and the size of the backup grown.( opposite result than I had hoped.)
ALTER INDEX [IX_INDEX_NAME] ON [dbo].[tableName] REBUILD WITH (DATA_COMPRESSION = PAGE); on INDEX
and ALTER TABLE [dbo].[TableName] REBUILD WITH (DATA_COMPESSION = PAGE); on table.
please Advise me what i'm doing wrong.