thanks for your update today my confusion is cleared

but this will play important role in automatic failover right

i have another question PARTNER TIMEOUT how much to set for automatic fail over for 250 gb database

automatic failover occured means principal database go to mirror and mirror database come to principal iam asking how much time take for mirror comes to principal my db size...

am asking automatic failover occurred due to network failure means how much time mirror as a principal .

thanks for all updates

The Windows account under which the agent runs is used when it makes connections to the Distributor. This account must:

At minimum, be a member of the db_owner fixed database role...

mirroring feature available from 2005 before u implement the mirroring and replication same instance or one more instance check the server configuration and capablities of server before u implement and...

check all the size of the table try to archival the old data

check the agent log and replication monitor will help

if u turn in to simple recovery model and shrink log file at the time log chain will break so what u have to do is check all the table...

thank you

collection of updates, fixes, or enhancements to a software program delivered in the form of a single installable package its called as service pack

its simply bug fixing on your version

You want to be a production DBA don't focus on process, in every company process will vary so u focus on technical prospective 😛 it will help as a perfect...