Verify/Restore Fails. "Not a valid LiteSpeed® for SQL Server® format file (Type is: 1)" (4251220)

Chat now with support

Live-Hilfe anfordern
Registrierung abschließen

Anmelden

Preisinformationen anfragen

Vertrieb kontaktieren

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Verify/Restore Fails. "Not a valid LiteSpeed® for SQL Server® format file (Type is: 1)"
Beschreibung

Attempting to Verify/Restore Database results in this message:
Msg 60404, Level 16, State 1, Line 0
Not a valid LiteSpeed® for SQL Server® format file (Type is: 1).
Select a valid LiteSpeed® for SQL Server® file for this restore operation.
All of our SQL servers are the same version and patch level. The backup and restore operation are both being run on the same server, so there can be no conflict between versions.
Ursache

Likely the storage device to which LiteSpeed is writing does not support overlapped writes. And currently, LiteSpeed performs overlapped writes by default.

We have logged defect LS-1197: "test the speed between overlapped write and normal write for network storages and disable it by default".

The comparison test of the speed speed is done because if the performance drop is too large, the change will not be made, the overlapped writing will remain enabled. In that case, any user with this problem will either have to configure their storage device to support overlapped operations or use the IOflag parameter.
Lösung

WORKAROUND 1
If possible, configure the storage device to support overlapped writes.

WORKAROUND 2
Disable overlapped writing. To do this, use the IOflag parameter (disables overlapped writes) in all jobs that write to that storage. Script this and add the below parameter to the script:

@IOFlag = N'SEQUENTIAL_SCAN'

STATUS

Issue fixed in version 8.8.The latest version of LiteSpeed for SQL Server can be downloaded here
Fehler-ID

LS-1197

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Request a KB Article

Empfohlener Inhalt

Produkt(e):: LiteSpeed for SQL Server

Thema/Themen:: Troubleshooting

Artikelhistorie:: Erstellt am: 10/12/2018
Letzte Aktualisierung am: 5/7/2023

Alle Artikel durchsuchen

Bitte w&auml;hlen Sie Ihr Produkt aus:

Damit wir Ihnen besser helfen können, geben Sie den Grund Ihres Chats an:

Empfohlene Lösungen für Ihr Problem

Verify/Restore Fails. "Not a valid LiteSpeed® for SQL Server® format file (Type is: 1)" (4251220)

Titel

Beschreibung

Ursache

Lösung

Fehler-ID

Leave a Comment

Bitte wählen Sie Ihr Produkt aus: