Just check sql error logs and make sure that neither agent service nor sql service restarted at job's scheduled time...

MJ

Yes, you need to restore system db's too as those will bring logins, linked servers, jobs, operators etc. on your DR server.

MJ

Try by using sqlcmd [-o output_file] parameter.

http://msdn.microsoft.com/en-us/library/ms162773(SQL.90).aspx

MJ

I think you might need to create anew table followed by exporting all the current table data to this new table and finally renaming the new table. As you are...

For 2000 use dbcc dbreindex and for 2005 use rebuild option under alter table command(http://www.mssqltips.com/tip.asp?tip=1367).

MJ

8.00.2055 SQL 2000 Service Pack 4 + Security Update KB960082

http://www.bigdatabaselist.com/wiki/SQL_Server_Version_Builds

HTH!

Manu

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

Manu

Make use of definition column under sys.sql_modules.

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

Manu

Haven't you specified the time under 'Delete Copied Files After' under "Copy Files" tab on "Secondary Database Settings". window?

http://sqlserveruniverse.com/content/ADMN0100111132007LogShipping.aspx

MJ

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

MJ

http://vyaskn.tripod.com/track_sql_database_file_growth.htm

MJ

Haven't you specified the time under 'Delete Files Older Than' under "Transaction Log Backup Settings" window?

http://sqlserveruniverse.com/content/ADMN0100111132007LogShipping.aspx

MJ

Won't this(http://support.microsoft.com/kb/246133) link work for you?

MJ

Do you mean xp_sendmail?

MJ

Tail-log backup

A tail-log backup is a transaction log backup that includes the portion of the log that has not previously been backed up (known as the active portion of the...