Recovering From A Suspect Database

Recovering From A Suspect Database

Tormented problem that occurred due to database showing as suspect could be recovered with a hope of luck. Various articles on the WWW depict the similar T-SQL queries to be run on the suspected database. Simply the suspected database could be restored with the latest backup available and could solve the issue in minutes. Worst case scenario you will not have a back up or the latest back up is taken after the database mode has already gone to suspect mode.

We really came across the worst case scenario to one of our most critical database. We purchased a software (recovery tool for sql server) which created scripts which could be executed to populate the tables and data from the suspected data backup. Believe me running them is a task.

Why this suspect mode in a database does occur?

Actually to our scenario we really could not find the real answer why. But we suspect to be the low disk space in the server.

During a WWW search I found these...

A database can be marked suspect for one of the following reasons (this is from SQL Server Books Online):

  • If one or more database files are not available.

  • If the entire database is not available.

  • If one or more database files are corrupted.
  • There is not enough space available for the SQL Server to recover the database during startup.

  • Database cannot be opened due to inaccessible files or insufficient memory or disk space.

  • Database files are being held by operating system, third party backup software etc.

  • Unexpected SQL Server Shutdown, Power failure or a Hardware failure.

How you could recover?

Run this query

USE Master


-- Determine the original database status

SELECT [Name], DBID, Status

FROM master.dbo.sysdatabases


-- Enable system changes

sp_configure 'allow updates',1




-- Update the database status

UPDATE master.dbo.sysdatabases

SET Status = 24

WHERE [Name] = 'YourDatabaseName'


-- Disable system changes

sp_configure 'allow updates',0




-- Determine the final database status

SELECT [Name], DBID, Status

FROM master.dbo.sysdatabases


We ran this on on our suspect mode database. But there occcred a situation where it did not display any tables after some time. But mode of the database has been chaged from suspect mode. We did this several times. With some luck this would correct the problem. But to our scenario the recovered database could not be backed up. So what we did was made a DTS transfer to another database. And made a scripts of the sp’s, views, indexes and constraints and built up simultaneous database to bring back the database with the most current data.


Essential Things That One Should Know Of Window Phone 7

Much talk that was heard around the world the last couple of days came to a halt when the Windows Phone 7 was released on the 11th of November. Intresting topics was posted throug out the WWW. Some thing that captured my eyes is the article that i am going to post to readers.

Microsoft officially unveiled its new mobile operating system, Windows Phone 7, at a press event held on 11th October 2010 in New York City. CEO Steve Ballmer described the new line of Windows Phones as "different" and more modern, in both design and principles. With Windows Phone 7, the focus is on how "real people want to use their phones," he said.

Besides being different, a key point Microsoft needs to drive home if wanting to compete in a crowded mobile landscape, there was also a big focus on personalization. "We also wanted these to be wonderfully mine, or yours, or yours, or the next person. Here's my phone, the way I've made it wonderfully mine," explained Ballmer. "My photos, my email, my start screen, my activities, my world... and of course, my avatar."

The Software

Microsoft Corporate VP Joe Belifore described the phone's final software as an operating system that helps you get things done. "We wanted to figure out how to build a phone that simplifies the basics," he said.
One of the ways WP7 achieves this, explained Belifore, is through the use of something called Windows Phone Hubs. These live-updating tiles display on the Windows Phone 7 homescreen, alerting users to new text messages, missed calls, voicemails and more. But hubs can deliver non-phone related info too, like live Twitter and Facebook updates, Internet news and new photos uploaded by friends. One hub even connects the phone to Xbox LIVE, Microsoft's online service for its Xbox 360 gaming console.
The tiles can be moved around and deleted, so as to allow complete customization of the homescreen.

The Camera

Another major feature with the new mobile operating system is how the camera works. Instead of having to launch an app, WP7 users will just press a hardware-based camera button to snap a photo. Then from within the camera's onscreen interface, you can access the photo gallery and immediately upload those photos to the cloud.

Office Integration

Microsoft's Office software is deeply integrated into the new device. In the phone's mobile version of Outlook, viewing Office documents is supported right from within an email, as is standard on many of today's smartphones. But editing Office files is also supported, explained Belifore, which is more of a unique feature.
Outlook calendaring is available, including free/busy information and conflict detection, the ability to accept meeting requests on the device, different view options (e.g. "today's agenda") and a one-touch "I'll be late" button which signals to meeting attendees that you're behind schedule.
He also demonstrated how auto-correction works - instead of automatically changing a misspelled word, the OS offers suggestions for word correction to choose from.

Bing Onboard

Microsoft's Bing search engine, whose team recently gobbled up the group from Microsoft's Live Labs, creators of SeaDragon, Photosynth and data visualization technology Pivot, is also baked into WP7.
Addresses in emails or calendar invites take you to Bing Maps, which also includes the traditional mapping application features like search, walking and driving directions and more. It also offers street-level images, similar to Google's Street View, and real-time traffic updates.
The integrated Bing service itself provides Web search, voice search (via Microsoft's TellMe), instant answers (short answer search results for things like airline flight info, sports scores, etc.) and local search, the latter demonstrated by way of a search for a local restaurant and its related reviews and star ratings. From the reviews, another tap will dial the restaurant's phone number.

The Hubs

There are six Windows Phone Hubs that ship with the device, which you can think of as Microsoft's take on homescreen widgets: the People Hub, Pictures Hub, Music + Video Hub, Games Hub, Office Hub and the Marketplace.
The People Hub connects to social networking services like Facebook and Twitter, pulling in status updates from friends and providing contact info and phone numbers. Users can respond to updates, like sending a text message or commenting on a status update from here instead of launching an app.
The Pictures Hub displays photos from your friends, including those on Facebook. Here, users can share their own photos with friends or view and comment on friends' photos.

The Music + Video Hub connects with Microsoft's Zune service offering access to music, video, podcasts and FM Radio. The Hub supports both streaming and downloads.

In the Games Hub, users can customize their Xbox LIVE avatar, send and receive gaming invites to friends and, of course, play games on the phone. Games like The Sims 3 and Ilo and Milo were demonstrated. Other launch titles include Bejeweled, Uno, Game Chest (a collection of card and board games), CarenyVale: Showtime, Halo:Waypoint, Crackdown 2: Sunburst, Rocket Riot, and more.
Windows Phone 7 will connect to Xbox LIVE, allowing users to earn achievements on the phone and track their gamerscore.
The Office Hub offers mobile versions of Office applications including Microsoft Word Mobile, Excel Mobile, PowerPoint Mobile and OneNote Mobile. SharePoint Workspace Mobile 2010 allows business users to access their company's SharePoint workspaces from the device.
The Marketplace has its own Hub, where users can search and download new apps.
Third-party developers can also build their own Hubs using Microsoft's provided development tools.


During the today's demo, Belifore showed off some big-name apps including those from eBay, IMDB and AT&T's Uverse Mobile, a media app. More apps are showcased here including games, an official Twitter app and others. We're also aware of a Netflix app, Slacker radio app, a pre-loaded T-Mobile TV app on select devices and Fandango app. No word yet on the exact number of apps available at launch.

Copy & Paste

When Microsoft announced that copy & paste was not going to be initially available on the new phones, there was a big outcry. Today, Microsoft said that the feature would be available "in early 2011" via a software update.

The Hardware

Windows Phone 7, like Android, will ship on a variety of hardware devices from multiple manufacturers. There will be nine phones arriving by WP7's November U.S. launch date (WP 7 will debut in some European markets on Oct. 21, however). Devices from HTC, LG, Samsung and Dell will be available. The form factors will vary, with some phones offering keyboards, phones with very large screens and even a ruggedized device for heavy-duty users like the one from Dell.

Mobile Operators

Windows Phone 7 will arrive on 60 mobile operators worldwide in 30 countries including AT&T and T-Mobile in the U.S., Orange, SingTel, Telstra, Telus, Telefonica, Vodafone and more.
President and CEO of AT&T Mobility and Consumer Markets Ralph de la Vega also spoke on stage at this morning's event. He said that the network, known best as the sole iPhone carrier in the U.S. was committed to offering customers a wide range of devices. Regarding WP7, he said AT&T "knew this was going to be a winner."
According to de la Vega, AT&T will launch three WP7 devices, the LG Quantum, featuring a full QWERTY keyboard for $199.99, the HTC Surround with 16 GB of onboard storage, 5 megapixel camera and two Dolby Surround Sound speakers, also $199.99 and finally, the Samsung Focus, with a super AMOLED screen, Snapdragon CPU and 8 GB of onboard storage, again for $199.99.
The Samsung will be available on November 8th, the others a "few weeks" later, but no specific launch date was given.
AT&T also announced Uverse Mobile for Windows Phone 7 customers, which will be available for a monthly fee.

Everyone at Microsoft Gets a Phone

Noted at the bottom of one of Microsoft's WP7 press releases is news of Microsoft's internal commitment to Windows Phone. "[Microsoft] has arranged for every full-time employee worldwide to be able to switch to the new phone as soon as it launches in their market," it says. While that's obviously great news for employees, it's also an indicator of how much Microsoft wants and needs the new OS to succeed. By offering everyone at the company a phone, Microsoft is, to some extent, making all employees accountable for the phone's future. "There's so much more of Microsoft we've got to bring out in the phone," says corporate vice president of Windows Phone engineering at Microsoft Terry Myerson. "We've got a lot of work to do."

Would Like to Ove One! 

Refered from  :   http://www.readwriteweb.com


SQL SERVER – How to change sa password

  • Login into SQL Server using Windows Authentication.

  • In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties.

  • Change the passwork and click ok. Now you have successfully changed the sa password.

  • Make sure to restart the SQL Server and all its services and test new password by logging into system.


WMI: Initialization failure - SQL 2000

This was and serious error that occured in one of the database servers affecting the databases operations.The  error occured in the SQL Server Agent where it displays an error saying "WMI: Initialization failure" when the dependencies tab is clicked.
This wasted a lot of valuable time in seaching for an answer. Thought of posting as it would be important to anyone who comes accross this issue.
To overcome the following error you have to create this bat file and run it.


 @echo on cd /d c:\temp if not exist %windir%\system32\wbem goto TryInstall cd /d %windir%\system32\wbem net stop winmgmt winmgmt /kill if exist Rep_bak rd Rep_bak /s /q rename Repository Rep_bak for %%i in (*.dll) do RegSvr32 -s %%i for %%i in (*.exe) do call :FixSrv %%i for %%i in (*.mof,*.mfl) do Mofcomp %%i net start winmgmt goto End :FixSrv if /I (%1) == (wbemcntl.exe) goto SkipSrv if /I (%1) == (wbemtest.exe) goto SkipSrv if /I (%1) == (mofcomp.exe) goto SkipSrv %1 /RegServer :SkipSrv goto End :TryInstall if not exist wmicore.exe goto End wmicore /s net start winmgmt :End

Paste the above code on a note pad and save it as FIXWMI.CMD and run the error machine.

China launches Moon mission

News that struck me on BBC that Chinese are now on the invasion of the outer space. China was the third country to put a man in space. The start of China's space endeavors began in the space age too, on 8 October 1956, when it began its missile and rocket research. Now china has launched its lunar mission. We as Asians wish them all the success in the mission ahead.

Quoted …….

A Chinese rocket carrying a probe destined for the Moon has blasted into space.
A Long March 3C rocket with the Chang'e-2 probe took off from Xichang launch centre at about midday GMT.
The rocket will shoot the craft into the trans-lunar orbit, after which the satellite is expected to reach the Moon's orbit in about five days.
Chang'e-2 will be used to test key technologies and collect data for future landings.
China says it will send a rover on its next mission, and has ambitions to put humans on the surface of the Moon at some future date, also.
The Xinhua News Agency said Chang'e-2 would also circle just 15km above the Moon's surface in order to take photographs of possible landing sites of the future missions.
It is China's second lunar probe - the first was launched in 2007. It stayed in space for 16 months and was then intentionally crashed on to the Moon's surface.
China launched its first manned flight into low-Earth orbit in 2003; and two more followed, with the most recent one in 2008.

Quoted from BBC………..

Copyright © My Beat