In Microsoft SQL Server 2008, you can configure the database mirroring between two database. It improves database reliability and prevent data loss situations, if one database gets damaged due to any reason. In case of failure, you can restore the copy of your database from mirror database. However, if you unintentionally remove the transaction log files on SQL database, database mirroring session is broken by principle server. After this behavior, you can not restore the data from mirror server if principle server fails. It causes database corruption and require SQL Database Recovery to be fixed, if backup is not available.

As a practical instance of this problem, consider the underwritten scenario:

In Microsoft SQL SVR 2008 SP1 (Service Pack 1) or Microsoft SQL Server 2008, you configure mirroring between two databases.

You run ALTER DATABASE command along with REMOVE FILE clause for removing the transaction log files of SQL Server ...

read more

Are you getting out-of-range or invalid data errors while accessing Microsoft SQL Server database? When you create a table in MS SQL, you need to specify the data types, size, and type of values that you can store in particular table. In case you store invalid data in any table, you may face this problem. The problem can also occur if database table is damaged and SQL application is unable to read it. This behavior causes data inaccessibility and data loss. At this stage, you are required to opt for SQL database recovery to work around the problem.

Out-of-range or invalid data might get stored in Microsoft SQL database table in the older versions for any of the below reasons:

Invalid data is passed by RPC (Remote Procedure Call) event calls made to MS SQL.

Invalid data is presented in source when you use bulk-insert mechanisms, like bcp tool.

Other ...

read more

read more

read more

When the server or database system of MS SQL Server 2008 or 2005 crash, it's very difficult to recover the original data backup with MS SQL code, but its not impossible. MS SQL Server database unlike other databases such as FoxPro can copy data files; the former must have a backup strategy in order to secure data backup recovery. So take an appropriate backup & recovery operation to recover corrupted data, the data of MS SQL 2008 and 2005 can be safely protected.

Restore vs. Recovery

Restore and recovery are two different concepts, but in the database recovery process is also closely linked together. The difference between restore and recovery is given below:

Restore is equivalent to rebuild the part or whole of the database from a backup. It can not change the state of database, such as offline and online.

Recovery of database means it restore the database from ...

read more

Are you facing problems while using MS SQL Server 2008 database? Then, there may be chances that the database may have got corrupt. The database corruption can occur due to various reasons such as virus infections, abrupt system shutdown when the database is open, hardware problems, etc. Due to database corruption, you would not be able to access the database or face abrupt behavior. In such cases, you should perform appropriate SQL repair methods to solve the problem. If you are unable to repair MDF file, then you should use a third-party MS SQL repair software to do the needful for you.

Consider a scenario wherein you encounter the following error message while working on an MS SQL Server 2008 database:

"Table error: Object ID O_ID, index ID I_ID, partition ID PN_ID, alloc unit ID A_ID (type TYPE), page P_ID, row ROW_ID. Record check (CHECK_TEXT) failed. Values are VALUE1 and ...

read more

Nivo Slider is the most awesome jQuery image slider, manual and auto slide transaction with cool effect. jqFancyTransitions is easy-to-use jQuery plugin for displaying your photos as slideshow with fancy transition effects.

Nivo Slider Home Page

Will Microsoft SQL Server ever pass Oracle?

Do you prefer using Visual Basic instead of C#? Does your company not allow the coding in C#?