write the query for taking database backup in sql
Answer Posted / prasant
It is working good but taking many time (Approx. 3 minutes for a 2gb database).
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What is the difference between local and global temporary tables?
What is a View ? Can we insert, Update and delete a view?
Write the syntax for stuff function in an sql server?
Is BCNF better than 2NF & 3NF? Why?
Where are SQL server users names and passwords are stored in sql server?
What is the tcp/ip port on which sql server runs?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
How extra digits are handled with numeric data type literals?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is the chart in report?
Define full outer join in sql server joins?
Explain about thread and memory management process of SQL?
what are the different types of replication you can set up in sql server? : Sql server database administration
Name the different type of indexes in sql?