Cant create database (.bak) file..
-
we have a system for banking with sql 2014 database.. i really dont know what really happened,, but suddenly we cant generate a backup .bak file of our banking transactions..
i found out that while the process of generating the backup file.. the .bak file appears.. but when the process is finished.. the .bak file disappears.. help me 🙁
-
We'll need a bit more information than that. Error messages, for example. What SQL are you running to create the backup?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
What do you see in the SQL Server Error Log?
😎
EXEC sp_readerrorlog; -
failed : 23 data error (cyclic redundancy check)
-
daielyko129316 (11/28/2016)
failed : 23 data error (cyclic redundancy check)Can you please check your IO subsystems log files, Windows Event Logs and any other applicable log files for error entries!
😎
Further, run this command and post the full and unedited output:
DBCC CheckDB ('DATABASE_NAME') WITH NO_INFOMSGS, ALL_ERRORMSGS; -
Do you have a DBA there?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
This was removed by the editor as SPAM
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply