Interested to Buy Any Domain ? << Click Here >> for more details...
write the query for taking database backup in sql
- 10 Answers
- 36366 Views
- ABC, IBM, Logica CMG, MA, I also Faced
- E-Mail Answers
Answer Posted / madhu
BACKUP DATABASE
[db_SourceDbName] --SOURCE DB
TO DISK = N'\\192.168..124\db_TragetDbName.BAK' -- LOCATION
FILE NAME
WITH
NOFORMAT,
NOINIT,
NAME = N'myDbFull Backu[p-Full Database Backup',
SKIP,
NOREWIND,
NOUNLOAD,
STATS = 10
GO
| Is This Answer Correct ? | 36 Yes | 21 No |
Post New Answer View All Answers
Explain the difference between primary keys and foreign keys?
What is the use of builtinadministrators group in sql server? : sql server security
What is collation?
How many types of functions are there in sql server?
What is best institute to Learn DotNET And SQL in chennai?
when would you go for denormalization? : Sql server database administration
How to receive returning result from a query?
What happens if null values are involved in string operations?
What does <> symbol mean?
what is the different types of backups available in sql server? : Sql server database administration
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is the purpose of optimization?
What are the drawbacks of reporting in ssrs?
How to concatenate two strings in SQL Server.
