About Me

My photo
MCTS FOR SQL SERVER 2008 DOT NET PROGRAMMING WEB DESIGNING

Sunday, 23 October 2011

HOW TO TAKE FULL BACKUP

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

No comments:

Post a Comment