try taking a log backup of the primary, then apply that to the mirror with norecovery. Then try to initiate mirroring.

On those sizes I would say you are safe to set the log to unrestricted growth, set growth to 1GB, backup the log, run the reindex, let the log grow,...

How much free space have you got on the drive that you can afford to be used by the log file?

Whats the size and space used in the data file?

you may want to go back to a point before your last full backup, so you would then need logs from before that backup.

you can restore logs and the leave...

there are a number of options, you may have to experiment to see what works best for you.

Just increase the log file to a size that can handle the reindex....

definitely get rid of one of the log files after the restore, having two is of no use at all.

And as perry said, 1 terrabyte log, wow!

And you are going...

have you explicitly granted the domain account execute on xp_create_subdir in the master database?

don't think this has been mentioned....

check the permissions that the SQL server service account has on the files themselves (right click file, properties, security)

Marios Philippopoulos (9/22/2011)

---

The history log of the failure is not very helpful:

Message

Executed as user: xxxx\xxxx. ..._Content', file 'xxxx' on file 1. [SQLSTATE 01000] (Message 4035) Processed 68...

thats a darn good question and I don't know why its been made harder to find out something important such as why a backup failed, all the info should be...

or try the registry via xp_regread and there are other options as well

http://support.microsoft.com/default.aspx?scid=kb;en-us;321185#3

not within SQL but there is this

and when you do resize it, shrink it right down and manually grow it in 8GB chunks to get sensible sized VLFs.

presuming here you will need a reasonably large log...

smecharrafie (9/22/2011)

---

it was Gone From SSAS ie. no longer under the Databases node (it was the only db under the databases node)

Note that currently I have 2 sets of files...

SSAS I was responsible for, Qlikview I'm not, less work for me! 😉

Users decision to move to Qlikview, so they must prefer it.