correction:

step 8 and 9 are not required

did you read my post?:

<change the owner of the job to 'sa' from win\Jim>

The 7, 8 ,9 are not True statments :

due to change the Job owner you do...

do you install from CD?

try reboot pc and start again

what is your os edition\version\sp\security patch (when it was patched lastb time)

< Is this the best way to do it?>

in theory yes

in practice: it depends

--if you combine 2 databases in 1 - how you will support it - push changes, etc....

try FIX:

FIX: Error message when you try to use the SqlClient class in an ADO.NET 2.0-based application to connect to an instance of SQL Server 2005: "New request is not allowed...

start:

 Top 10 new features in SQL Server 2005

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1137301,00.html

yes. 

the hardware configuration best practices for SQL 2000 still apply to SQL 2005

what is the 'D:\AHD_Nuevo.dat' ?

in case it is sql server BACKUP file:

is it located on Tape (as per error above)? or it is on Server Drive?

if it is on Tape...

Mubeen

<If it has Bas Sectors>

there is error< I/O error (bad page ID)>

and normaly - if no CheckDB and DBreindex helps

you will run chkdsk

then as in my post you will run DBCC DBreindex...

if you run just  DBCC CheckDB

you can stop it - should be fine:

for more info see:

DBCC CHECKDB

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

DBCC CHECKDB Recommendations

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

run sp_helpdb

see DB_id for the Database

and use in filter for DB_id of sql profiler

instead of Databasename - it is well known  feature

sounds like bad sectors on your drive

Chkdsk:

http://www.microsoft.com/technet/prodtechnol/windows2000serv/reskit/prork/pref_tts_ffgh.mspx?mfr=true

---

also run

DBCC DBREINDEX

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

change the owner of the job to 'sa' from win\Jim

sure

the best place to get it:

Learning:

http://www.microsoft.com/sql/techinfo/default.mspx

in case you need to compare more then 2 and not just tables but all databases:

you would like to use 'SQL Compare' tool by

Red-Gate

http://www.red-gate.com/products/sql_compare/index.htm