Device Error Or Device Offline Sql Server 2000
Contents |
360 games PC games
Device Activation Error Sql Server 2000
Windows games Windows phone games Entertainment All Entertainment sql server 2000 take database offline Movies & TV Music Business & Education Business Students & educators cannot open backup device operating system error 3 Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Cannot Open Backup Device Operating System Error 2
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 5 Failed To Retrieve
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 Stack Overflow sql 2012 backup to network share the company Business Learn more about hiring developers or posting ads with us Stack
Sql Server Cannot Open Backup Device Operating System Error 2
Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of backup sql database to network drive 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 favorite SQL Server 2000 https://support.microsoft.com/en-us/kb/207187 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 shows this message: BackupDiskFile::CreateMedia: Backup http://stackoverflow.com/questions/443432/sql-server-2000-backup-directly-to-a-separate-server 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 restore dilemmas share|improve this answer answered Jan 14 '09 at 15:55 Ad
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Backups » Backup error: Device error or device offline... Backup error: Device error or http://www.sqlservercentral.com/Forums/Topic150879-24-1.aspx device offline Rate Topic Display Mode Topic Options Author Message LissaLissa Posted Tuesday, December 14, 2004 2:24 AM Forum Newbie Group: General Forum Members Last Login: Monday, December 20, 2004 6:43 PM Points: 1, Visits: 1 Hi! I am trying to backup our database from the main server to a test server. But everytime I tried to do so, the error: Device error or device offline appears. When I tried accessing the destination from the main server using sql server the Run command, I am allowed to access the said location (e.g. \\test_server\e$\backup). What should I do then? What do I need to check for the backup to be successful? Please help me out. Thanks. Post #150879 SQLBillSQLBill Posted Tuesday, December 14, 2004 7:08 AM Hall of Fame Group: General Forum Members Last Login: Yesterday @ 1:55 PM Points: 3,408, Visits: 979 You are backing up over a network. Does the SQL Server services (MSSQLServer and SQLServerAgent) cannot open backup run as domain accounts? Do those accounts have permission to access the destination?-SQLBill Post #150924 magasvsmagasvs Posted Tuesday, December 14, 2004 10:13 AM Ten Centuries Group: General Forum Members Last Login: Sunday, June 19, 2016 3:32 PM Points: 1,271, Visits: 752 The best way is to backup to a local disk and then copy or move backup to the network share (as the second step of the job, for example). Post #150988 Rudyx - the DoctorRudyx - the Doctor Posted Wednesday, December 15, 2004 1:57 PM Hall of Fame Group: General Forum Members Last Login: Saturday, September 24, 2016 9:57 AM Points: 3,243, Visits: 2,465 Usually backing up over a network toa disk on another machine is a big no-no. However Microsoft left a hole in things to accomplish just that (if you have faith in the throughput and stability of your network).First:exec sp_addumpdevice 'disk','model_dump_device', '\\test_server\e$\backup\model.bak', '2'Second:backup database model to model_dump_deviceThis assumes that all the required permissions/authorities exist between the 2 servers and the account executing the actual command. In this example, since there is an administrative share, the user executing the command must have 'local administrator' rights on the target machine. RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus." Post #151273 « Prev Topic | Next Topic » Permissions You cannot post new topics. You cannot post topic replies. You cannot post new polls. You cannot post replies to