SQL Server 2000 : installation, Backup & Restore

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