SqlServer-QA.net

Do you know you can try restore a corrupted database backup using simple clause within RESTORE statement. You may be aware that SQL 2005 version can perform an optional computation a backup checksum on the backup stream; if page-checksum or torn-page information is present on a given page, when backing up the page, BACKUP also ...

Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise EditionNotification Contents: New and Major Modifications FIX: Event ID: 1 may be logged when you use a Volume Shadow Copy Service (VSS) writer to back up a snapshot in SQL Server 2005http://support.microsoft.com/kb/934396/en-US

One of my Dev. DBA asked me this question about whether we need to use NOINIT or INIT for a differential backup schedule. Think about availability option in this case, you can overwrite the existing differential backup using INIT clause but when it comes to restore the combination of Full, Differential or set of Transaction log backups are ...

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 Server 2005 for the databases you can recover the data effectively.  SQL Storage ...

  Moving to a Windows server environment allows organizations to unify disparate systems, lower maintenance costs and scale business-critical applications to meet demand. Attendees of this Webcast will discover the advantages of modernizing their legacy IT systems, including: Combined mainframe and Windows development teams ...