Thursday, 31 May 2012

UAE Telecom Industry to Amplify in Forthcoming Years


The UAE?s telecommunication market has shown tremendous growth during the recent past, mainly propelled by the government initiatives aimed at the deregulation of the market and introduction of competition. The TRA (Telecommunication Regulatory Authority) remains at the forefront of the success of the country?s telecom sector. According to our research report ?Booming UAE Telecom Sector?, with competition further intensifying in the market and operators looking at various alternatives to boost their revenue from mobile and Internet services, the telecom market in the UAE is anticipated to grow at a CAGR of around 10% during 2008 - 2012.

Our study reveals that the UAE has been very progressive in its policies towards the adoption and development of ICT technology. The government has viewed an advanced ICT infrastructure as a way to attract foreign investment and to diversify the dependence of economy from oil-based resources. We have also found that with the increasing education and business in the region, demand for Internet services has also increased during the past few years. Although dial-up subscriptions currently dominates the Internet market, we project broadband subscribers to account for nearly 65% of internet subscribers in coming few years.

Our report provides in-depth analysis of the telecommunication market in the UAE. It gives an insight into the current market trends dominating the market. The research report also presents industry forecast on various telecom segments based on feasible telecom industry environment in the UAE. These include telecommunication industry, fixed-line, mobile subscribers, internet subscribers, broadband subscribers, and 3G subscribers. Moreover, our research presents thorough analysis on the current and potential outlook of various emerging technologies, such as, IPTV and Mobile TV in the UAE.

Keeping in view that the UAE telecom market is dominated by the duopoly of Etisalat and du and their importance in the success of the country?s telecom sector, the report offers rational analysis on both these operators. This includes in-depth research and extensive analysis on their business activities, recent developments, and SWOT analysis in regard to the UAE telecom industry.

Wednesday, 30 May 2012

Resolve SQL Corruption Caused Due to Transaction Log Files Removal Interrupting Database Mirroring


Database Mirroring: In SQL Server 2008, you can use the feature of database mirroring between two databases. It can help in the data loss situations where a database damages for some reason; you can back up your database from the mirror database.

Transaction Log Files Removed Accidentally: If by chance, you remove the transaction log files; the database mirroring session can interrupt. This causes the Principal Server to fail and you will not be able to restore the data from mirror server. This can cause corruption damaging the database.

A Possible Scenario: Consider a practical scenario where you are using SQL Server 2008 SP1 (Service Pack 1) or MS SQL Server 2008. You configure mirroring between 2 databases.

Transaction Log Files Removed ? Errors Encountered: You run ALTER DATABASE command with REMOVE FILE clause for removing the transaction log files on the main SQL Server database. This can abort database mirroring session, which you cannot resume. You can also receive the following message: ?Location:" logmgr. cpp ": 3350

Expression: headLFCB-> lfcb_startOffset GetSize () * (ULONGLONG) PAGESIZE?

After that, you get the below error message in SQL Server event log logged:

?spid23s A system has failed. Check the SQL Server error log for more details. Typically, an assertion is by a software bug or data corruption. To check for any damage to the database, DBCC CHECKDB. If you send causes agreed to dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update is available from Microsoft in the latest service pack or in a QFE from Technical Support.?

Cause behind SQL MDF Corruption: The main cause behind problem can be the incorrect log on mirror-space tracking database or due to SQL database MDF file corruption.

How to Restore SQL Database? First check the cause of the problem and accordingly you can use the below mentioned resolutions methods.

1. Problem caused due to incorrect log space tracking: If the above mentioned problem has been caused due to incorrect log space tracking, then you can load the latest SQL Server update and then install it on your machine.

2. Problem caused due to MDF corruption: However, if there is MDF corruption issue, then you have to go for SQL Server database recovery. SQL recovery process can be performed using an advanced and effective third-party tool like SysTools SQL Recovery software. You can easily restore SQL master database using this simple and intuitive SQL Server disaster recovery (http://www.sqlrecovery.co.uk/how-to-restore-an-sql-database) tool. The application employs advanced scanning techniques to ensure accurate and rapid SQL recovery in almost all types of corruption cases. You can use this tool to restore SQL 2000 database also as it supports all major SQL versions