It seems that the dataset is getting processed on the server side in one case compared to the client side on the second one. somethings you might want to check are...

I don't see much issues with this. tempdb is always in simple recovery mode and you should be able to drop the files. soemthing you might want to do is...

1) That's fine, Restore will create a new database for you.

2) not sure what you exactly meant

3) You can use the following command

restore filelistonly from disk = ''. Take the...

SQL Server will dynamically decide on the resources available whether to use an execution plan in parallel or not. Can you check the value for max degree of parallelism parameter...

Nope, you can use the copy database wizard and that would be helpful

Not sure if this is what Frank was referring to but it has some relevant information.http://www.sql-server-performance.com/lm_index_elimination_english.asp

you can use dts packages and schedule the same. you can also detach your existing databases, copy them over and  then attach the same. But this would be more a...

restore database db_name from disk = 'c:\test.bak' with move

'test_data1' to 'c:\test_data.mdf',

move 'test_data2' to ''c:\test_data2.ndf',

move 'test_data3' to ''c:\test_data3.ndf',

move 'test_data4' to ''c:\test_data4.ndf',

move 'test_log' to 'c:\test_log.ldf', replace

you can find the logical names from

restore...

Clusters uses disk signatures to identify the disks and not the logical drives.

We used the clusterrecovery.exe utility for swapping SAN disk on our cluster. It is built into the...

did you try the alias ? I think you might have tried this but can you try to telnet and see if you can open the port on which it...

I'm not sure but i believe re-start of services  might help.

It is possible that there is an application which would continously access a database, hence the optimization job would wait to be granted an exclusive lock. When you rebooted windows,...

What's the error message you are getting ?

http://support.microsoft.com/kb/231347/EN-US/

SQL Server does not support writable, database file storage on a compressed drive. This may be causing the issues.

No, you will install SQL only twice, once each for each instance. When you install SQL, it will give you an option of installing on a virtual server or local...