April 8, 2014 at 8:09 am
I got error as belwo
Description: x:\MSSQL\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\tData.mdf Operating system error 665(The requested operation could not be completed due to a file system limitation) encountered.
How to reslove this?
April 8, 2014 at 8:37 am
ramyours2003 (4/8/2014)
I got error as belwoDescription: x:\MSSQL\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\tData.mdf Operating system error 665(The requested operation could not be completed due to a file system limitation) encountered.
How to reslove this?
You should keep in mind that we don't have any context to what you post. Just stating you got an error doesn't offer much help. This is like telling the car mechanic "my car has a problem, here are the keys".
What are you doing when you encounter this error? Have you tried binoogling the error message? It seems that frequently this happens because the disc is highly fragmented.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 8, 2014 at 9:42 am
Thanks for repling , actually iam not aware how to trouble shoot this issue ?
April 8, 2014 at 9:53 am
ramyours2003 (4/8/2014)
Thanks for repling , actually iam not aware how to trouble shoot this issue ?
Start by reading my response. Then telling us where this message is coming from.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 8, 2014 at 10:58 am
What is the "requested operation" that you're trying to do?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply