SQL server showing large in size

[former_member183788]

Dear Experts,

In sap DB12 the database size is showing 68GB, While taking manual backup it showing same size.

But in SQL server properties its showing 500GB in size.Please advice.

[luisdarui]

Hi Prathish,

Are you comparing the Backup size (which is not the same database size) from DB12 with the Database size in SSMS?

[former_member183788]

Dear Luis,

What you asked is right? am comparing like that.

[luisdarui]

You can get the information about your database size in DBAcockpit. The backup should be something roundly the Total Data Size (MB) - Data Free Space (MB).

See the following example:

Of course you shouldn't be attached to it. If you want to test and ensure your backups are fine, you should restore it to another hardware, perform a DBCC CHECKDB with no_infomsgs,

[Sriram2009]

Hi Philip

You can check in the transaction code ST04, first page you can find the Database disk space, find the data & log file size or attach the snapshot

Regards

SS

[former_member183788]

Dear Sriram,

Below the screen shot.

[Sriram2009]

Hi Philip

Your total database size  80 GB, Kindly check the "Database Disk Space" area in MS Sql DB,

Refer the snapshot with highlight

Regards

SS