write the query for taking database backup in sql
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
How do I save a stored procedure in sql server?
how to create a scrollable cursor with the scroll option? : Sql server database administration
Do you know query execution plan?
Explain relational data?
What is the difference between resultset and resultsetmetadata?
Explain activity monitors
What is Federation and Federation Member?
How do you make a trace?
Define model database?
Can you explain about buffer cash and log cache in sql server?
What is difference between line feed ( ) and carriage return ( )?
Can primary key be null?
how you can get the list of largest tables in a database? : Sql server administration
What is the Control Flow in SSIS
How to drop existing indexes in ms sql server?