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 |
|
hasanali00
Posting Yak Master
207 Posts |
 Posted - 2005-07-05 : 11:42:10
|
| How can I clear transaction log from my hosted sql server.I have read this article, but i think it gives solution for sql server running on local machines;http://www.nigelrivett.net/TransactionLogFileGrows_1.html |
|
|
hasanali00
Posting Yak Master
207 Posts |
Posted - 2005-07-05 : 11:51:09
|
| just ran DUMP TRANSACTION yourdatabase WITH NO_log seems to be working now.But in future, whats the best practice to backup and clear logs?regards |
 |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-05 : 12:27:59
|
| you need to do regular backups of your transaction log (and your database). backing up the t-log truncates it for you and doing this helps you recover your database to the point of failure.please reading the entirety of "backing up and restroing databases" under the "administering sql server" section of SQL Server Books Online immediately.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me though the forum. |
|
|
|
|
|
|
Clear Transaction log from Hosted Server