i deleted one r 2 tables in prod db , before of deleting tables, i checked size of .mdf is 37 gb and .ldf is 12 gb.
once deletion opetion completed , again i checked my files sizs now .mdf is 40 gb and .ldf is 19 gb
i don't know what happen here but my db priorities is
1. my DB recovery model iss full
2. i am taking full and diff backup daily evry 3 hrs diff backup and night full backup
3.In drive aslo huge free space is there
4..mdf file auto growth is 1 mb and .ldf auto growth is 10%
5. every day full backup size is 36 gb
Please help me any one...
i am not able finding hw its incrage .MDF file size...
please suggest me hw can i delete table in future in my db , tel me any procedure ? next aslo same .mdf file size is incraged mean i am cick off my bucket
Please adive me all blog viwers
View Complete Post