I have a database which is 200 GB in size and I have scheduled a Rebuild Index maintenance plan for all databases every Saturday at 2:00 AM.
The job ran for 8 hours and then it failed. I knew while the rebuild operation was in progress, that the database data file size increases.
In my case, the database size got stuck at 655 GB and the rebuild job failed. I have verified the database data file free space which is currently showing 1.5 GB free space.
Can you please help me to reduce the data file size to the previous state? (200+ GB)