Just open the Maintenance Plan --> Backup Task. Click Ok and Save the Maintenance Plan. This should fix it.

Please involve the storage team to check for any issues with the storage or if any of the drivers need to be updated.

Also inform the Windows Administrators to configure the...

There is no Service Pack for SQL Server 2008 R2 yet. CU4 is the latest and you can download it from here.

Was the index being dropped when the Maintenance Job was running? Did you try running the Maintenance Job again?

The SQL Server Error Log and the System Event Log should have more information regarding this. Someone manually bringing the database OFFLINE is also a possibility.

You can make use of the Default Trace[/url] to get that information.

Enabling C2 audit can make the drive run out of space pretty quickly apart from other overheads. Here[/url]...

These errors are usually logged in the Agent Log or by the application when the SQL Server instance low on memory or the underlying storage is having some issues. You...

Native backups to disk does not support excluding objects. SSIS is a good option for you to export the table to another database.

You can create a database to store the...

Sachin,

SQL Server does not have an option to backup a table as a .bak file. You can make use of SSIS to export the tables.

The new server needs to be on the same build (2039) as that of the old server. This article has more details.

You can set a max size to the primary data file in a such a way that it will leave some free space on the drive. This will ensure that...

You may find this useful.

Like you mentioned F drive is not mentioned. Hence SQL Server service is not starting up.

AFAIK, for any T-SQL query that you would execute using SSMS there is no limitations. However some of the advanced features available in the Enterprise Edition might not be accessible...

Yes. You would be able to connect to other SQL Server instances using SSMS of Express Edition.