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 |
|
albertkohl
Aged Yak Warrior
740 Posts |
 Posted - 2005-09-18 : 20:51:07
|
| okay, so i have a huge database (about 119 million names 79 fields deep) and i want to index a bunch of fields. after importing, and indexing a few fields, my dtabase.log file is 250 gigs OUCH!!! is there a way i can clear that out? i dont realy need to back it up unless it's nessessary. any help would be great... |
|
|
scullee
Posting Yak Master
103 Posts |
Posted - 2005-09-18 : 21:03:47
|
| BACKUP LOG { database_name } { WITH TRUNCATE_ONLY } |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-19 : 02:15:09
|
| You'll probably want to SHRINK it after you've done the "Truncate Only" backupKristen |
|
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2005-09-19 : 13:57:52
|
| when i try that command i get:[Microsoft][ODBC SQL Server Driver]Syntax error or access violationi'm the only one connected to the server, so it couldnt be anyone else. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-19 : 13:59:14
|
| "when i try that command"What's the exact syntax you are using?Kristen |
|
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2005-09-19 : 17:04:32
|
| BACKUP LOG { residential } { WITH TRUNCATE_ONLY }[Microsoft][ODBC SQL Server Driver]Syntax error or access violation |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-19 : 17:06:26
|
| BACKUP LOG residential WITH TRUNCATE_ONLYTara |
|
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2005-09-19 : 17:22:45
|
| Perfect, thank you |
|
|
|
|
|
|
transaction Log