how to shrink the log file of a sql server 2000 database with a full recovery model? [modified]
-
hi all,,, i have a database with a large log file database and i don't know how to do to make it smaller,,, the file have a large area space what can i do? thanks in advance,,,
modified on Saturday, March 21, 2009 4:55 PM
You can shrink the logfile on demand. There's help on how to do that from the Management Studio here[^], or if you want to do this from SQL, look here[^]. That will only help until the file fills up again, or you'll have to hunt down the reason why the logfile is filling up. The documentation on the transaction log can be found here[^]. Good luck :)
I are troll :)
-
You can shrink the logfile on demand. There's help on how to do that from the Management Studio here[^], or if you want to do this from SQL, look here[^]. That will only help until the file fills up again, or you'll have to hunt down the reason why the logfile is filling up. The documentation on the transaction log can be found here[^]. Good luck :)
I are troll :)