DB Backup

SELECT P_ID,LASTNAME,FIRSTNAME,CITY

INTO NEWDB.DBO.PERSONS_BACKUP

FROM PERSONS

BACKUP DATABASE DBNAME TO DISK='E:\DBNAME.BAK'

DROP DATABASE DBNAME

RESTORE DATABASE DBNAME FROM DISK='E:\DBNAME.BAK'

BACKUP DATABASE AdventureWorks

TO DISK = 'C:\Backup\MultiFile\AdventureWorks1.bak',

DISK = 'C:\Backup\MultiFile\AdventureWorks2.bak',

DISK = 'C:\Backup\MultiFile\AdventureWorks3.bak'

RESTORE DATABASE [AdventureWorks]

FROM DISK = N'C:\Backup\MultiFile\AdventureWorks1.bak',

DISK = N'C:\Backup\MultiFile\AdventureWorks2.bak',

DISK = N'C:\Backup\MultiFile\AdventureWorks3.bak'

BACKUP DATABASE AdventureWorks

TO DISK = 'C:\Backup\SingleFile\AdventureWorks.bak'

MIRROR TO DISK = 'C:\Backup\MirrorFile\AdventureWorks.bak'

WITH FORMAT

BACKUP DATABASE DBNAME

TO DISK='E:\DBNAME.BAK',

DISK='F:\DBNAME.BAK'