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...

Hello Mr. Gila,

Can you please help me to understand this scenario:

Log file size right now 100 GB

Big translation took place, size of 125 GB.

would the Log file size be 100+125...

The Log file space use always 99% free, so what's the point keeping same size?

Yes it does, some time Transaction log file (backup from Log shipping) is 100+ GB,...

Thank you guys for your time and input.

Sorry guys for late response. Not sure what is this table created for . I have scripted out:

CREATE TABLE [dbo].[ABCD](

[A] [uniqueidentifier] NULL,

[uniqueidentifier] NULL,

[C] [nvarchar](100) NULL,

[D] [nvarchar](max) NULL,

[E] [nvarchar](max) NULL,

[F]...