Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement