You want to move the DTS back to 2000 ? If you open the package in 2005, and choose "save as" and select the 2000 server, maybe that will...

What would make it look in 2 different locations ? Noting in the DTSrun specifies a file location.

We've had odd failures like this too. Seems that we get orphaned Excel sessions open on the server, and after too many are left open, DTS packages using Excel fail,...

Server A could set a PASS/FAIL flag in a table on Server B.

Server B job checks the flag to see if it should run or not.

You might also want...

Search this site for "NEW DBA", then after reading, maybe you will have more specific questions that can be answered.

More details & more specifc question(s) would help.

What method of backup are you doing ? Is it appending to backup device with other backups ?

Simplest method is backup to disk by itself (Database_Name.BAK), then restore from...

Duplicate post. Try this one, which has slightly more detail:

http://www.sqlservercentral.com/Forums/Topic848042-146-1.aspx

Perhaps you heard such a thing because some people schedule other tasks along with their backups. They are separate actions, and I prefer to schedule them separately since they usually...

Was the original index unique ?

Can you show us the script for the index before you dropped it, and the script for the new index ?

That sounds awfully cumbersome. I do what Carolyn suggested. Put all the jobs into 1 job as separate steps using the GUI, then send an email notification at the end.

If...

We had performance issues after upgrading to 2005. Some of them were resolved after closely looking at the joins and finding we needed to modify or add the CONVERT functions...

GilaMonster (1/14/2010)

Aaahhhhh!!

Why does everyone recommend nolock any time there's a long running select? How about tuning the query, tuning the index...

Why do you want scheduled COPY ONLY backups ? That function is usually used for one-time backups that will not affect the log chain.

Anyway, I found this on BOL....

Better than nothing, but can't sort by date. Oh well, wasn't really important.