Check if you do have permission to edit the maintenance plan.

Really interesting post. One more point...

Assess the risk involved in the current scenario and communicate it to your supervisor. Surely you can provide the mitigation plan by providing access and...

Check the user permission on the on the server which you are getting this error message. Also check if the user is not orphan.

HTH

In addtion to the above posts...

Here is the link to start SQL Agent automatically.

http://technet.microsoft.com/en-us/library/aa213810(v=sql.80).aspx

You can also configure mail alert to notify when the SQL Server Agent starts than send e-mail...

Bit complicated.

Do you mean NSLOOKUP?

Do you mean NSLOOKUP?

check the following link:

http://technet.microsoft.com/en-us/library/bb895334.aspx#Replication

HTH

Check for I/O bottleneck if any.

Recompile your stored procedure and try.

Hello Anand,

Looks like you would like to do Online restore and you are doing normal database restore. Go through the following link which will help you to understand the online...

This might help you....

http://www.quest.com/techbrief/sql-server-perfmon-counters-poster811635.aspx

Also check if any settings changed in VM and thus facing this issue?

Is this production database?

This is corruption issue and you can try different options of DBCC CHECKDB OR DBCC CHECKTABLE to fix the issue.

http://technet.microsoft.com/en-us/library/ms176064.aspx

http://technet.microsoft.com/en-us/library/ms174338.aspx

There might be data loss.

Also if you...

Execute following command to check database:

DBCC CHECKDB (BizTalkDTADb)

This will help to find the consistency of the database.

Once it is successful again execute the shrinkfile command specifying the file_id.

HTH

In addition, if you enter the wrong key it will through message invalid key and you can't proceed for the installation.

HTH