August 17, 2009

Corruption due to table partition error in SQL Server 2005

Database Recovery, MS SQL Server Recovery

Microsoft SQL Server 2005 is designed with exceptional features of table partitioning with which you can utilize to enhance the performance of large databases as these partitioned tables are flexible and easy to maintain. DBCC CHECKTABLE command is used to keep a check at the consistency of these partitioned tables and therefore when a user…

Continue Reading →

How to Resolve SQL Server Error 2515?

MS SQL Server Recovery

Backup is the key to perform recovery of database objects after the corruption of database file. SQL Server provides you with a number, Log Sequence Number (LSN), which during the process of database restoration is used as a recovery point. LSN also helps you perform differential backup. When you perform differential backup, a bitmap corresponding…

Continue Reading →