Can you post the output of restore filelistonly from disk='complete backupfilepath.bak'?

MJ

Have you checked http://support.microsoft.com/kb/300956

Or

Try installing with domain admin rights if this is not a stand alone instance.

MJ

Don't change anything for min server memory just change the max server memory to 2.8GB as other poster said.

MJ

Are you making selection out of the available databases listed on the right hand side when you click on Transactions/sec counter?

MJ

You just need to change the restore part of the script to make use of multiple mdf and ndf files.

Take the concept from procedure listed below:

--restore filelistonly from disk='c:orthwnd.bak'

Create PROCEDURE...

What do you see when you run select * from spt_server_info?

MJ

It can be done if you incorporate this logic in execute SQL task and check for duplicates at source before proceeding to next step(actual data import).

MJ

As others said you need to apply SP2 again(for client components).

MJ

Some hints can be taken from: http://seer.support.veritas.com/docs/262709.htm

Do read about recovery tool "Cluster Server Recovery Utility" at http://www.microsoft.com/downloads/details.aspx?FamilyID=2BE7EBF0-A408-4232-9353-64AAFD65306D&displaylang=en

HTH!

MJ

Use the below mentioned script and see what it says on space uasge for individual file:

sp_msforeachdb 'USE ?

select Name,

(convert(float,size)) * (8192.0/1048576) File_Size,

(convert(float,fileproperty(name,''SpaceUsed'')))...

rank question_id question ...

Are you talking about servers consolidation?

MJ

What version number do you see when you click Help-->About under management studio?

MJ

Based on the article stored procedure you need to create it in all thee databases and call them separately in a job.

MJ

What is the size,autogrow increment of this data file?

MJ