Moreover, is there any way to recover Reserved space from SQL Server (except DBCC SHRINKFILE). Please see below tables which are top contributers of un-used/reserved space.

Table Name# Records Reserved (KB)Data...

Hi,

Thanks for your reply. Please find stats for dbcc sqlperf(logspace)

Database Name Log Size (MB) Log Space Used (%) Status

--------------------- ------------- ------------------ -----------

Manager...

yes, public role is there in database role.

Second problem is that whenever I try to create a new login on sql server, it is not showing "Public" role in...