The table has 15000 rows only.I observed 60% indexes fragmentation.
We are deleting approximately 12000 rows daily  and inserting updated data again into the table.

I rebuild indexes using script.

Hi,

2 option  suitable to my requirement.
We have auto increment column in the Orginal table it might become issue while moving data to back.

Thanks
Krishna.

Here,Database recovery model is full.

Is there any chance to improve performance , if we put recovery model as simple.

Free space on disk is 400GB.

Thanks...

Yes, We are executing a delete command on a table which contains nearly 4 core records.

Thanks & Regards
Krishna.

I am fresher to SQL server, Could you please let me know how to check permissions.

Thanks & Regards
Krishna.

BACKUP DATABASE ABC_123 TO DISK = '\\WIN-94EATCLRNI5\Backup\ABC_123.bak';

Msg 3201, Level 16, State 1, Line 13
Cannot open backup device '\\WIN-94EATCLRNI5\Backup\ABC_123.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level...