Here is my thought.

Regardless the indexes, there is no difference, assuming we only have full table scans. But there will be a lot of difference in 2X2 and 4X1 joins...

You may use IMPORT/EXPORT data. It is faster to setup.

If you input data manually, what if you only input file name?

If you would like to input data programmically, you may consider to use Scripting.FileSystemObject, which can retrieve file name...

Two suggestions

1. Shrink its log file;

2. Backup msdb again;

Or

1. Export data;

2. Rebuild msdb;

It is most likely a bug in SQL Server. It happens when there is some issues in networking, in particular when you are retrieving large amount of data.

http://support.microsoft.com/kb/827452

http://support.microsoft.com/kb/834720

Try to apply...

Yes, you are right. SQL 2000 can do it in a similar approach as SQL 2005.

Generate Scripts, choose option,...

It really depends. Since you have SQL Server and IIS on the same server, I would like to recommend you limit the memory used by SQL Server because it can...

You are right. If the user is the owner of the view, it means that he has the same authority as the person who created this view. To create a...

Create a view;

Grant SELECT on this view to the user (GRANT SELECT ON VIEW1 TO viewtest);

The user does not have access to the related tables.

You did nothing wrong. But you need to do one more task to shrink your log file, such as

DBCC SHRINKDATABASE('DBName')

to release the disk space.

How about to change the execution account to others, such as local account?

Your snapshot may run at peak houts. You may try to change the schedule of your snapshot. May it work.

If there is no working experience at all, he is still a beginner even if he passed certified exam.

I do not think you can. But you can restore your msdb to a server with right version, and export data to your desktop.

How do you define the remote SAN? If SAN storage is remote, the answer is YES. We use it.