Client Import -- low disk space error

[Former Member]

Hi experts,

i am using SQL server 2005 on wix 2003 64 bit.

I was doing client copy using SCC8 from Prod to Dev Server, total size of request file is 5 GB, while Importing request thru STMS, import stopped due to low space for log file in Development server.

Is there any way to stop the logs while importing a client . Suggest the way out.

thanks in advance

Akshit sharma

[Former Member · Accepted solution]

> Is there any way to stop the logs while importing a client . Suggest the way out.

You can put the database in 'SIMPLE' mode to stop logging during an heavy activity.

If you want to 'continue' with the 'logging' then you need to take backup frequently to prevent low space for log file problem. Execute the transactional log backup with more frequency during the long and heavy activity.

Read -

http://yoshilounge.wordpress.com/2008/12/05/stop-the-transaction-log-of-a-sql-server-from-growing-un...

http://msmvps.com/blogs/vstsblog/archive/2009/08/09/stop-sql-server-transaction-log-ldf-files-from-g...

Thanks

[Former Member · Accepted solution]

Thanks the problem is solved