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

Does an index slow down updates on indexed columns?

972

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

990

How to use go command in "sqlcmd"?

1204

What is the difference between NOROW and LOCKROW?

2835

What are sql dirty pages?

1021

Characterize join and name diverse sorts of joins?

966

Explain what is dbcc?

1010

What are the restrictions applicable while creating views? : SQL Server Architecture

1023

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

981

What is lock escalation? : sql server database administration

1159

Explain powershell included in sql server 2008?

1055

List types of tables in SQL Azure?

126

What does it mean to normalize a database and why would you do it?

979

Can an automatic recovery be initiated by a user?

1012

What is the difference between getdate and sysdatetime?

1005