Wednesday, March 28, 2012

I/O error on backup or restore restart-checkpoint file

Does any of you know what this is about:
"I/O error on backup or restore restart-checkpoint
file 'E:\Program Files\Microsoft SQL
Server\MSSQL\backup\Domain1.ckp'. Operating system error 3
(error not found). The statement is proceeding but is non-
restartable."
I get an error code 18272 (cant find it in BOL).
Note: Domain1 is the name of a specific database on my
server.
The directory 'E:\Program Files\Microsoft SQL
Server\MSSQL\backup' have been deleted so it is no wonder
that it can't either find nor create a file in that
directory.
The error was raised during a restore of the Domain1
database (the restore completed successfuly). I have a job
that kills every connection to the Domain1 database
(except it's own connection) for the database to be
restorable.
What setting must be set for SQL Server not to use this
directory for this purpose?
Note: backups (both data og log) are written just fine to
another directory.
Yours truly
Jakob Pedersen"Jakob Pedersen" <anonymous@.discussions.microsoft.com> wrote in message
news:171201c3e051$27d725d0$a301280a@.phx.gbl...
quote:

> Does any of you know what this is about :
> "I/O error on backup or restore restart-checkpoint
> file 'E:\Program Files\Microsoft SQL
> Server\MSSQL\backup\Domain1.ckp'. Operating system error 3
> (error not found). The statement is proceeding but is non-
> restartable."
> I get an error code 18272 (cant find it in BOL).
> Note: Domain1 is the name of a specific database on my
> server.
> The directory 'E:\Program Files\Microsoft SQL
> Server\MSSQL\backup' have been deleted so it is no wonder
> that it can't either find nor create a file in that
> directory.
> The error was raised during a restore of the Domain1
> database (the restore completed successfuly). I have a job
> that kills every connection to the Domain1 database
> (except it's own connection) for the database to be
> restorable.

Are you sure the restore was successful? It sounds like something did not
work quite right... do you still have the syntax you used for the restore?
quote:

> What setting must be set for SQL Server not to use this
> directory for this purpose?

It really depends on how you performed the restore here...
quote:

> Note: backups (both data og log) are written just fine to
> another directory.

During the restore? I'm not sure what you mean here.
Steve|||> "Jakob Pedersen" <anonymous@.discussions.microsoft.com> wrote in message
quote:

> news:171201c3e051$27d725d0$a301280a@.phx.gbl...
>

Are you sure the restore was successful? It sounds like something did not
work quite right... do you still have the syntax you used for the restore?
quote:

>
It really depends on how you performed the restore here...
[QUOTE]
During the restore? I'm not sure what you mean here.
Steve
[QUOTE]
>

No comments:

Post a Comment