Run dbcc showcontig for that table and check the fragmentation.

Check

http://www.sqlservercentral.com/Forums/Topic384319-146-2.aspx

Check the File type of files residing under that location.

It must be 'BAK File'.

Try N'*.*' instead of 'BAK' if there are no other files than backup files in that folder.

Try N'.BAK' instead of N'BAK'.

http://www.sqlcoffee.com/Tuning02.htm

You won't be able to see it until that statement is executed.

http://www.mssqltips.com/tip.asp?tip=1620

Ask them to add your login to msdb database 'sqlagentuserrole' .

To add a user as a member of the 'sqlagentuserrole' , you can execute the following command:

use msdb

EXECUTE sp_addrolemember@rolename =...

B'coz your login doesn't have permissions.

http://www.sqlservercentral.com/Forums/Topic536293-146-1.aspx#bm912541

Whats the edition of sql server?

Specify 'EXCEL_AUTHORS' in openquery instead of EXCEL_AUTHOR.

tony.turner (5/7/2010)

---

Try DMV sys.dm_db_index_usage_stats. If there are no rows for a particular database_id, then the database has not been used since the database last came online

The advantage of the above...

Are you able to run this from partner server?

ALTER DATABASE [LancelotMirrorTest] SET PARTNER = N'TCP://Server1.domain:5022';

Anything in the errorlog any service broker messages in the errorlog

Make sure the service accounts...

Partial restore just provides a mechanism to restore part of the database to another location so that the damaged or missing data can be copied back to the original database....

Query 2 output for spotlight process(Session_id 118 is Spot light monitoring tool user connected to QuestWorkDatabase) as per internal_objects_alloac_page_count is 606664 pages i.e. 4.63gb.