removing old log file

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

i want to remove an old log file which i forgot to rename while attaching the database.Now the db contains 2 log files one in primary group and one log file that i have created.I dont know how to remove the old log file as it occupies large space in hdd.

-- Anonymous, July 09, 2004

Answers

Ganesh,

This if from the SQL Server Books Online:

How to delete data or log files from a database (Enterprise Manager)

To delete data or log files from a database

1. Expand a server group, and then expand a server.

2. Expand Databases, right-click the database from which to delete the data or log files, and then click Properties.

3. To delete data files, click the General tab. To delete log files, click the Transaction Log tab.

4. In the File name column, click the arrow next to the name of the file to delete, and then press the DELETE key. A cross will appear next to the file name indicating that the file will be deleted.

Note Files can be deleted only if they are empty. Remove all objects on the files and shrink the database before deleting files from the database.

See Also

Adding and Deleting Data and Log Files

Hope this helps,

Eric

-- Anonymous, July 12, 2004


Moderation questions? read the FAQ