Tech Novice
asked on
Database backup size is huge whereas there are only 10k records in all the tables.
Hi,
This database was taken of a different application which we are using now by cleaning it
Database size after backup is around 10GB whereas only 3-4 tables are having records around 10,000 only.Unable to understand why is so huge,
Please help in sharing what could be the possible reasons.
Thanks
This database was taken of a different application which we are using now by cleaning it
Database size after backup is around 10GB whereas only 3-4 tables are having records around 10,000 only.Unable to understand why is so huge,
Please help in sharing what could be the possible reasons.
Thanks
Think of database as a box. If u take something out it will not shrink , instead allow more space to put new record. U can create new database of small size and import old database to see the difference.
ASKER
Shrink done but still no success,i need to understand why the space is being taken... can't possible as there are over 400 tables having some reference data (100-200) records..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
IS there any way out by which i can delete the transaction log...
Could you please share some link wherein i can get the significant information...
Could you please share some link wherein i can get the significant information...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It looks like you're taking a transaction log backup and not a full database backup.
But as stated by Nakul, you should start by creating a database backup plan to reduced the transaction log size.
But as stated by Nakul, you should start by creating a database backup plan to reduced the transaction log size.
ASKER
Better take a log backup and then shrink the log file
Tried with the same approach and through ssms shrinked the log file ,but there was only a little difference i found.
Is there any way in which i can reduce the log file size to 80%? if yes then pls share command to do it...
Tried with the same approach and through ssms shrinked the log file ,but there was only a little difference i found.
Is there any way in which i can reduce the log file size to 80%? if yes then pls share command to do it...
if you really want to find out what is the actual size of your db ...just create a new one and copy the tables from ome database to another...this should give you the clear idea...also remember that a database is not only data but slso keys indexrs etc
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks