if i select 'All statistics' then should Index job run first and then update statistics? And how often should update statistic on large DB?

Thank you guys. One more question: Should update statistics job run first or Index rebuild job? Is it OK to use maintenance plan to run update statistic with column only?...

Thanks for the reply, one thing, will Agent job fail? or it run normally but shows on 'view history' (when I go thru all) that something is corrupted?

Thank for your quick reply. Would you please tell me what is the 'baseline' here. Should I update old statistics older than month or so? or..

Yes. [SQL\SVC] is running both sql services on principle and mirror server. So should I 'Grant' using below script?

GRANT CONNECT ON Endpoint::db_mirroring TO [SQL\SVC] OR Sql automatically assigns [SQL\SVC] for...

Thank you so much for your time. Lastly, Just wanted to confirm with you couple things.

1. Since I already have service account [SQL\SVC] created I DO NOT need this below...

Thank you guys.

I already have a service account created in Logins: SQL\SVC.

---CREATE ENDPOINT <endpoint_mirroring>

STATE = STARTED

AS TCP ( LISTENER_PORT = 7023 )

FOR DATABASE_MIRRORING (ROLE=PARTNER)-----

If I run above script, I think, ...

Here is another one:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=168004

Yes I did. And got error. see below.

http://blogs.msdn.com/b/sqlserverfaq/archive/2009/03/31/setting-up-database-mirroring-in-sql-server-2008-using-t-sql-when-the-database-is-encrypted-using-transparent-data-encryption.aspx

Where do I put service account name and how?

CREATE ENDPOINT <endpoint_mirroring>

STATE = STARTED

AS TCP...

Hello GilaMonster,

it won't help for backup, restore, DBCC CHECKDB, Rebuild Index job?

For the performance reason. they want to partition 2 big table. Should I just create different file group and put it to different LUN? will that help for backup and...

Lynn Pettis, Thank you for your valuable inputes

Anyone please?

Thank you SQLRNNR. sorry, I am trying to explain better way:

There is a log file 100 GB. New transaction occurs and it shows 125 GB log file backup on...