write the query for taking database backup in sql
- 10 Answers
- 33967 Views
- ABC, IBM, Logica CMG, MA, I also Faced
- E-Mail Answers
Answer Posted / selvaraj.v
SQL Server 2000 BackUp Database,
Query:
------
backup database selvaa to disk = 'c:\selvaa.bak'
Answer:
-------
Processed 160 pages for database 'selvaa',
file 'selvaa_Data' on file 1.
Processed 1 pages for database 'selvaa', file 'selvaa_Log'
on file 1.
BACKUP DATABASE successfully processed 161 pages in 0.151
seconds (8.687 MB/sec).
| Is This Answer Correct ? | 44 Yes | 20 No |
Post New Answer View All Answers
Can we linked SharePoint to a SQL database?
Is it safe to delete log files?
what are the different stages of Report Processing?
What is Extended user-defined?
How to run queries with sql server management studio express?
What is recompile sql server?
Explain an incremental backup?
What does it mean to normalize a database and why would you do it?
Why use “nolock” in sql server?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What are the disadvantages of using the stored procedures?
What is inner join? Explain with an example?
Tell me what are the advantages of using stored procedures?
What are the types of stored procedures in an sql server?
What is 1nf normalization form?
