Showing posts with label how to take database backup using sql query. Show all posts
Showing posts with label how to take database backup using sql query. Show all posts

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.