February 5, 2010 at 1:51 am
On one of my SQL Servers 2000 setups I'm performing backups of my databases to an other SQL Server.
On this other one the backups taken are restored into a standby database.
What I now get during restore is the following error:
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17055
Description:
18272 :
I/O error on backup or restore restart-checkpoint file 'C:\Program Files\Microsoft SQL Server\MSSQL\backup\MyDatabase.ckp'. Operating system error 5(error not found). The statement is proceeding but is non-restartable.
The restore itself seems to finish although.
I searched the web already but didn't found anything specific which helped me. So any input would be much appreciated.
Thanks in advance
February 5, 2010 at 7:04 pm
What does the following command come back with:
dbcc checkdb(db_name) with no_infomsgs, all_errormsgs
Joie Andrew
"Since 1982"
February 8, 2010 at 2:44 am
thx for your reply!
The command reports back nothing - just "Command(s) completed successfully"
So I assume the DB itself seems to be okay.
February 8, 2010 at 1:19 pm
Correct, the database itself is okay, but I wonder if the backup somehow was bad. If you run a restore verifyonly on the backup you used, what do you get?
Joie Andrew
"Since 1982"
February 10, 2010 at 1:08 am
Also the backup set is valid when checking.
Strangely the errors are gone since yesterday.
I have given the user executing the backups and restores explicitly full access to the directory mentioned in the error (this user is local admin so it should have had already the permission).
Then I dropped the existing standby databases (although I have done this already several times).
Afterwards the standby databases were created again, this time without the error.
I will keep on monitoring but frankly I'm confused 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply