Syntax for taking fullbackup of TEST database
BACKUP DATABASE TEST
TO DISK='D:\SQLServerBackups\TEST.bak' WITH FORMAT , NORECOVERY
NOTE:- by default CREATE BACKUP takes the fuul bkup of the database
BACKUP DATABASE TEST
TO DISK='D:\SQLServerBackups\TEST.bak' WITH FORMAT , NORECOVERY
NOTE:- by default CREATE BACKUP takes the fuul bkup of the database
No comments:
Post a Comment