I mean you attach the...

There is at least one big difference when your database is bigger than any of drives. In this case, we can use device to split up the backup files.

Here is a link for you.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx

Did you define right collation?

Partial answer for your question.

@@Servername returns the SQL Server name, more precisely, SQL instance name.

There is a column, date_modified in the msdb..sysjobs. It tells us when a job is modified. But we need to create another table to compare this one in order to...

It seems that the registries or database files of your SQL Servers are also damaged. You had better re-install your SQL Server and restore your databases.

It would be from the point that the backups completed. We did this kind of experiment. In a backup process, data files are backed up first, then transactions are applied.

You...

Did you check your disk and see whether or not they are healthy?

Declare a string, something like

SET @sql = "BACKUP LOG yourDB ...

Execute the string, something like Exec ( @sql)

Try:

DBCC SHRINKDATABASE('yourDB')

By default, the backup files are not compressed unless the backups are in a compressed folder.

Free space should be removed, but I am not sure about the fragmentation. You can...

I believe you would like to find jobs.

You can go to the msdb..sysjobs to find it.

SELECT DISTINCT name from msdb..sysjobs

My understanding is that SMO is used to manage the objects and SQL Server administration. It is not really a client tool.

Go to your source database to generate;

Excerpt your desired snippet of script;

Run it on your target database.