Yeah I call Complete-BitsTransfer after every file. Still can't figure out why it gives me access denied though on the larger files.

Ok. Thanks I'll give that a try. I did have

throw $error

in there though so I thought that would have done it.

Additionally, most of...

Yes, partially. I'm not able to get it to import the bitstransfer module when running it through a job, so I still need to look at what's going on...

It fails during the file transfer of one of the larger files. There are about 6 files total with three of them being between 10GB and 75GB. Periodically...

Yep I have that listed on my implementation sheet for when we build the production system.

Thanks

Well I figured it out. Apparently it will only fail over once by default within a six hour period. I upped it to three and could fail over...

Thank for the reply Matt-

Both servers are running SQL Server 11.00.3128 and both servers are running the same service pack levels and software updates. I verified this again through...

Thanks for the reply. I guess I'm still having a hard time with it conceptually since something like this:

if object_id('foo') is not null

BEGIN

DROP TABLE FOO;

END

ELSE

PRINT'NOT THERE'

will not fail even...

Thanks for the replies! I finally found that this morning after poking around at some things. Just misleading that it shows AWE (which i interpreted as 32-bit)...

I ran RamMap and it shows AWE using the amount of memory that I have specificed in SQL Server for the max memory setting (60GB). We allocated an additional...

No active open transactions.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Nope

GilaMonster (7/12/2012)

---

If it's a test system then leave it in simple recovery. Have a daily job that sets all DBs to simple recovery. Set it back to full and you'll...

Nicholas Cain (7/12/2012)

---

Probably a silly question, why was the database in full recovery in the first place if you aren't worried about recoverability? And why shrink the log so? It...

Checked that and it returns "NOTHING".

Yep, did...