PDA

View Full Version : مشکل در backup گرفتن از دیتابیس دارای filestream



baran110
شنبه 25 آبان 1392, 09:53 صبح
با سلام و عرض خدا قوت
دیتابیسی دارم که فایل هاس اسکن را در فایل استریم ذخیره میکند. backup اطلاعات نیز روزانه گرفته می شود.تا چند روز پیش مشکلی در گرفتن backup وجود نداشت اما ناگاه با مشکل روبرو شدیم. خطای مورد نظر نیز به شکل زیر است. روی دیتابیس dbcc checkDB را هم run کردم و نتیجه آن به صورت زیر بود . در صورت امکان راهنمایی نمایید که چه اقدامی برای مرتفع کردن مشکل می توان انجام داد. در ضمن چون اطلاعات موجود برایم از اهمیت بسیار بالایی برخوردار است می خواهم تا حد امکان از دست رفتن اطلاعات را نداشته باشم.

Msg 3634, Level 16,
State 1, Line 1
The operating system
returned the error '1392(failed to retrieve text for
this error. Reason: 15105)' while attempting
'FindNextFile' on
'D:\ScanFiles\ScanHISFilestream\1a6c1cbe-e65b-489c-8f8a-3c38c176e4a6\0596e344-e892-48d7-9fd8-a43c70638410'.
DBCC results for 'ScanHISDB'.
Warning: Could not complete filestream
consistency checks due to an operating system error. Any
consistency errors found in the filestream subsystem will be
silenced. Please refer to other errors for more
information. This condition is likely transient; try
rerunning the command.
Service Broker Msg 9675, State 1: Message Types
analyzed: 14.
Service Broker Msg 9676, State 1: Service
Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services
analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues
analyzed: 3.
Service Broker Msg 9669, State 1: Conversation
Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation
Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service
Bindings analyzed: 0.
Service Broker Msg 9605, State 1: Conversation
Priorities analyzed: 0.
DBCC results for
'sys.sysrscols'.
There are 665 rows in 9 pages for object
"sys.sysrscols".
DBCC results for
'sys.sysrowsets'.
There are 95 rows in 1 pages for object
"sys.sysrowsets".
DBCC results for
'sys.sysallocunits'.
There are 110 rows in 2 pages for object
"sys.sysallocunits".
DBCC results for
'sys.sysfiles1'.
There are 2 rows in 1 pages for object
"sys.sysfiles1".
DBCC results for
'sys.syspriorities'.
There are 0 rows in 0 pages for object
"sys.syspriorities".
DBCC results for
'sys.sysfgfrag'.
There are 2 rows in 1 pages for object
"sys.sysfgfrag".
DBCC results for
'sys.sysphfg'.
There are 2 rows in 1 pages for object
"sys.sysphfg".
DBCC results for
'sys.sysprufiles'.
There are 3 rows in 1 pages for object
"sys.sysprufiles".
DBCC results for
'sys.sysftinds'.
There are 0 rows in 0 pages for object
"sys.sysftinds".
DBCC results for
'sys.sysowners'.
There are 22 rows in 1 pages for object
"sys.sysowners".
DBCC results for
'sys.sysprivs'.
There are 152 rows in 1 pages for object
"sys.sysprivs".
DBCC results for
'sys.sysschobjs'.
There are 82 rows in 1 pages for object
"sys.sysschobjs".
DBCC results for
'sys.syscolpars'.
There are 638 rows in 12 pages for object
"sys.syscolpars".
DBCC results for
'sys.sysnsobjs'.
There are 1 rows in 1 pages for object
"sys.sysnsobjs".
DBCC results for
'sys.syscerts'.
There are 0 rows in 0 pages for object
"sys.syscerts".
DBCC results for
'sys.sysxprops'.
There are 9 rows in 1 pages for object
"sys.sysxprops".
DBCC results for
'sys.sysscalartypes'.
There are 34 rows in 1 pages for object
"sys.sysscalartypes".
DBCC results for
'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object
"sys.systypedsubobjs".
DBCC results for
'sys.sysidxstats'.
There are 193 rows in 3 pages for object
"sys.sysidxstats".
DBCC results for
'sys.sysiscols'.
There are 346 rows in 2 pages for object
"sys.sysiscols".
DBCC results for
'sys.sysbinobjs'.
There are 23 rows in 1 pages for object
"sys.sysbinobjs".
DBCC results for
'sys.sysaudacts'.
There are 0 rows in 0 pages for object
"sys.sysaudacts".
DBCC results for
'sys.sysobjvalues'.
There are 216 rows in 40 pages for object
"sys.sysobjvalues".
DBCC results for
'sys.sysclsobjs'.
There are 17 rows in 1 pages for object
"sys.sysclsobjs".
DBCC results for
'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object
"sys.sysrowsetrefs".
DBCC results for
'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object
"sys.sysremsvcbinds".
DBCC results for
'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object
"sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object
"sys.sysrts".
DBCC results for
'sys.sysconvgroup'.
There are 0 rows in 0 pages for object
"sys.sysconvgroup".
DBCC results for
'sys.sysdesend'.
There are 0 rows in 0 pages for object
"sys.sysdesend".
DBCC results for
'sys.sysdercv'.
There are 0 rows in 0 pages for object
"sys.sysdercv".
DBCC results for
'sys.syssingleobjrefs'.
There are 157 rows in 1 pages for object
"sys.syssingleobjrefs".
DBCC results for
'sys.sysmultiobjrefs'.
There are 249 rows in 1 pages for object
"sys.sysmultiobjrefs".
DBCC results for
'sys.sysguidrefs'.
There are 1 rows in 1 pages for object
"sys.sysguidrefs".
DBCC results for
'sys.syscompfragments'.
There are 0 rows in 0 pages for object
"sys.syscompfragments".
DBCC results for
'sys.sysftstops'.
There are 0 rows in 0 pages for object
"sys.sysftstops".
DBCC results for
'sys.sysqnames'.
There are 97 rows in 1 pages for object
"sys.sysqnames".
DBCC results for
'sys.sysxmlcomponent'.
There are 99 rows in 1 pages for object
"sys.sysxmlcomponent".
DBCC results for
'sys.sysxmlfacet'.
There are 112 rows in 1 pages for object
"sys.sysxmlfacet".
DBCC results for
'sys.sysxmlplacement'.
There are 18 rows in 1 pages for object
"sys.sysxmlplacement".
DBCC results for
'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object
"sys.sysobjkeycrypts".
DBCC results for
'sys.sysasymkeys'.
There are 0 rows in 0 pages for object
"sys.sysasymkeys".
DBCC results for
'sys.syssqlguides'.
There are 0 rows in 0 pages for object
"sys.syssqlguides".
DBCC results for
'sys.sysbinsubobjs'.
There are 3 rows in 1 pages for object
"sys.sysbinsubobjs".
DBCC results for
'sys.syssoftobjrefs'.
There are 24 rows in 1 pages for object
"sys.syssoftobjrefs".
DBCC results for
'BimarDocScans'.
There are 42395 rows in 1266 pages for object
"BimarDocScans".
DBCC results for
'BimarScanImageItems'.
There are 673251 rows in 15991 pages for object
"BimarScanImageItems".
DBCC results for
'sysdiagrams'.
There are 1 rows in 1 pages for object
"sysdiagrams".
DBCC results for
'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object
"sys.queue_messages_1977058079".
DBCC results for
'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object
"sys.queue_messages_2009058193".
DBCC results for
'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object
"sys.queue_messages_2041058307".
DBCC results for
'sys.filestream_tombstone_2073058421'.
There are 245388 rows in 5677 pages for object
"sys.filestream_tombstone_2073058421".
DBCC results for
'sys.syscommittab'.
There are 0 rows in 0 pages for object
"sys.syscommittab".
CHECKDB found 0 allocation errors and 0
consistency errors in database
'ScanHISDB'.
DBCC execution completed. If DBCC printed error
messages, contact your system
administrator

با سپاس از توجه شما

arshpisheh
شنبه 25 آبان 1392, 12:41 عصر
سلام دوست عزیز
متن خطای شما را دیدم
فکر میکنم اگه با CHECK DB مشکلتون حل نشده بهتره CHECK Disck انجام بدید.


موفق باشید

baran110
شنبه 25 آبان 1392, 13:54 عصر
دوست عزیزم
ممنون از راهنمایی شما.
مشکل حل شد.