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
Difference between DELETE and TRUNCATE?
Explain data warehousing in sql server?
How can I know what locks are running on which resource?
Can you pass expressions to function parameters?
Explain the use of containers in ssis?
What are Spatial data types in SQL Server 2008
Mention the different authentication modes in sql server.
what are candidate key, alternate key and composite key? : Sql server database administration
What is the language structure to add a record to a table?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
Explain four layers of abstraction microsoft architectured?
What are entities and relationships?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is the command used to recompile the stored procedure at run time?
What is the difference between dropping a database and taking a database offline?