Thursday 30 April 2015

how to take database backup using sql query

in query window use this syntex:

backup datsbase databasename to disk='location to store'


Example:

backup database sureshdatabase in disk = 'D:\sureshDBBackup\sureshdatabase.bak'

after forming this query execute.




No comments:

Post a Comment