Check that you are using the database that you wish to shrink the file of.

What's the output from SELECT NAME FROM SYSFILES ?

There is a real good article here http://www.sqlteam.com/item.asp?ItemID=6002

I used this as a basis, made a couple of changes and enhancements (error checking and the like) and use it now...

There is no automated process to handover logshipping, and to be honest, if you have lost both servers within your cluster you have bigger problems than worrying about having log...

There is no really realtime solution at this point. What are you trying to acheive, safety from a data perspective or safety from a hardware perspective?

1. When you open the package the variables will not have changed, they are simply altered at run time, because of this they will always reflect the values that were set...

Logshipping can be applied a couple of ways, you can create scripts for it (there are plenty on this site for that purpose), or if you are using SQL Server...

Check to see what is running on the server during those times.

Create a profiler trace and track back to activity during those periods.

You are talking about Mirroring the data which is going to be a Yukon thing but not a SQL2K thing. I would go for log shipping. You have have the...

When you call the DTS add a switch /A and create global variables in the DTS for each that you need to pass in, for example...

In the DTS you want...

I would confirm that the dll is registered...the easiest way would be to reregister it using REGSVR32.

To do this, open a dos window and go to the directory containing the...

Freeware Zip Util, dos based, so there is no install associated.... http://www.info-zip.org/pub/infozip/

You actually need to build the xp_cmdshell statement and then execute that...try this....

note the extra quotes and the change to OSQL instead of ISQL

DECLARE @query VARCHAR(8000)

DECLARE @db    VARCHAR(20)

DECLARE @file  VARCHAR(30)

declare...

You should check to see, within the linkedserver security settings, if you are mapping logins to remote logins. You might be attempting to pass through the account you are logging...

Does the DTS package have a connection object to the other server, or do you actually use a linked server?

If it's the first case, ask to have the SQL Service...

When you log on to the SQL Server manually, are you logging on with the SQL Server service account? If not try this and then try sending an email. Also...