BUG: Invalid Value Specified for STOPAT Parameter During Restore

Article translations Article translations
Article ID: 297468 - View products that this article applies to.
This article was previously published under Q297468
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 58195 (SQLBUG_70)
Expand all | Collapse all


If you use SQL Server Enterprise Manager to restore a transaction log you can specify a point in time restore. At the end of the restoration, the following error message occurs if the default language of the login used to register the SQL Server is not English:
"Invalid value specified for STOPAT parameter"


The STOPAT value supplied is being treated like it is formatted as "YDM" by SQL Server where as the value supplied by the SQL Server Enterprise Manager is of the format "YMD", which causes an invalid date.


To work around this behavior either:
  • Change the default language of the login used to register SQL Server to "English".


  • Use the SQL Server Query Analyzer and the set the date format to YMD. For example, at the command line type:

    set dateformat ymd

    and then issue the RESTORE command.


Microsoft has confirmed this to be a problem in SQL Server 7.0.


Article ID: 297468 - Last Review: November 2, 2013 - Revision: 2.0
Applies to
  • Microsoft SQL Server 7.0 Standard Edition
kbnosurvey kbarchive kbbug kbDSupport KB297468

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com