The first is to truncate the logs using the SQL server's Enterprise Manager. The second is that when you do a full backup, it should clear the logs for you. Neither of these will shrink the physical ...

BANGALORE, INDIA: Developers and DBAs using Microsoft SQL Server always look for ways to log events of interest to them as they occur on the server. SQL Server '08 fulfills this need with the ...

SQL Server 2008 has some great new features. One of them is the new auditing capability. Now we can audit at the server, database and table level according to specifications provided by the DBA. We ...

Transaction logs are a vital yet often overlooked component of database architecture. They are often forgotten because they are not something actively maintained like the schema contained within a ...