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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup problem with sql2000

Status
Not open for further replies.

karbon

Programmer
Dec 4, 2003
29
TR
Hello everyone!

I have a database Backup problem
with Win2003 OS + SQLServer 2000
Any Ideas? memory problem or what ?
:((

2003-12-04 13:51:46.68 spid107 BackupMedium::ReportIoError: write failure on backup device 'D:\Winner\Backup\ipek_muh2003'. Operating system error 2(error not found).


2003-12-04 13:51:46.68 spid107 Internal I/O request 0x5645F400: Op: Write, pBuffer: 0x04340000, Size: 512, Position: 512, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0x200, OffsetHigh: 0x0, m_buf: 0x04340000, m_len: 512, m_actualBytes: 0, m_errcode: 2, BackupFile: D:\Winner\Backup\ipek.bck
2003-12-04 13:51:46.68 backup BACKUP failed to complete

the command

BACKUP DATABASE [ipek] TO DISK = N'D:\Winner\Backup\ipek.bck' WITH NOINIT , NOUNLOAD , NAME = N'ipek_muh2003 backup', NOSKIP , STATS = 10, NOFORMAT




 

thanks SQLBill but it is not related with STATS.
I found the problem.
in SQL logs it was saying

Operating system error 2(error not found).
I found that error 2= (c:\net helpsmsg 2 = 'The system c
cannot find the file specified')....

But i wasn't try to find any file. I tried to write my
N'D:\Winner\Backup\ipek.bck' file.

I checked my D: disk's security. it was Everyone(full cont.) And i add mycomputer\administrators to the accounts.

Now there is no problem.

thanks

Less BUGS for everyone!!!


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top