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.
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.
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'
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy