Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
moose051
Starting Member
15 Posts |
 Posted - 2001-10-30 : 22:12:42
|
| Hi All,Can someone please tell me how to delete a secondary log file... I have tried what BOL says but either nothing happens or it errors out.By right clicking on database, choosing properties, then transaction log tab, then selecting the log that I want to delete and hitting delete nothing happens...By entering the following: use mastergoalter database [db name]remove file [log name]goI get the error that the log file is not empty... This is after truncating and backing up the database...Any ideas???Cheers... |
|
|
|
|
|
Deleting Log File