Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

Idera, a provider of Microsoft SQL Server management and administration tools, has announced the latest version of its SQL Server backup and recovery solutions: SQL safe 6.4, SQL safe lite 6.4 and SQL ...

For as long as I can remember, I have always configured the computers within my own organization to store data on network servers as opposed to the data being stored on workstations. That way, if one ...

eWeek content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More A backup and recovery strategy should address both data ...

Do you have a BackupExec SQL Agent CAL?<BR><BR>You can't (well, shouldn't) back up the MDF/LDF files directly. If you have the CAL, BackupExec will use VSS to do a snapshot and backup a consistent ...

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

I have a database on SQL Server 2000 which is about 6GB but the LDF file is 100GB. I have been doing some research on the matter and found out that I have several options. Switch to Simple mode, or ...