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

Why main is user defined function?

1052

What is tcl in sql server?

1174

How are the exceptions handled in sql server programming?

1119

What is the difference between DATETIME2 and DATETIME?

1131

How to create database with physical files specified in ms sql server?

1035

What are cursors and when they are useful?

1154

How can we improve performance by using SQL Server profiler?

1108

Tell about MOM Tool(Microsoft Operator Manager)?

1964

What is BCP? When does it used in sql server 2012?

1108

How do you create type- insensitive operator?

1105

What is buffer cash and log cache in sql server?

1193

What is a non equi join?

1026

What is the difference between insensitive and scroll cursor?

1244

How do I clean up sql server transaction log?

1128

Can sql servers link to other servers like oracle?

898