Nothing special requirements as I knew, Just perform regular database backup.

This one should help you.

http://support.microsoft.com/default.aspx?scid=kb;en-us;326613

See whether this helps you.

http://support.microsoft.com/default.aspx?scid=kb;en-us;198891

Sorry for wrong typing, should be  dbcc shrinkfile (yourdatabaselogicalfilename, emptyfile), you can get logicalfilename from sp_helpfile on your database.

Run dbcc shrinkfile (yourdatabaselogfilename, emptyfile) and alter database to drop the empty file and remove the file group.

See BOL for details.

varchar uses 1 byte to store each character, nvarchar use 2 bytes to support multiple language requirements.

By default, "set ansi_padding" is on, Trailing blanks in character values inserted into varchar columns are...

What database contention have you experienced?

Any errors in application/system logs? Is "checkpoint" still running?

You can create "execute SQL task" that create a temp table with same structure as the Access table as precedence of transferring of Access data process.

Error 845 indicates SQL Server is under a heavy stress load or high I/O conditions that could be caused by checkpoint.

sp_helpdb will tell you which database's id is 6 and...

I think so.

Sounds like checkpoint is forcing all dirty pages for the current database to be written to disk. Do you see any error messages in SQL Server errorlog? The database which...

Maintenance plan runs xp_sqlmaint which actually calls sqlmaint.exe

What is the data type of Salary column and how do you define it?

You need define it as numeric (10, 4)

How did you cloned the server?