Red Gate forums :: View topic - "The supplied user buffer is not valid..." error
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup Previous Versions
SQL Backup Previous Versions forum

"The supplied user buffer is not valid..." error

Search in SQL Backup Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
siloreed



Joined: 15 Mar 2011
Posts: 1

PostPosted: Tue Mar 15, 2011 10:15 pm    Post subject: "The supplied user buffer is not valid..." error Reply with quote

During a transaction log restore we've recently begun to see this message in the SQL ERRORLOG:

During restore restart, an I/O error occurred on checkpoint file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\RestoreCheckpointDB6.CKP' (operating system error 1784(The supplied user buffer is not valid for the requested operation.)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.

When the problem occurs Process Monitor records this event:

Date & Time: 3/15/2011 4:30:14 PM
Event Class: File System
Operation: WriteFile
Result: 0xC00000E8
Path: C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\RestoreCheckpointDB6.CKP
TID: 3320
Duration: 0.0090821
Offset: 4,670
Length: 509,000
Priority: Normal

This problem only started recently, perhaps after the latest Microsoft Updates were installed. I haven't yet installed Service Pack 2 for SQL 2008. The server is Windows 2008 SP2 running on an Amazon EC2 instance. The SQL Backup version is 5.4.0.55.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 937
Location: Red Gate Software

PostPosted: Thu Mar 17, 2011 3:40 pm    Post subject: Reply with quote

Hi, Thank you for your post into the forum.

When performing a restore SQL Server creates and writes to a checkpoint file.

If during the restore process, SQL Server cannot write to the checkpoint file location it generates the error message you reported in your post.

I would ensure that path to the '.ckp' exists and there is sufficient free disk space for the files to be created and grow.

Also check the permissions of the checkpoint file path and ensure that the account for the SQL Server service has necessary security permissions.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
nuevo



Joined: 29 Mar 2011
Posts: 1

PostPosted: Tue Mar 29, 2011 8:28 pm    Post subject: Reply with quote

We are having the same problem.

The SQL Server service account has full permissions on the checkpoint file path. There is 8GB free disk space on that drive. It's a dedicated database server.

What else might cause this problem?
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 937
Location: Red Gate Software

PostPosted: Mon Apr 04, 2011 5:12 pm    Post subject: Reply with quote

Hi Nuevo

I am not sure that I can add any further information that will help you.

The reported issue is a SQL Server / Windows I/O error.
Operating system error 1784 ERROR_INVALID_USER_BUFFER or ERROR_NOT_ENOUGH_MEMORY. Each device driver maintains a fixed-size list (in a nonpaged pool) of outstanding I/O requests. If the list is full, the system can't queue the request and the error is generated. This msdn article on the Windows Asynchronous Device I/O may help.

Apart from Security permissions of the SQL Server account, the problem may be caused by one of the following:
    Workload of the server at the time of the restore?
    Check the system's I/O processes?
    Possible problem with device driver?


Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group