I am not using any sql script. I used SQL Management Studio and right clicks for backing up and restore as well.

While backing up I had selected...

The database is using 4 data files and one log file. To tell you more I haven't created this database myself, it was already there for existing applications. So...

Even I thought this and tried restoring the backup after stopping the source sql server from which I took my backup but the same error persisted.

Regards

Vishal

Sorry for missing the attachment of error screen. I have attached that now as RestoreError.zip. See in Attachments.

Please have look at it and let me know your opinion.

This should work

select * into x from [Linked Server Name].[Database Name].dbo.TableName

Caution: The above statement will just create x table with data copied from TableName and will not copy the...

Try following trick...

update emp set empid = 100 where empid = 10

The above statement gave me following error as empid is identity column

Cannot update identity column

Hence I did following and...