how to get the automatic backup of the database in the sql
server

Answer Posted / kumar.t

Open the sql server query analysiser

To Type The following query

Backup DataBase <DataBaseName>
To Disk ='Server path'

Is This Answer Correct ?    18 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many databases Microsoft SQL server provides?

615


What are drilldown reports?

86


How can we delete Duplicate row in table?

638


What is surrogate key? : sql server analysis services, ssas

701


What is acid db?

521






What is database isolation in sql server? : sql server database administration

570


difference between Clustered index and non clustered index ?

583


What is normalization? What number of normalization shapes are there?

611


Explain can you implement data mining in ssrs?

106


Can we call stored procedure in trigger?

555


What are triggers in ms sql server?

608


Explain what is it unwise to create wide clustered index keys?

549


How to round a numeric value to a specific precision?

573


How do you create type- insensitive operator?

572


What is the need for indexing?

502