Good one, Andy. Thank you.

If you have tested and result set are giving correct output than you can keep the upgraded version of the database i.e. 110 elase you can change it back to...

Looks like extract of the output.

Rebuild the index or drop and recreat index for object id 60 and run DBCC CHECKDB to verify.

+1

As there are 1 TB data suggested to avoid any constraints on the table. e.g. foreignkey, check constraints, indexes etc. This will speed up the process. You can do the...

Repeted but OK. Thanks for the question.

My approach is similar to Hansi. If you do have enough disk space and shrink is only 5 GB just let it be.

Looks like SAN issue.

Yes it is possible. Refer following link:

http://msdn.microsoft.com/en-us/library/ms189127.aspx

It will be difficult unless you are tracking the changes.

What if once user has version 1.1/1.2 and switch back to 1.0 or user use their login on old version 1.0 after he used higher verison? How data consistency maintained?

Hello Saikat,

Pl. do not post the duplicate thread on the multiple places. It will creat confusion and difficult to track the thread.

Cheers.

Refer following link might help:

http://stackoverflow.com/questions/11278114/enable-remote-connections-for-sql-server-express-2012

HTH

Are you perfroming the restore on the server is having same version of SQL Server?