Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot backup databases in SQL7

Status
Not open for further replies.

unit512

MIS
Mar 12, 1999
233
US
Everytime I try to backup my databases through enterprise manager, I get a error stating that the backup device (drive f:) cannot be opened.<br><br>The errorlog shows:<br>2000-05-08 13:16:57.46 spid7&nbsp;&nbsp;&nbsp;&nbsp;Using 'xpstar.dll' version '1998.11.13' to execute extended stored procedure 'sp_MSgetversion'.<br>2000-05-08 13:25:11.30 kernel&nbsp;&nbsp;&nbsp;BackupVirtualDeviceSet::Initialize: Open failure on backup device 'DBASQL70TID266VD0'. Operating system error -2147024891(Access is denied.).<br>2000-05-08 13:32:09.55 kernel&nbsp;&nbsp;&nbsp;BackupDiskFile::CreateMedia: Backup device 'f:\program files\mssql7\data\BACKUP\' failed to create. Operating system error = 3(The system cannot find the path specified.).<br>2000-05-08 13:32:32.86 kernel&nbsp;&nbsp;&nbsp;BackupDiskFile::CreateMedia: Backup device 'f:\temp' failed to create. Operating system error = 5(Access is denied.).<br>2000-05-08 13:32:44.47 kernel&nbsp;&nbsp;&nbsp;BackupVirtualDeviceSet::Initialize: Open failure on backup device 'DBASQL70TID656VD0'. Operating system error -2147024891(Access is denied.).<br>2000-05-08 13:33:46.60 kernel&nbsp;&nbsp;&nbsp;BackupDiskFile::CreateMedia: Backup device 'f:\program files\mssql7\data\BACKUP\' failed to create. Operating system error = 3(The system cannot find the path specified.).<br><br>Can anyone offer a solution?<br><br>Glenn
 
Is f: a network drive? if you look at the error log posted you have access denied errors. Check permissions on the files/directories you are trying to write to. <p>Cal<br><a href=mailto: > </a><br><a href= > </a><br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top