Try this. see if you gets any error then post it

USE [master]

GO

CREATE DATABASE [AdventureWorks] ON

( FILENAME = N’C:\Data\AdventureWorks_Data.mdf’ ),

( FILENAME = N’C:\Data\AdventureWorks_Log.ldf’ )

FOR ATTACH

GO

nice way to deal with excel data to insert into table.

Granting EXECUTE permission on a stored procedure

The following example grants EXECUTE permission on stored procedure HumanResources.uspUpdateEmployeeHireInfo to an application role called Recruiting11.

USE AdventureWorks2008R2;

GRANT EXECUTE ON OBJECT::HumanResources.uspUpdateEmployeeHireInfo

...

If you have only xls and txt files then you can simply use the below query to copy

exec master.dbo.xp_cmdshell 'copy c:\source\*.txt D:\folder1\'

exec master.dbo.xp_cmdshell 'copy c:\source\*.Xls D:\folder2\'

Check this article.

http://troubleshootingsql.com/2011/02/09/troubleshooting-that-darn-backup-error/

http://support.microsoft.com/kb/934396

Check this post.

http://www.sqlservercentral.com/Forums/Topic517209-5-2.aspx#bm688879

good to recall basic stuffs.

Here is the command for adding user on SQL server 2000/2005

--2000

exec sp_addlogin @loginame='NewLoginName',

@passwd='The Password',

@defdb='Default Database Name', --Optional

...

it seems you moved the resourceDB to other location. after restart it will show both location in error log. next time it wont trigger the same error.

Steps:

http://msdn.microsoft.com/en-us/library/ms365603.aspx

CHeck this post.

http://http://blogs.msdn.com/b/sqlserverstorageengine/archive/2007/01/18/fixing-damaged-pages-using-page-restore-or-manual-inserts.aspx

Here is set of videos and tutorial for SQL server beginer, it wil help you to start the journry of sql server.

http://archive.msdn.microsoft.com/SQLTutorials

You can use job history to find the duration of job. by right clicking on job in agent activity monitor.

very informative article.