Agree with Jen.

I heard that in Oracle Instance=Database

But in SQL it is Instance =  SQL Server

http://www.windowsitpro.com/SQLServer/Article/ArticleID/8686/8686.html

"Microsoft didn't build in a hard limit for the maximum number of named instances...

I am not clear with problem description. Job is working but files are not getting copied/restore?

1. Go to Loshipping Monitor, Click on the pair and Check Copy/Restore history. Is it...

Official Document

http://msdn2.microsoft.com/en-us/library/ms143694.aspx

How did you check that NON clustered is not rebuilt?

I agree with Chris.

Here are the steps in recovery:

1. Analysis

2. Roll forward commited transaction

3. Rollback uncommited transaction.

Now, if there was a transaction which was running for long time and SQL...

Below are the steps which you can follow.

1. Stop SQL Server

2. Start SQL Server from Command prompt using below syntax

sqlservr.exe -c -m -T3607

One it is done, open query analyzer and...

What do you mean by "it is full"

where did you see message? Please provide exact message from SQL Error Log

My mistake. I apologize.

You will see the error if SQLAgent started when exchange server was down. The reason is as follows:

SQL Server Agent validates the mail profile with Exchange Server when it starts....

For database orphan users, do below steps

1. Try adding Login on the server.

2. sp_change_users_login procedure to fix mismatch between login and User

3. Now either use or drop the user.

Are you able to get any results from any catalogs?

Did you try sample script as in http://support.microsoft.com/?id=295772

Please run and let us know the results.

Is there any specific reason that why you can't go with workaround?

Equivalent of  Integrity check is DBCC CHECKDB

Equivalent of Optimization job is DBCC DBREINDEX

Refer Books on Line:

MSDN Link

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_overview_2xtf.asp

If the path is not given, please follow detach/attach.

Could you please post the query? Also check collation of SQL Server.

Not sure that you seen KB article

http://support.microsoft.com/?id=811891

PRB: SQL Server Only Uses Two GB of Memory Even Though the AWE Option is Enabled