restoring an 80GIG DB

[jaylou]

Hi All,
I am having an issue restoring an 80GIG database. it gets about 3/4 of the way thru before choking. I moved the BU file from my Production server to the Dev server I am rebuilding. I am getting an error I never saw before:
"Nonrecoverable I/O error occurred on file '???'.
RESTORE DATABASE is terminating adnormally."
The SQL logs shows the following:
"BackupIoRequest::WaitForIoCompletion: write failure on backup device ''. Operating system error 33(The process cannot access the file because another process has locked a portion of the file.)."
"Internal I/O request 0x19DBE328: Op: WriteDatabaseScattered, pBuffer: 0x065B0000, Size: 65536, PageNumber: 0:0, UMS: Internal: 0x0, InternalHigh: 0x10000, Offset: 0x21A1A00, OffsetHigh: 0xB, m_buf: 0x065B0000, m_len: 65536, m_actualBytes: 0, m_errcode: 33, File: n/a"

Concidering I have copied the file locally, I can't figure out why the file would be locked.

Any help would be greatly appreciated.
Thanks,
Joe

 

[mrdenny]

Mabey an anti-virus software is trying to scan the file?

Try rebooting the dev server and then restoring the database.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLBill]

You are having trouble restoring. You don't say how you copied/backed up the database originally. There are seven ways (that I know of) to backup/copy database files.

1. Use SQL Server backup commands
2. SQL Server Maintenance plans
3. Detach the database and copy the .mdf/.ldf files
4. Stop the MSSQLServer service and copy the .mdf/.ldf files
5. use a third party backup product that has a SQL agent
6. just copy the .mdf/.ldf files while the database is in use
7. use some other backup software without a SQL agent and backup the .mdf/.ldf while the database is in use.

1, 2, 3, 4, and 5 are good methods and will work.

6 and 7 will result in unrestorable files.

Which method did you use?

-SQLBill

Posting advice: FAQ481-4875