How do I back up the Microsoft SQL database before upgrading VigilEnt Security Manager? (NETIQKB31863)

goal
How do I back up the Microsoft SQL database before upgrading VigilEnt Security Manager?

fact
VigilEnt Security Manager

fix
You can back up a Microsoft SQL database by executing the following TSQL:

BACKUP DATABASE Vigilent TO DISK = 'c:\mssql7\backup\Vigilent.bak'

The above example backs up the VigilEnt database to a file called Vigilent.bak. The above TSQL and other statements can be found on Microsoft's Web site at the following location.

http://www.microsoft.com/technet/

Formerly known as NETIQKB31863