I am presently using SQL Server 2000. I have a database containing a clustered table named ‘dbo.MyWidgetTable’. This table has a unique constraint on it as follows:
‘CONSTRAINT UK_Widget_UID UNIQUE NONCLUSTERED (Widget_UID, WidgetColor)‘
This constraint is applied to help ensure referential integrity when dealing with foreign key relationships. There is one more clustered index on the same table. Further, the table also has two non-clustered indexes as follows:
For the last couple of years, all our backend SQL databases were running fine. Recently, an error showed up on accessing one of the primary databases. This was error 823 that read ‘I/O error (bad page id) detected during read at offset’. This was some kind of corruption because of which the database failed to open. As the database had entries and records of the past two years, I was desperate for a quick recovery. I took the advice of two DBAs and followed this procedure to get back Continue reading
If you are using Microsoft SQL Server as the back-end RDBMS for your applications, you need to have some idea over its internal architectures. This will help understanding messages logged in the event log and resolve problems efficiently. However, if you encounter a problem, which has made your precious SQL Server database completely inaccessible and you are not finding any inbuilt way out, you can always rely SQL recovery software, like Stellar Phoenix SQL Recovery software. Continue reading
SQL Server is a relational database application developed by Microsoft. For its increased scalability, reduced downtime, good performance and tight yet flexible security controls, SQL Server database is popularly used at the back-end of many applications with huge on-line transaction load. In the course of their working, these applications store many large sized binary objects on the database, which can even be of some MBs. SQL Server stores these large application objects with LOB (Large Objects) data types. But, at times due to any application error or anything similar, the LOB page structure gets corrupt and all the LOB data on the database becomes completely inaccessible. In such situations, you need to take the help of any advanced SQL Server recovery software to recover the data back. Continue reading
One major problem that I faced while running SQL Server on Windows Vista was sparse files. This problem was concerning disk fragmentation. As the database files are usually large in size and heavily fragmented, I used to get various errors from the operating system. These errors showed up every time I performed some of the major database operations. Frequently, I saw the Error 665 on my screen that stated:
“The requested operation could not be completed due to a file system limitation”
I remember when I was using Windows 2003 R2 earlier, I used to encounter Error 1450: Continue reading
There are a plethora of misconceptions that surround SQL Server database corruption and recovery. Most users still believe that they can easily get away with all the issues concerning SQL corruption by just performing a simple server restart. But, the truth lies in the fact that neither restarting the SQL Server nor rebooting the Windows computer can fix a corruption. In order to properly address the issue of corruption, you need to restore or rebuild the corrupt page. Continue reading
The most important concern for a database administrator is disaster prevention and recovery. Their main job is to ensure high data availability to the users. However, database corruption may sneak in at any time and cause a catastrophic situation of data loss. When coming down to SQL database corruption, it is more specifically related to issues at the IO subsystem level. Every time a corruption is encountered in your SQL database, it is generally due to problems with one of your drives, controllers, or drivers. As a consequence, you may experience downtime while performing some of the important database tasks and receive a series of errors that indicate damaged pages in the database. To effectively overcome this problem, you should go for SQL recovery through a reliable third-party tool.
As a practical example, consider this case. You may come across the following error message on your screen while using your MS SQL Server 2000 database: Continue reading
Microsoft has produced and marketed many useful products, among which SQL Server is one. This is a relational database application meant to store and manage data, as requested by other applications. SQL Server database is available in 10 different international languages and supports almost all major Windows operating systems. For its wide compatibility and advanced features, many organizations use SQL Server database to store their business critical data in it. But, at times the SQL database gets corrupt and all the important data in it becomes completely inaccessible. However, there are many innovative SQL database recovery software available in the market, which can help you repair the corrupt database and recover inaccessible data. Continue reading
Stellar data recovery, leaders in data recovery software & services announced the launch of Stellar Phoenix SQL Recovery Software V4.0. Now SQL recovery software will compatible with SQL server 2008 R2 as conformed by Stellar R&D team.
New Added Features: Continue reading
Today, we will talk about DBCC CHECKDB command of MS SQL Server database. This is basically repair command used by MS SQL Server to check the physical and logical integrity of all the objects present in the selected database. Thus, if you have run DBCC CHECKDB command on your SQL database then you do not require running DBCC CHECKALLOC, DBCC CHECKCATALOG, and DBCC CHECKTABLE commands individually as DBCC CHECKDB integrates all these commands. Though DBCC CHECKDB is one of the best repair commands to deal with the corruption of SQL database but at times this command too fails to fix the issue and returns some errors. One solution to deal this situation is to restore database from backup. However, if you do not have the backup of your database or the backup too gets corrupt then you need to opt for SQL database recovery through reliable third-party database recovery software.
Let us exemplify the above situation. Suppose, you try to mount your SQL database and see the consistency issues which are occurring in the database. Thus, to resolve this issue when you run DBCC CHECKDB command, you encounter the following error message: Continue reading
