thanks for the response, good idea disabling maintenance tasks for the database. Thanks.

🙂

Just looking at using Zerto, as its disk block level based it concerns me a little.

How does Zerto manage ACID properties?

What does it do to remain Transactionally consistent ?

roworthm (3/9/2015)

---

cookie SQL (3/9/2015)

---

I would look at the active portions of the log 'DBCC LogInfo' , check that its viable to shrink or it will just fail.

The other thing not...

I would look at the active portions of the log 'DBCC LogInfo' , check that its viable to shrink or it will just fail.

The other thing not mentioned or in...

thanks for all the responses guys, after reading Jacks post a "lightbulb" appeared.

The culprit was :

A domain users group had been added using british english, as all users are in...

Thanks, I agree with your comments.

I Still would like to understand whats going on with the cast though.

Hopefully sorted, the error seems the wrong way around. It was occuring because CLR was disabled on the SQL server (which it is by default)

select OBJECT_NAME(c.object_id)as [objectname], c.name as [column], t.name as [Typename], c.max_length

from sys.columns as c

join sys.types as t ON (c.user_type_id = t.user_type_id)

looks alright in sys tables, i'll steer clear of that stored...

I had same issue and found a problem where the temp and TMP were pointing to a different place to normal...

make sure site can access you temp folders

http://support.microsoft.com/kb/825791

Just looking for a similar solution to this... basically i need to append a row to all the outputed lines from the DBCC command. Can this be done in...