Script(s)

what I learn is what u c

Deleting LOG Files in SQL 2000

with one comment

How to effectively delete Log files in SQL 2000 ?

* Backup DB (just in case something goes wrong)

* Enterprise manager >> DBName [Rightclick] >> Options >> Single User Mode
(If it complains others are using the DB, open Query Analyzer and sp_who and kill those Process ids)

* Enterprise manager >> DBName [Rightclick] >> Detatch Database

* Goto Physical Location (dbname_log.ldf) rename that file

* Enterprise manager (top level) >> Databases >> Attach Database
(specify the MDF name and DB name and owner – sa)

* Make sure DB works now.

* Delete the renamed .ldf file.

Advertisements

Written by gchandra

November 1, 2004 at 10:30 am

Posted in Database

One Response

Subscribe to comments with RSS.

  1. This is not microsoft’s recommended method of reducing your log file size.

    sam g

    February 5, 2008 at 3:55 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: