Suspect Database in SQL Server

If your database is in suspect mode there are several possible reasons:

1. You do not have enough space available so the SQL Server can recover the database during startup
2. Your Database might be corrupted
3. Maybe there is no enough memory
4. Possible hardware failure.
5. The Database files are held by other programs

To try to solve this problem following the next steps, but before I encourage you to make a copy of your database file, because in the process you could loss some data and there is no way to go back to the previous state.

STEP 1.- Put the database in EMERGENCY mode so you can manipulate the database

USE master
GO 

ALTER DATABASE mydb SET EMERGENCY
GO

STEP 2.- Put the database in single user mode, so nobody can interfere with the process

ALTER DATABASE mydb SET SINGLE_USER WITH ROLLBACK IMMEDIATE 
GO

STEP 3.- Try to repair the data base

DBCC CHECKDB (mydb, REPAIR_ALLOW_DATA_LOSS) 
GO

STEP 4.- Return the database to a multi user so it can be accessed

ALTER DATABASE mydb SET MULTI_USER
GO

Now you database should be ready to be used; check the logs so you can fix any problems found.

Agent xps component is turned off as part of the security configuration for this server

You are going to get this error on SQL 2005 is you are trying to create a maintenance plan; the problem is that your SQL Server Agent is not running, which menas is set to run manually, so you have to change it to start automatically, so all you have to do is follow the next simple steps:

1.- Open the SQL Server Surface Area Configuration
2.- Select the Surface Area Configuration for Services and Connections
3.- Expand the SQL Server Agent
4.- On Service, change the Startup type to Automatic
5.- Click Start button
6.- Click the OK button

Now you are ready to create your maintenance plan.

Android Emulator is not working

Some people think the emulator of Android is not working because it shows only the Android text.

The problem is not a problem, all you have to do is wait,because the emulator takes a long time to load the first time, several minutes, and in this time only shows 'Android' in large text.

You need to wait a couple of minutes and then you should be fine, this waiting time is going to depend on your computer processor and memory Ram.