You are dead right! I'm just trying to see if I'll get any reason to choose SQL backups over VM snapshots.

@Grant Fritchey - Thanks for your reply. We kind of...

I tried hitting cancel button and eventually all other shared components got uninstalled but integration services was not. Yes, I am trying it on a standard edition. The above link...

Adding double quotes saved my hours:)

SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is registered for the SQL...

EVent log errors:

The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Windows return code: 0x490, state: 16. Failure to register...

Just got confused between so many emails

Thanks a ton for the help. I successfully deleted the log file

I followed the below steps:

1) Bcak up the T-log

2) Shrink the log file

3) Made sure status = 0 in...

Thank you, I will try out that option and let you know about my findings.

No. have not rebuilt it.

Thanks for the help. The problem was the db was having more than 3000 secondary files. It also had partition functions and schemas. I first copied the partitioned fn's and...

I tried suing generate scripts.. I was successful in transferring few objects but not all 🙁 :'(.. It has not copied all the tables.Can someboby please help me more on...

Thank you, But they need this to be done using Mirroring. So how to proceed?

Thanks for your suggestions:-)

I am sorry, It is the same issue. I wanted to make my intentions clear of my needs in the subject line