SQL Server 2000 : installation, Backup & Restore ~ Remote Tech Support

SQL Server 2000 :

Installation, Backup & Restore: Click to View

Backup SQL Query

Local Backup:

BACKUP DATABASE <DBNAME>

TO DISK = 'DriveName:\FolderName\<DBNAME.BAK>'

For Eg. Database name = 'TEST'

BACKUP DATABASE TEST

TO DISK = 'E:\BACKUP\TEST.BAK'

Network Backup:

BACKUP DATABASE <DBNAME>

TO DISK = '\\SystemName\SharredFolderName\<DBNAME.BAK>'

For Eg. Database name = 'TEST'

BACKUP DATABASE TEST

TO DISK = '\\System1\BACKUP\TEST.BAK'

By using this 2 line you can create query for all databases in a single query

Remote Tech Support