twitter

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





Mar 28, 2011 | 0 comments | Labels: ,

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)