Blog
Projects
About
Backtrack:
Blog
›
Error 665 (filesystem limitati…
›
Comments
Comments
Error 665 (filesystem limitation) during certain operations (backup, dbcc) on SQL Server
posted on May 19th 2015, at 16:07
by
lunarg
When attempting to run an online integrity check, or a backup on a large database (i.e. large data files), you may run into this error:
Error: 5123, Severity: 16, State: 1.CREATE FILE encountered operating system error 665(failed to retrieve text for this error. Reason: 15105) while attempting to open or create the physical file 'D:\MSSQL\Data\db.mdf:MSSQL_DBCC9'.
Further investigation reveals that the error 665 is in fact: The requested operation could not be completed due to a file system limitation.
Backup and consistency (dbcc) check operations requires the creation of a database snapshot. These snapshots are created as sparse files, which only works on NTFS (not ReFS), but has some l
...
read more
Add a new comment
Your name:
Your e-mail:
Your comment:
Basic BBcode is supported.
Captcha:
Type the letters and numbers as shown.
Not readable?
Get another
.
Tags
computer
windows
software
vmware
microsoft
exchange
linux
hardware
network
news
mac
home
powershell
office365
msoffice
server
sqlserver
ad
dell
soaring
internet
esx
sbs
rds
events
mssql
terminalserver
powercli
hp
virtualization
Archive
«
‹
March 2024
›
»
Sun
Mon
Tue
Wed
Thu
Fri
Sat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Links
-
@harkx
-
Cats & Dogs
-
Jargon-free Security Guide
Quote
«
Safety is not a coincidence.
»
Contact
© 2009-2024 Black Manticore – all rights reserved
code by
lunarg
, design by
SuriAmanah
, hosted at Cats&Dogs