You have to remember that the user that needs access to the folder where the backup resides (and where you restore the backup, if using WITH MOVE explicitly) is the SQL As such, the SQL Server installer only grants permissions to the folders the SQL Server setup creates. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? VinayVinay Thakur http://rdbmsexperts.com/Blogs http://vinay-thakur.spaces.live.com/ http://twitter.com/ThakurVinay Marked as answer by Tom Li - MSFTModerator Monday, June 21, 2010 1:51 AM Tuesday, June 15, 2010 2:53 PM Reply | Quote 0 Sign in

Restore Headeronly Is Terminating Abnormally Error 3241

Was the term "Quadrant" invented for Star Trek If a character is stunned but still has attacks remaining, can they still make those attacks? You could try running the restore process with the application running in "Administrator Mode" (right-click run as administrator)... The problem was however in insufficient rights.

select sql server (mssqlserver) and then click properties and then log on. Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally.please i need help sir, i hope this issues ….Reply madhivanan June 18, 2012 11:56 amYou need to read It can be fixed in windows 7 by selecting the property of the backup file and clicking the unblock button in it. Microsoft Sql Server Error 3201 It was throwing bcp error again and again.

Operating system error 5(failed to retrieve text for this error. Random noise based on seed How is being able to break into any Linux machine through grub2 secure? siddhai12 5-Jul-11 9:02am will u pls attached that backup file ? his comment is here Not the answer you're looking for?

Browse other questions tagged sql-server sql-server-2008-r2 or ask your own question. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Out of 23 database only one database backup is giving me same error. Operating system error 5: "5(Access is denied.)".

Mohammad Mohsin Reza 202 visualizações 5:33 SQL Server DBA Tutorial 125-How to Get the Detail of a Job Failure in SQL Server - Duração: 11:22. Found the below link to enter the credentials: http://stackoverflow.com/questions/4258716/ssis-accessing-a-network-drive-using-a-different-username-and-passoword/29155389#29155389 It worked out and now my backups are directly being copied on the network drive !Hope this helps someone in the near Carregando... for more information see here: http://dbathings.com/troubleshoot-microsoft-sql-server-error-code-3241/ share|improve this answer edited Sep 17 at 16:23 Jason Clark 426222 answered Apr 16 '12 at 5:25 Deepak 8111 add a comment| up vote 1

Had struggled for 2 hours and then finally found out the mistake that I was just creating the folder in the client side rather than server side. Perhaps ommit the extra space in your backup statement? All other databases were backing up as expected. It was easy to solve as it has access word in the error.Reply urango June 12, 2015 8:59 amUnable to open the physical file "d:\sql_files\ctbse.mdf".