How to transfer SQL database from one server to another??

I have found an interesting topic in the morning that discussed about “how to backup the database from one server to another ?”. We all want our database will always safe and corruption free. In this modern tech era every databases are very pron to the corruption. As database administrator our main task is maintain the our database safe and high availability for the users. A SQL server database got corrupted or damaged by the several reasons like metadata structure corruption, virus attack, human errors, hardware related issues and many more. In the case of corruption we can restore our database from the secondary server thats why we want to transfer our SQL database from one server to another. But it is very expensive because we will have to maintain the both servers. Most of the companies or organizations prefer their database safe rather that expenses. Microsoft provides several options from transferring SQL database from one server to another server, which are given below:

• Log Shipping
• Database Mirroring
• Snapshot Replication

Log Shipping: In this method you can not perform any operation on the database that is on secondary server. If you want your secondary database to be accessible then you will have to backup, copy the SQL server database on the network and restore from there.

Database Mirroring: In this methods also you can not perform any operation on the secondary server. It just create the copy of your SQL server database. You can use the second database in any corruption on the primary database.

Snapshot replication: If you want to transfer your database from one server to another server on the regular basis then this method is very helpful and effective. This method does not slow the SQL server performance.

At last you can also use database copy tool for the transferring SQL server database from one server to another server.

Note: The main motive behind this transferring operation is recover MS SQL database if any corruption happens at the primary database.

»»  Read More...

How to recover SQL Server 2000 database from Error 2512

MS SQL Server 2000 is used to provide enterprise solution in many reputed organizations. The primary reasons behind this are that it is simple to use, scalable for huge databases, provides strong support for demanding situations, etc. However, having said that, the database tables may sometimes become corrupt thereby disabling you to use it properly. Such issues can occur due to virus infections, power outages, damaged hardware components, etc. You should inquire for the cause of the corruption and try to recover SQL database. If you are not able to resolve the issue, then you should use a third-party SQL data recovery software to perform SQL recovery.

Consider a scenario wherein you encounter the following error message while working on an SQL Server 2000 database.

"Table error: Object ID O_ID, Index ID I_ID. Duplicate keys on page P_ID1 slot SLOT1 and page P_ID2 slot SLOT2."

Cause:

The primary cause of this error message is that there are two slots on the database table that share the same keys, including the unique identifiers.

Resolution:

To resolve this erroneous situation, you should recover SQL database. You can do this using the following methods:

Resolving the hardware issues: You should check the hardware components by running the hardware diagnostics. The error logs can also be checked in this method, and you can also consider swapping the hardware components to narrow down on the actual cause. If nothing works out, then you can reformat the hard disks and reinstall the operating system.


Checking the database backup: If it is not a hardware related issue, then you should check the database backup. If it is clean and updated, then you should replace the corrupted database with the backup.

Running DBCC CHECKDB: If the backup option does not work out, then you should run the DBCC CHECKDB command without any repair clause to know the extent of corruption. Then, run it again with the recommended repair clause.

The database would now be fine after using the mentioned methods. However, if you still are facing similar issues then you should use a third-party SQL database recovery software to recover SQL database. Such SQL recovery tools are able to repair corrupted databases without overwriting the existing ones.

Stellar Phoenix SQL Data Recovery is an MS SQL recovery software that recovers logically corrupted SQL databases from all instances of corruption. It recovers various database objects such as tables, queries, stored procedures, triggers, etc. This MDF repair utility is designed to recover SQL databases created in SQL Server 2000, 2005, and 2008. It is compatible with Windows 7, Vista, Server 2003, XP, and 2000.

»»  Read More...

Rectifying Error 5228 in SQL Server 2008

When you use the DML (Data Manipulation Language) commands to update the database, the rows sometimes get in an intermediate state. It is called the antimatter state that enables concurrent DELETE statements to leave a pointer for the index builder transaction so that deleted rows are not inserted again. Ideally, these rows should be deleted at the end of the operation. However, sometimes it does not happen that invariably results in database corruption. To resolve this situation, you should use appropriate corrective methods. However, if you are unable to do so then you should use a third-party MDF repair software to address the issue.

Consider a scenario wherein you are working on a table in SQL Server 2008. You get the following error message while performing some modifications on the database table:

“Table error: Object ID O_ID, index ID I_ID, partition ID PN_ID, alloc unit ID A_ID (type TYPE), page PG_ID, row R_ID. DBCC detected incomplete cleanup from an online index build operation. (Antimatter column value is VALUE.)”

Cause:

The root cause of this error message is that for the O_ID object , I_ID index, and PN_ID partition, there is an unfinished online index build was detected. This is testified by the presence and the displayed value of an antimatter column on the R_ID row.

Resolution:

To resolve this error message, you should perform the following methods, preferably in the given order:

Check for hardware issues: You should run the hardware diagnostics and check if the error appeared because of any hardware issue. You can also try to swap the hardware components to zero in and resolve the issue. In addition, you can try to reformat the disk and reinstall the operating system.


Restore from backup: Check if you have a clean and updated backup of the database. If yes, then you should restore the database with its backup.

Run DBCC CHECKDB: As a last resort, you should run the DBCC CHECKDB command without the repair clause to ascertain the level of the corruption. You should run the command again after knowing the repair clause. It will rebuild the corrupted indexes.

However, if you still are not able to resolve this error by any which method then you should use a third-party SQL recovery software. Such read-only tools are able to recover SQL database using sophisticated scanning algorithms without overwriting the original data.

Stellar Phoenix SQL Recovery is an MS SQL recovery software that enables you to recover corrupted databases created in SQL Server 2000, 2005, and 2008. It is competent enough to restore various objects of SQL database such as tables, queries, stored procedures, triggers, views, etc. This SQL recovery software is also able to preserve the database constraints and user-defined data types. It is compatible with Windows 7, Vista, Server 2003, XP, and Server 2000.

»»  Read More...

Rectifying Error 2579 in SQL Server 2000

The most basic unit of storage in an MS SQL Server database is a page, which accounts for 8 KB of size. And 8 such pages consist an extent thereby making 16 extents in 1 MB. An extent is used to allocate spaces for tables and indexes. The well-being of the database structure is absolutely essential for the database. However, at times problem arises in the structure of the database because of various reasons such as virus infection, power surges, human error, hardware failure, etc. In such cases, you should use appropriate measures to rectify the situation. However, if you are unable to do so then you should use a third-party SQL server recovery software to recover SQL database.

Consider a scenario wherein you encounter the following error message while working on an MS SQL Server 2000 database table.

“Table error: Extent P_ID object ID O_ID, index ID I_ID is beyond the range of this database.”

Cause:

The cause of this error message is that an extent has been allocated in an Index Allocation Map (IAM) page for the referenced index ID. In the error message, P_ID is the ID of the corrupted page in the table. The pageinfile of the extent is greater than the expected size of the file specified in the database, which has caused the error.

Resolution:

To resolve this error message, you can perform the following methods, preferably in the given order:

Look for hardware issues: Run hardware diagnostics to resolve any issues. Also, check the error logs to check whether the issue has occurred because of any faulty hardware. You can also swap the hardware components to zero in on the problem. You can also consider switching to a new hardware system altogether.

Restore from backup: Restore the database from its backup if it is updated and clean.

Run DBCC CHECKDB: Finally, you can run the DBCC CHECKDB command, first, without any repair clause to know the corruption level. Then, run the command again with the suggested repair clause. However, you should refrain from using this method if you are not sure about the aftereffects of using the repair clause on the database.

However, if you are unable to address the situation even after using the mentioned methods then you should use a third-party SQL Server recovery software to recover SQL database. These read-only tools are able to perform SQL database recovery using fast yet sophisticated scanning algorithms without damaging the original data.

Stellar Phoenix SQL Database Recovery is an MS SQL recovery tool that enables you to recover corrupted databases created in SQL Server 2000, 2005, and 2008. It is able to perform mdf repair of various database components such as tables, triggers, views, rules, stored procedures, etc. This SQL Server recovery tool is also capable of recovering database constraints and relationships among tables. It is compatible with Windows 7, Vista, Server 2003, XP, and 2000.

»»  Read More...