NVARCHAR/VARCHAR and NCHAR/CHAR are allocated differently in data pages. If you change data type from NVARCHAR to VARCHAR, you should not be able to release free space because of the nature...

Suggestions:

1. Check if anyone is using these databases (sp_lock, or someone is copying these database remotely?);

2. If no one is using these databases, the only choice may be restart your SQL Agent....

Just for Mohammed Uddin. Your statement, "

I don't think there is way to schedule every three days using nt scheduler...",

 is too fast....

I had even worse experiences. The best choice is nothing but leave this company! Remember the saying:

If you cannot change the world, change yourself.

Best wishes.

Are you asking how to determine a server is master or slave?

Yes, you can. But you need a stable network when a huge database is either backing-up or restoring.

Attentions should be also paid to

1. If the restore order is correct?

2. If the restore file paths are the same as the original data file paths?

...

Using rule.

Could you set the recovery mode of the database to SIMPLE before deleting?

How about the ADD/REMOVE PROGRAM from the Control Panel?

Could you use EXPORT/IMPORT utility to generate scripts for you?

Since someone still can read the DTS packages, DTS packages are not corrupted. The scenario you described also happened for SQL Server 2000 with different SP.

Before SQL 7, there is a simple approach to backup a table. After SQL 7, we need to put a table into a filegroup, and then we can backup and restore...

If you do not set BEGIN TRANS, the system will roll back the from the current transaction. Otherwise, in order to rollback to desired spot, you need to add some...

Normally, we do not have to. But, since your server has installed SP4, you had better install SP4. Otherwise, you may not get full functions, such as openning a DTS.