Open the sql server query analysiser To Type The following query Back

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

Question Posted / kumar.t

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

Please Help Members By Posting Answers For Below Questions

How and why use sql server?

952

What is instead of dml trigger?

950

How to rebuild master databse?

1028

What is partitioned view?

852

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1079

Do you know what are acid properties of transaction?

909

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1002

Explain the steps to create and execute a user-defined function in the sql server?

918

What are the mathematical functions supported by sql server 2005?

995

What is difference between delete & truncate commands?

1022

What are the different types of sql server replication? : sql server replication

1156

What are the disadvantages of primary key and foreign key in SQL?

1047

What is a heap?

981

What is an index in sql?

958

How to delete duplicate records based on single column from a table?

995