You can use import and Export Wizard to export the data into Excel file

It wouldn't unless you configure some customized sql job to store it manually in a table

You can configure Windows cluster on the nodes first then install SQL instances and configure them for AlwaysON or you can install SQL instances on the nodes , configure Windows...

are u running any sql job or SSIS package or stored proc?

There are two things to be taken care in the code :

1) Select count(*) from Total - this should be Select count(*) from Total where deptid= @deptid

2) drop table...

try using CASE statement in UPDATE clause

what error do you see in eventlog?

You can directly create a SQL job to take backup on a remote share and restore them locally without using SSIS package. You have to write dynamic query to add...

take a log backup of primary db before going for shrinking.

are you running the queries in SSMS of a different server?

Make sure you add 5022 port in firewall exception on both the nodes.

You can check either SQL error log or Windows Event log for errors.

write t-sql code to check the number of active user connections and kill those exceeding a certain number. You can embed this code in a sql job and schedule it...

save it as a SSIS package and use data conversion transformation to convert it to relevant datatype.

Y don't u just import the data from S1 to S2...:-P