invalid value specified for STOPAT parameter
From: GrimJim (jamesp_at_opsisltd.co.uk)
Date: 11/17/04
- Next message: Adam Machanic: "Re: Insert performance/nvarchar"
- Previous message: Cal: "Ports"
- Next in thread: Tibor Karaszi: "Re: invalid value specified for STOPAT parameter"
- Reply: Tibor Karaszi: "Re: invalid value specified for STOPAT parameter"
- Messages sorted by: [ date ] [ thread ]
Date: 17 Nov 2004 09:26:25 -0800
I too had problems when trying to perform a Point in Time restore
using Enterprise Manager on a Windows XP system running MSDE.
When I try to do a log restore with STOPAT (Point in Time) using
Enterprise Manager, I receive a error message "Invalid value specified
for STOPAT parameter. RESTORE LOG is terminating abnormally."
This is mentioned in Microsoft Knowledge Base, see article
http://support.microsoft.com/kb/q297468/
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.
The article gives a workaround as....
Change the default language of the login used to register SQL Server
to "English".
-or-
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.
In Enterprise Manager at first I could not get it to work properly.
I tried doing this in Enterprise Manager by selecting the SQL Server
in the tree view browser of EM, then right-click and select Properties
(not Edit SQL Server registration properties...).
In Properties on the Server Settings tab, you can see the "Default
Language for User" drop-down. Select "British English", then hit OK.
However I think although this sets it correctly, any existing User
accounts have already been created or setup with the English (ie. USA
English) language.
It was not until I expanded the Security folder, then Logins that it
became a bit clearer. The right-hand side of EM now shows the Login
details, including their default language.
There will likely be two accounts showing, "sa" and
"Builtin\ADMINISTRATORS". I noticed that "sa" had changed to "British
English", but Builtin\ADMINISTRATORS was still set as just "English".
I chose Properties for this account and changed its default language
to British English.
I think that EM uses this account to perform Backup/Restore
operations.
Next I Disconnected from the SQL Server, then Connected again.
Finally on retrying the Restore to Point in Time the STOPAT error
message no longer appeared.
I retried this a couple more times to prove the process by changing
back to "English", then back to "British English" again.
It was definitely related to the Builtin\ADMINISTRATORS account, and
definitely required a Disconnect, followed by Connect.
It did not require the SQL Server to be restarted.
Hope this helps others.
- Next message: Adam Machanic: "Re: Insert performance/nvarchar"
- Previous message: Cal: "Ports"
- Next in thread: Tibor Karaszi: "Re: invalid value specified for STOPAT parameter"
- Reply: Tibor Karaszi: "Re: invalid value specified for STOPAT parameter"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
