How can we help you today? How can we help you today?

Restore to one moment in time from TRAN Log failing

Hi there,

I have been playing with the different backup and restore possibilities and have come up against a problem.

When I choose to do a restore of a transaction log and choose to restore to a certain point in time within the tran log the restore aborts.

Here is the T-SQL generated by SQLBACKUP:
master..sqlbackup N'-SQL "RESTORE DATABASE [TEST_DB] FROM DISK = ''U:\Backup\BACKUPTEST_20080109.sqb'' WITH NORECOVERY, PASSWORD = ''test'', REPLACE"'

master..sqlbackup N'-SQL "RESTORE LOG [TEST_DB] FROM DISK = ''U:\Backup\LOGBACKUPTEST_20080109.sqb'' WITH RECOVERY, PASSWORD = ''test', STOPAT = ''January 09 2008 10:25:08''"'

I got the full backup restored with no errors but the tran log restore gives the following error:
- VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval has elapsed.)

- Also check that the database is not currently in use.

- SQL error 3013: RESTORE LOG operation terminated abnormally.

- SQL error 3217: An invalid value was given for the STOPAT parameter.

If I perform a restore of the same tran log but let it restore the entire file I don't get the errors.

Am I doing something wrong here that stops the restore to an exact point in time?

regards

wd
wd
0

Comments

3 comments

Sort by
  • petey
    Is the value 'January 09 2008 10:25:08' accepted by your SQL Server instance for the STOPAT parameter, for native backups? Can you try using the value '2008-01-09 10:25:08'?

    Thanks.
    petey
    0
  • wd
    Hi Peter,

    that worked out fine.

    Is it possible to get SQLBackup to change the format of this datetime field according to the locale settings of the sql server?

    regards

    wd
    wd
    0
  • sbs
    check change Region settings. It worked for me.
    sbs
    0

Add comment

Please sign in to leave a comment.