yes . I am able to

????

The query has been executed for that particular database only .

Please help if something can be done from my side.

Thanks

select log_reuse_wait_desc from sys.databases

Result :

log_reuse_wait_desc

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

NOTHING

NOTHING

NOTHING

CHECKPOINT

LOG_BACKUP

(5 row(s) affected)

Yes , There are some scheduled batch jobs runnings in the background which has resulted in large growth of transactions .

Also , when i take the log backup with truncate...

1. "The Sql Server Analysis Services (MSSQLSERVER) service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs...

@scott : +1 --

But, i am not seeing any results though commands have been completed sucessfully .

PS.- i have many indexes for this database

Try login into the ssms using admin account (admin:instance name ) while connecting to the database engine ..It may help ....\m/

@ninja - Thanks for the query ..

I need to estimate the figure ( capturing the growth of the data files of the db ) so that the client...

Hi Ninja - Please share those scripts .TIA 🙂

@All- I got some free space available in other drives which now contain data files with the same name as of...

So, are you advising me to go for data compression ?? If yes , steps please 🙂

p.s.- i am using enterprise edition

Thanks Ninja

\m/

Most of the databases size is showing 0.00 GB whereas my database size is definitely not 0 GB 🙁

Hi Coach,

Thanks .

It is providing me the size of the database when the full backup was last taken

Of use , to some extent -Thanks 🙂

Thanks for the info .

I dont know much what to do about that , i am still open for a simpler solution .

Thanks , anyways .

🙂

I have multiple data / log files for my prod server .

I tried running this script for my base machine but it is giving me no results .