SQL servers merge transactions
In vb.net windows application,i used sql server 2008 for database. For deployemnt and implementation process, we used currently the sql server is in the web.client have different locations and want to access application from any where. The problem is at some rural area the internet down time is high and user unable to do data [...]

Answer Question   |  December 20, 2010  8:04 AM
SQL Server 2008, SQL Server database, SQL Server synchronization, SQL Server transactions, SQL transaction logs

Is it safe to delete SQL Server Transaction Log?
In one point, I create two Transaction Log for a database, and now I want to delete the second Transaction Log in order to free more space. I just want to get ride of the second file. Is it safe to delete it? SQL Server allow me to do it from DATABASE PROPERTIES WINDOW, but [...]

Answer Question   |  November 18, 2010  11:59 PM
Delete Transaction Log, SQL 2005, SQL Server 2005, SQL Server logs, SQL Server transaction logs, SQL transaction logs, Windows Server 2003

SQL 2005 transaction logs
At what point should we truncate the transaction log

Answer Question   |  April 9, 2010  1:38 AM
sql 2005 Performance Issues, SQL Server 2005, SQL Server 2005 administration, SQL transaction logs

Truncating the transaction log for a SQL Server 2000 database
What is the best automated way to truncate the transaction log for a SQL Server 2000 database?

Answer Question   |  September 25, 2008  7:05 PM
SQL Server 2000, SQL Server database, SQL transaction logs

Questions about a SQL database with hourly transaction log backups
We have a SQL database with a full recovery model that backs up the database once a day, along with hourly backups for the transaction logs. However, we only have one transaction log backup file, and it is overwritten every time. Are transaction log backups cumulative, and if so, does that one file contain all [...]

Answer Question   |  September 23, 2008  4:50 PM
SQL, SQL Database, SQL Server backup, SQL transaction logs

Time out in VB.net when SQL transaciton log backup schedule changed to hourly
We have changed our back up schedule on transaction log from daily to every hour recently. Now my VB.net 2005 program start getting fail to read the table error (maybe caused by Timeout) during the time backup is executing. Is there anyway we can prevent this? Thank you, Paul Hsu

Answer Question   |  August 28, 2008  12:51 PM
SQL transaction logs, VB.NET, VB.NET 2005