Great. Thanks for pointing that out.

Hi,

Thanks very much for your reply. What you suggest is essentially what i have done.

I have configured a number of availability groups on Server A and they are pointing...

Can you ping the listener name?

Do you have the following protocols enabled?

> Enable Shared Memory

> Enable Named Pipes

> Enable TCP/IP

Depending on your OS you could open Resource Manager and look on the Network Tab, scroll down to listening ports.

Type resmon.exe into the Start Menu search box and press enter....

Hi Gail,

Thanks for taking the time to examine the output and feedback.

The column is a VARBINARY(MAX). It stores material uploaded by our clients. Video files and other large...

The database can continue to be accessed whilst it is being joined to an availability group. depending on the volume of transaction they will just be applied to the...

I know there is a Cumaltive update planned for MAY. I think it is CU 6.

See Paul Randals post. Very good

http://www.sqlskills.com/blogs/paul/new-script-how-much-of-the-database-has-changed-since-the-last-full-backup/

Hi Gail,

I was wondering if you got my messages this morning? I appreciate you are busy but I just wanted to check. I can see the admins have...

Thanks Gail.

Msg 8964, Level 16, State 1, Line 19

Table error: Object ID 21575115, index ID 1, partition ID 72057594038910976, alloc unit ID 72057594040352768 (type LOB data). The off-row data node...

Hi Gail,

I know you didn't ask me to run it with repair! I tried exactly as you requested and posted the output. Twice. For some reason it...

Thanks for continued support/help. Greatly appreciated.

Further to the above. I have restored a copy of the database on another server and run REPAIR_ALLOW_DATA_LOSS. Before and after running...

Hi Grant and Gail,

Thanks for your replies above. Please see the full output for checkdb below:

Msg 8964, Level 16, State 1, Line 19

Table error: Object ID 21575115, index ID...

Hi Both,

Thanks thus far for your comments. I've found the table name and it is pretty much all LOB data. Please find the output from CHECKDB below.

Msg 8964,...

You can't switch off logging it is a fundamental part of SQL Server.

What is the ratio of records you want to keep? Maybe you could store those records in...