Hi All:
I want to use Sql Server 7.0 to backup the data. If I was to run the following lines of code, would that be sufficient to create a good full backup; that would include views, store procedures, table relations,indexes,triggers and user securities,etc. Please advise if I need to do more coding.

Thanks for all your help.
MA

**Create the backup device for the full Datawarehouse backup.
USE Acme_Whse
EXEC sp_addumpdevice 'disk', 'Datawarehouse_2',
'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Datawarehouse_2.dat'

**Create the log backup device.
USE Acme_Whse
EXEC sp_addumpdevice 'disk', 'DatawarehouseLog1',
'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\DatawarehouseLog1.dat'

**Back up the full Datawarehouse database.
BACKUP DATABASE Datawarehouse TO Datawarehouse_2

**Update activity has occurred since the full database backup.

**Back up the log of the Datawarehouse database.
BACKUP LOG Datawarehouse TO DatawarehouseLog_1