I think that these approaches were written with only redgate in mind and not a pure approach.

In a truly secure environment, the only changes to the schema or procedures...

It was the first thing that I checked.

Great minds think alike....

Eric

You may need an account on the 2000 server that is for accvess only.

Then setup the linkserver security to use that account.  

Also if your using the online, go to the options page and replace the file names there. 

Dont forget to use the replace option (SQL) or overwrite (GUI) options when...

What about using SQL Server 3005 Snapshots?   That is if your running Enterprise Edition.

I dont know if this is what your looking for, but worth a try

Registered servers. Create your registrations. When login, you will see a list of registered servers. I registerd...

Use DBCC shrinkfile with the EMPTYFILE option to migrate all data from the specified filegroup.

This will migrates all data from the specified file to other files in the same...

No problem.

Create your database on the new server and make sure the compatibility mode is set to 80 ( SQL Server 2000)

Then copy your backup file to the...

#4 I was refering to the BUILTIN\Administrators login. 

Have you tried booting the DomainControler and the SQL box????

Eric

try going the manual approach

RESTORE

DATABASE Ten

FROM DISK = 'C:\Backup\Ten_data.bak'

WITH

 ...

Are you running this thru the GUI or with a script.....and if a script..can you post the script that your running to restore the database and log?

Ok, several things here to look at...many of which I am sure that you have already done....

1. Can the account log into your sql server box directly.....if not it has not...

The one thing no one is talking about here is why the file grew so quickly. 

I usually find that when my log file jumps in size, someone is running...

I believe your talking about Physical Files as related thru "file groups' to the SQL Server

The primary data file contains the startup information for the database and points to the...

What ID is your SQL Server Agent running under?

It should be the same as your SQL Server.

Eric