If there are several factors which damage the Microsoft SQL server then there are also many other ways to repair it. Each of the repair SQL method is having a different set of advantages & disadvantages. Let’s have a look at the repair methods for SQL 2005, SQL 2000, SQL 2008 and SQL 2008 R2 versions: Read the rest of this entry »
MS SQL is most widely used database application among various organizations all over the world. Due to its useful data management and maintenance facilities, this application comes as a boon to the enterprise users. SQL database consists of various tables which are groups of specified number of rows and columns containing major chunk of records. Read the rest of this entry »
SQL database can be a subject of corruption due to many reasons like bad sectors in the disk, unexpected system shut down, virus corruption, media corruption, software malfunction or unrecognized database formation. Your database goes in suspect mode and Read the rest of this entry »
SQL corruption can be a result of numerous factors such as virus attacks, etc and can result in severe data loss. In case of corruption of SQL database, your entire data becomes inaccessible. In order to resolve corruption in SQL database, you need to run the DBCC CHECKDB command with the read more...
Let’s consider a real life scenario wherein while working on MS SQL Server 2000 database, you get to face the following error message: “Table error: Object ID O_ID, index ID I_ID, column ‘COLUMN’. The column ID COL_ID is not valid for this table. The valid range is from 1 to read more...
Pages that contain information about the extent that SQL table/index uses are called Index Allocation Map (IAM) pages. Errors in multiple IAM pages causes corruption in the repair SQL database, which makes you to repair SQL. Given below is the error message that you may encounter after corruption read more...
MS SQL Server uses MDF file to store your crucial data. You often need to execute queries to add, delete, or modify data stored in the MDF file. Sometimes, while querying the MDF database you may get various errors on your computer screen. Interpreting some of the error messages is quite read more...
Sometimes, during MS SQL Server installation, SQL agent fails to start and the msdb SQL database is marked suspect. This article provides solution to MS SQL Server database’ suspected state. Actually, msdb database is a database used by SQL Server Agent for scheduling alerts and jobs and read more...
SQL Server is a relational model database and as we know administrators use T-SQL and ANSI SQL as their primary query languages. Talking of ALTER TABLE, this statement enables a user to rename an existing table. Moreover, this statement can be successfully used to add, modify or drop a column read more...
