yeah sure .Thanks a lot Ricky.

Refer this https://www.mssqltips.com/sqlservertip/2301/step-by-step-sql-server-log-shipping/

and test it in UAT environment and note down the time taken. Then you consider the used timeframe

in Production environment.

You can modify the steps mentioned in the below url based on your need for asynchronous mirroring session.

http://www.mssqltips.com/sqlservertip/2701/steps-to-apply-a-service-pack-or-patch-to-mirrored-sql-server-databases/

Include following script in 'Execute SQL task ' of SSIS to get your output.

IF (SELECT count(column_name) FROM tablename) <= 0

BEGIN

PRINT 'No email received:'

END

ELSE

...

1.Write the backup script for each and every databases and name it as backupalldbs.sql

(use excel to get the databases list from sys.databases tables on one column to link with backup...

When your server is rebooted lastly?

Please ensure server should be rebooted after any .net updates or hotfixes.

Refer the summarized features over here.!

http://sqldbatask.blogspot.com/2013/12/sql-server-upgrade-sql2012-features.html

Hope this helps..!

http://mssqlfun.com/2013/01/29/sql-server-silent-unattended-installation-using-configuration-file/

Based on my understanding,Microsoft assessment and planning tool will help to get the load and all details for each and every server.Is it right?

Yes,,Thanks for the help..i will check the loads and requirements of the databases and inventory details on the servers.

Grant Fritchey (12/17/2013)

---

I have to ask, how, possibly, from a listing of servers could I tell you which of the databases on those servers would need mirroring?

I'm Collecting those...

Here is the script that i found ..

http://www.nilkanth.com/2004/07/18/sql-jobs-auto-backup/

Then put this script in a job and schedule it to receive the output .

I guess the user has some other permissions more than SqlAgentReaderrole...Can you double check it?

Refer the below url to 'Make Schema Changes on Publication Databases.'

http://technet.microsoft.com/en-us/library/ms151870.aspx

Dear friend,

Check the following path

C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\Summary.txt

then find the failure information.