Hello there

On every week by Enterprise manager i:
1. Detatch the database
2. delete the log file
3. reattaching it again

I would like to do this by code.

Is there a way to do that?

Roy Goldhammer wrote:

Yes. Don't. Regularly detaching and deleting the log in an operational
system is certainly foolish, unnecessary and/or dangerous.

Firstly, set the correct recovery model - that means "Simple Recovery"
if you don't require log backups. Secondly, ensure you implement the
right tran log backups if you do need them. Finally, set the log file
to the right size, turn off autogrow and LEAVE IT ALONE.

More info:

http://support.microsoft.com/?id=110139
http://support.microsoft.com/?id=317375
http://support.microsoft.com/?id=315512
http://www.karaszi.com/SQLServer/info_dont_shrink.asp

Hi

Why?
What you are doing is unsupported and very dangerous. In some cases, you
will not be able to re-attach the database again and kiss your DB goodbye.

Rather put your database into the appropriate recovery mode, and backup the
log if it is not in simple mode.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: m***@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

Show quoteHide quote

I agree with David and Mike.  Don't do this.  It will bite you in the
backside.

Show quoteHide quote

No Of Months - Function
IIF Statement
DECLARE CURSOR intermittently failing
How do I pass a second parameter to user-defined aggregate (SQL 20
Custom number format