Operating System error 665 on SQL 2008 R2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Operating System error 665 on SQL 2008 R2

Operating System error 665 on SQL 2008 R2

Rate Topic

Display Mode

Topic Options

Author

Message

Grizzly Bear

Posted Tuesday, August 14, 2012 10:28 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 05, 2013 9:07 AM
Points: 46, Visits: 175

I am getting this error : Operating system error 665(The requested operation could not be completed due to a file system limitation) encountered.

Microsoft has this article http://support.microsoft.com/kb/2002606

But that resolves problems for SQL Server 2008 on Windows 2008, but I am encountering this problem on Windows 2008 R2 /SQL Server 2008 R2

Should I still go ahead and apply those patches ?

Anybody has had any experience on it ?

Post #1344860

Steve Jones - SSC Editor

Posted Tuesday, August 14, 2012 10:38 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 3:26 PM
Points: 31,425, Visits: 13,738

I would say no. Talk to MS. Patches are specific to versions and the R2 versions are completely separate versions.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1344871

Lynn Pettis

Posted Tuesday, August 14, 2012 10:53 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 4:34 PM
Points: 21,615, Visits: 27,445

Grizzly Bear (8/14/2012)

First, I agree with Steve.

Second, to make easier for others to see what you were referencing in the MS KB.

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

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1344884

Theo Ekelmans

Posted Tuesday, October 02, 2012 2:43 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, April 09, 2013 10:30 AM
Points: 16, Visits: 302

Hi,

I'm having the same problem as you described, SQL (LARGE snapshot) + win2008R2 sparse files, generating error 665.

Did you ever found a solution for that?

Theo Ekelmans
Ordina.nl
The Netherlands

Post #1366904

« Prev Topic | Next Topic »

Permissions