Skip to main content

Backup and Restore Database Commands

 BACKUP DATABASE [DB_Name]

       TO DISK = N'\\server\directory\backupfile.bak'

       WITH NOFORMAT, INIT, NAME=N'DBNAME', SKIP,    NOREWIND, NOUNLOAD, STATS=10;

 

RESTORE FILELISTONLY

              FROM DISK= N'\\server\directory\backupfile.bak'

 

DROP DATABASE [DB_Name] ;

 

RESTORE DATABASE [DB_Name]   

       FROM DISK=''\\server\directory\backupfile.bak'

       WITH

       MOVE 'DB_logicalName' TO

              'D:\Databases\data file name.mdf',

       MOVE 'DB_Log Name_log' TO       

              'E:\Logs\log file name_log.ldf'

 

 

Comments

Post a Comment

Popular posts from this blog

Javascript Form Validation

It's real simple. All you need to do is call a javascript function in a html  " onsubmit " in the form tag as a javascript return, like this       <form method="post" action="dosomething.php" onsubmit="return validateForm();"> If the code completes ok, the form is then sent to the page listed in "action" http://www.w3schools.com/js/js_form_validation.asp If the function specified in the onsubmit returns false, then the form is not sent to the page mentioned in action.
Post a Comment
Read more