SQL Server Database will no Backup... throws an error!

Am trying to backup a particular CRM Database that is stored in SQL Server 2012. The backup throws an error and the backup fails (see attached log). Any idea anyone? Other databases backup perfectly, just this one does not.

Cheers,
Steve
SQL-Backup-Screen-Capture.jpg
shood4012IT ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DBAduck - Ben MillerPrincipal ConsultantCommented:
The backup did not fail. It indicated that the Backup was successful in the messages. But it did indicate that it encountered an additional file in the FILESTREAM container and would include it. But the backup was successful according to SQL Server.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DBAduck - Ben MillerPrincipal ConsultantCommented:
Does the backup file exist? Can you restore verifyonly or restore filelistonly on the backup file?
0
shood4012IT ManagerAuthor Commented:
Hi Ben, no backup file exists for this particular DB. I initiate backup and within seconds it stops and fails.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

DBAduck - Ben MillerPrincipal ConsultantCommented:
What tool is that in the graphic? If you just issue a BACKUP DATABASE command does it succeed?  Having an unexpected file and the command saying that it is continuing, should still produce a backup file.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
You're using filestream and looks like one of those references just have issues. Try to run a DBCC CHECKDB on the database to check for inconsistences:
DBCC CHECKDB(OldSuppliers)

Open in new window

0
Vitor MontalvãoMSSQL Senior EngineerCommented:
shood4012, is this issue solved or do you need further assistance?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Recommendation to close this question by accepting the above comments as solution.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.