write the query for taking database backup in sql
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
How do I start sql server 2016?
How each E-R model constructs can be mapped to the relational model?
How except clause is differs from not in clause?
What is the command dbcc checkdb used for?
what is a join and explain different types of joins? : Sql server database administration
What does this statement do @@rowcount?
How to use union to merge outputs from two queries together in ms sql server?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What are the differences between union, intersect, and minus operators?
What is difference between foreign key and unique key?
What are SSL and TSL protocols?
What are the different types of locks in the database?
Explain boyce and codd normal form(bcnf)?
Explain error handling in ssis?
What are the different acid properties?