hello every one,
I have a multiple databases (20-30) in a server, each db has more than 100 g space and too many tables. I have database backup script on schedule.
I wan to backup thoes db which are not change. I mean some db does not record effect. I try to find out db size using sp_spaceused i get the db size. But when i try to manualy enter a record in a single table and execute sp_spaceused, i don't see the different of db size. If i check table's row count i do.....but it is not possible to check all the table (each db has more than 50-60 table) and db.
Any body know how to find the different db size.....if that db has change only one record (insert/edit/del)