Cannot Open Backup Device Device Error Or Device Off-line
Contents |
360 games PC games cannot open backup device error 3 Windows games Windows phone games Entertainment All Entertainment
Cannot Open Backup Device Operating System Error 5(access Is Denied.) Sql Server
Movies & TV Music Business & Education Business Students & educators
Cannot Open Backup Device Operating System Error 32
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Cannot Open Backup Device Operating System Error 3
Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All cannot open backup device operating system error 2 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about cannot open backup device operating system error 5 failed to retrieve Stack Overflow the company Business Learn more about hiring developers or posting ads with sql server cannot open backup device operating system error 2 us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is sql 2012 backup to network share a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up sql server 2000 backup directly to a separate server up vote 1 down vote https://support.microsoft.com/en-us/kb/207187 favorite SQL Server 2000 on Windows Server 2003. I am trying to run a backup, from within EM, directly over to another server, as follows: backup database AbraEmployeeSelfService to disk = '\\servername\f$\Backup\myDB_backup.bak' I get this error: Cannot open backup device '\\servername\f$\Backup\myDB_backup.bak'. Device error or device off-line. See the SQL Server error log for more details. Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally. The error log http://stackoverflow.com/questions/443432/sql-server-2000-backup-directly-to-a-separate-server shows this message: BackupDiskFile::CreateMedia: Backup device '\\servername\f$\Backup\myDB_backup.bak' failed to create. Operating system error = 5(Access is denied.). I am running the command using a windows login that has full rights on the destination path. At least, from my desktop I can open a run window, enter \\servername\f$\Backup, and in the resulting Explorer window I can add/edit/delete files in that directory. What do I need to do to get past that access denial? sql-server-2000 backup share|improve this question edited Jan 14 '09 at 16:27 asked Jan 14 '09 at 15:49 Oliver 453618 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote accepted What user account is the MSSQLSERVER service running under? I believe LocalSystem is restricted and cannot access remote resources. share|improve this answer answered Jan 14 '09 at 15:53 hunterjrj 6541516 add a comment| up vote 1 down vote I'm not sure if SO is escaping your destination, but it should read: '\\servername\f$\Backup\myDB_backup.bak' (There's two \'s prefixing the server name) SQL Server will attempt connecting to this network share as the user that SQL Server's service is running as. You might need to run SQL Server as another account that matches an account with priveleges to that destination. Troubleshooting SQL Server backup and resto
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server http://www.sqlservercentral.com/Forums/Topic1161873-1550-1.aspx 2008 » SQL Server 2008 Administration » Database Backup Issue 11 posts,Page 1 https://sqlbackupandftp.com/forum/yaf_postst425_Backing-Up-SQL-2000.aspx of 212»» Database Backup Issue Rate Topic Display Mode Topic Options Author Message Ronnie JonesRonnie Jones Posted Thursday, August 18, 2011 9:39 AM SSC-Enthusiastic Group: General Forum Members Last Login: Thursday, August 25, 2016 3:40 PM Points: 153, Visits: 291 Hello All,I'm running SQL 2008 R2. I have an intermediate cannot open issue with my backup for this one database. Some days the backup completes successfully with no problem and other days - could be 3 or 4 in a row - the backup fails with the following error:Executed as user: NT AUTHORITY\SYSTEM. Cannot open backup device 'F:\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\SMS.BAK'. Operating system error 32(The process cannot access the file because it is being used by another cannot open backup process.). [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.The command used to backup the database is:BACKUP DATABASE [SMS] TO DISK = N'F:\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\SMS.BAK' WITH NOFORMAT, INIT, NAME = N'SMS- Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10GOIs there any way to determine what that process is that is preventing the backup from occurring? Or are there any suggestions on how I can ensure that the backup device isn't causing an issue with the backup?Let me know if you have any questions.Thanks in advance for your help.Ronnie Post #1161873 Ray MondRay Mond Posted Thursday, August 18, 2011 8:12 PM Old Hand Group: General Forum Members Last Login: Tuesday, August 9, 2016 11:50 PM Points: 345, Visits: 1,542 You could use Process Explorer from Sysinternals to find out which application is using that backup file. Or you could use the command line application 'handle.exe' (also from Sysinternals). Ray MondGet a SQL Size 2.0 single-instance license for FREEClaim one here! Post #1162211 Ronnie JonesRonnie Jones Posted Monday, August 22, 2011 7:49 AM SSC-Enthusiastic Group: General Forum Members Last Login: Thursday, August 25, 2016
SQL) » How does SqlBackupAndFTP work » Backing Up SQL 2000 Backing Up SQL 2000 Options · View Previous Topic · Next Topic NuNn DaDdY #1 Posted : Friday, January 6, 2012 10:51:49 AM Rank: MemberGroups: Registered Joined: 1/6/2012Posts: 15Location: Michigan Hello,We recently installed SQL Backup and FTP on our SQL 2008 server and have the database backups working properly. I just attempted to preform a back up the SQL 2000 server located on our network and received the following error:ERROR: Backup of Attendance failed: Cannot open backup device '\\our-network-share\OurDatabase201201061132.bak'. Device error or device off-line. See the SQL Server error log for more details.BACKUP DATABASE is terminating abnormally.Taking a look at the Event Log on the SQL Server I find the following entry:"Operating system error = 5(Access is denied)."I see on the home page that under the compatibility list there is "SQL Server 2000 (only local backups, not remote)". I'm guessing that this is probably what I'm encountering since I'm attempting to preform the backup of the SQL 2000 server databases from the SQL 2008 machine. If this is the case, would I be better off moving the installing of SQL Back Up and FTP from the SQL 2008 machine to the SQL 2000 machine and then handling the backups operations from there. However, if this error isn't related to a SQL version compatibility isuue, then I'll look into ensuring my user rights are properly set. Version InformationBoth servers - Windows Server 2003SQLBackupandFTP - 6.4.3.30062Thank you very much for your help. Have a great day.Best Regards,Corey Back to top Report Abusive | Report SPAM | Edit by user: Friday, January 6, 2012 10:55 AM | Reason: Not specified User ProfileHide User Posts ruslan #2 Posted : Monday, January 9, 2012 10:29:08 AM Rank: AdministrationGroups: Administrators, RegisteredJoined: 8/10/2009Posts: 428 Dear Corey,The simplest is just to install SBF on the SQL Server 2000 directly and run it from there. In the latest (6.4) version you can run it from a different server on the