Ars Technica

MSSQL2000 restore from specific transaction log onto a different server

I'm trying to recover an earlier version of a database from a tape. I've got the bak file and all of the TRNs in a folder on a different server (wanted to restore it to our testlab sql server). From ...
Houston Chronicle

How to Restore a SQL Database From a .MDF File

Computer database software such as Microsoft's SQL Server benefits all types of businesses, as it makes recordkeeping fast, flexible and secure. SQL Server lets you disconnect a database from the main ...
MCPmag

Log Explorer unlocks your SQL Server Transaction Logs

Lumigent calls this application a "transaction analysis and data recovery solution for Microsoft SQL Server." I call it an essential tool for the SQL Server 7.0 or SQL Server 2000 DBA whose users make ...
TechRepublic

Help! My SQL Server Log File is too big!!!

Help! My SQL Server Log File is too big!!! Your email has been sent Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim ...
Ars Technica

How to track down the source of SQL transaction log growth?

I'm not a DBA - my knowledge of SQL is limited to install, uninstall, backup, restore, troubleshoot connectivity, that sort of thing. That said, one of the servers I manage has a database that behaves ...