Browse by Tags

SQL Server databases - checkpoint, cache and I/O request - what you need to know?

Published 22 April 8 1:51 PM | SSQA.net

Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes...

Filed under: sql server, performance, msdn, backup, blogs, database, transaction log, cache, i/o, flush, monitoring, checkpointl

SQL Server 2005: What percentage of changes happened within the database after the last successful backup?

Published 21 April 8 3:1 AM | SSQA.net

No doubt that the blog subject will be a most wanted requirement on their databases, that is most responsible for a SQL Server database then arguably the most critical task that you absolutely MUST get right is your database backup procedures. Where the...

Filed under: sql server, data, backup, blogs, simple, 2005, full, recovery model, changes

Recover the corupt databases with the features in backup & restore - SQL Server 2005

Published 6 May 7 4:50 AM | SqlServer-QA.net (SSQA)

Have you ever wondered you can recover a corrupted database when you have optimum backup & restore strategy in place, well I'm not talking about usage of third party tools or use high-end hardware. With simple backup and restore features in SQL...

Filed under: sql server, msdn, microsoft, high availability, backup, blogs