-
Title
What the function of that @guid argument in LiteSpeed T-SQL scripts? -
Description
When obtaining a script sample from Backup Wizard Graphical User Interface (UI), the t-sql script includes the @GUID parameter. The @GUID parameter is not used by the Restore Wizard GUI.
-
Cause
The @GUID parameter is only visible when the t-sql script is generated by the Backup Wizard Graphical User Interface (GUI). When running the t-sql backup script from Query Analyzer or SQL Management Studio, this argument may be omitted.
-
Resolution
When using the GUI Backup Wizard, the @GUID parameter is included in the t-sql script :
Example:
exec master.dbo.xp_backup_database @database = '[xxxx]',
@GUID = '3488F54C-1C24-4AA2-97C8-40921398066D',
@filename = '\\server21\archive\xxxx.bak'
When viewing a backup script from GUI Backup Wizard, the script includes the @GUID parameter, required only for LiteSpeed GUI internal process, and may be omitted. The t-sql script will successfully complete with, or without the @GUID parameter.
Example:
exec master.dbo.xp_backup_database @database = '[xxxx]',
@filename = '\\server21\archive\xxxx.bak'