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
What is the fillfactor concept in indexes?
Explain what is meant by replication of database?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What is the bookmark lookup and rid lookup?
What is SQL Azure Firewall?
How to assign null values to variables or columns?
What is normalization? Explain its different types?
What is row_number()?
What are system databases into sql server (2005/2008)?
How data can be copied from one table to another table?
What do you mean by an execution plan?
What is SQL Azure?
What is the recovery model?
Please illustrate physical database architecture? : SQL Server Architecture
How to retrieve error messages using mssql_get_last_message()?