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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-24 : 08:40:04
|
| AnandKumar writes "I used to delete a table which contains one crore records (i could not use 'drop table' command because i used delete command in such a position). But system can not do the deletion transaction due to the shortage of trasaction memory. Transaction log occupies the space around 5.5 gb. I can not do even open sql Enterprise manager to stop the service. when i used 'sp_detach_db' to drop the log file, i can not. HOw do i remove the log file and continue the above operation.Please guide methanking youwith loveanand" |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-01-24 : 08:59:55
|
| can you use sp_detach_db to detach the data file ? Then delete the log file. then use sp_attach_db to reattach the data file. This will create a new default sized transaction log.There are also some shrink_db and shrinkfile commands you may want to investigate.===========Paul |
 |
|
|
|
|
|
transaction log