our c drive almost full during local client copy

Dear experts

Kindly suggest something on this we are doing local client copy we are on MSSQL database before C:\drive have 100GB space now it has only 10 mb space now we are not able to logged in also it show ECC as 210 gb and ECC_LOG show 220 gb it can not be open also now i shutdown the system and stop MMC also now suggest what is reason which files we need to delete for making space available C:\

which are the log we need to delete kindly give some inputs to proceed further

Regards

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Hi Rajendra,

What has been installed on C:\drive ?

Regards,

Deepak Kori

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Dear

we have dual system BI BO ECC6.0

bi on oracle

ECC on mssql

we have done local client copy it should be the reason kindly suggest

Regards

We understand the reply, but was installed on the C:\ drive? Do you have SQL server logs stored there, for example? If so, can you dump the log file and shrink the Log to give you some space?

What other log files are stored on c:\ ?

Regards,

Graham

Hi Rajendra,

Please share drive structure along with components installed on the server you are facing issue


For eg:
c:\drive ( OS)
D:\drive (SAP )
E:\drive ( DB + logs)

Regards,

Deepak Kori

Dear

How to shrink the log files in c:\

i would like to offline backup for the same can you give some steps for the same

i am new to MSSQL database

Suggest some valuable information

Regards

Dear

now we have increase the space of c:\ to 143 gb free space we move space from d: to c: it is an emergency requirement to us previously c:\have only 20mb free nobosy abel to logged in also

i will send you the screen shot

These are the installed component in C:\

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA

ECC and ECClog file those are of more then 200 gb 220 gb

tell me bcaz we did client copy if i delete the client then my space get back to me

there are some log which we need to delete

Kindly give us valuable suggestion

Hi Rajendra,

You can shrink the log files as explained in the link below

http://blog.sqlauthority.com/2006/12/30/sql-server-shrinking-truncate-log-file-log-full/

Shrinking of log will save some space for you.

Alternative - you may schedule regular DB and log backup on another drive so that log space is released post backup.

Hope this helps.

Regards,

Deepak Kori

Dear

I am new to this database suggest me how to take db backup and log backup and after backup which log we need to delete if you have some links or steps

Kindly suggest

Thanks in advance

Regards

Hi Rajendra,

Please use this link to understand on how to start backups on MSSQL.

How to Backup a Database using Management Studio

Regards,

Deepak Kori

Dear

Thanks for valuable inputs today night i will take backup i will let u know the result once its done

Regards

Dear

we have to install management studio separately are it is come with default installation MSSQL

Bcaz last night i searched for management studio on my desktop but not succeed

but in oracle as we use brtools for all database activities mssql is there is any such tool

Kindly give some suggestion regarding management studio

Regards

Hi Raj,

Please check in Start -> All Programs -> Microsoft SQL server on the SAP sever where MSSQL database is installed.

Regards,

Deepak Kori

Dear

I have checked as you suggested i got sql server management studio in the following path start -> all program -->mssql server 2008 r2 now i open management studio

now we can take backup of sap and database

kindly suggest valuable inputs so i can process further

Regards

Hi Raj,

Could you initiate DB and log backup and check whether log area is getting released post backup.

Regards,

Deepak Kori

Dear

i took backup as u suggested and it is successful but then how to release the log area which is getting full i took back up from management studio

Regards

Hi Raj,

Please shrink the log area once the backup is done.

Regards,

Deepak Kori

Dear

after backup i tried to shrink whole database it through error which will reduce the space but as you said i have to shrink the log area only there are two files in it called as ECC ECC_log which one i have to shrink let me know

let me know the path which folder i have to shrink today i am going to do that activity

Regards

Ask a Question