Same name as national park in Alaska...

create a new database first to copy the data...

If you can get the db into emegency recovery mode...if you can query the data use dts/bcp to new database..and you can...

I don't think it requires to specify the port number... BCP gets it dynamically port number...

If you want to specify you have to use like "-S SERVERNAME;12345 "

Are there any triggers on the table?

Run the profiler to see what is happenning behind the scenes...

What sql build you are using? and what is edition you are using?

http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/ab1d58a7ffa7777b/8fc8657d58702419?lnk=st&q=SQL+Server+Management+Studio+could+not+create+article&rnum=1#8fc8657d58702419

A transaction log grows unexpectedly or becomes full on a computer that is running SQL Server

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

For HA you can go with Mirroring or cluster

For DR: you can go with LOG shipping and there are some third party tools/sw available...

http://www.microsoft.com/events/series/technetsqlserver2005.mspx#HighAvailabilityDisasterRecovery

Looks like your update statement trying to update the row which marked marked for deleted.

If I am not mistaken SQL server will not delete physically when you run the delete...

create a script to run sql trace, create a procedure using the script and schedule it whenever you want to run...

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

http://www.microsoft.com/technet/abouttn/flash/tips/tips_020205.mspx

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

Run DBCC DBREINDEX first so that you can remove the fragementation and then run the shrinkfile command. If any of the tables contains text columns you may not be able...

You are mssing WHERE cluase in your send mail query..

@query = 'SELECT * from db1.dbo.view1 WHERE

(db1.dbo.view1.date >= dateadd(hh,-24,getdate()))',

Check SQL error log if the backup completing successful you should see the entry of completed backup ..

Did you check MP report and history?

Make sure use login configure for window authentication....

Can the user connect using osql utiltiy??

Try explicitly using TCP/IP protocol for while connecting..

http://support.microsoft.com/default.aspx?scid=kb;en-us;827422&Product=sql2k

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

http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=156

Why do you need two mirrors...

if exists (select 1 from from tablename where ....)

begin

sendmai...

end