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
What is sub query and its properties?
What is stretch database in sql server?
Describe different Processing Modes offered by SSRS?
How to create a testing table with test data in ms sql server?
What is a db view?
Where the sql logs gets stored? : sql server database administration
How to resolve the orphan use problem? : sql server security
Tell me what is normalization? Explain different forms of normalization?
What are indexes in sql?
What are the advantages of having an index on the sql server?
Explain the architecture of ms sql reporting service?
How do I shrink an ldf file?
How many types of functions are there in sql server?
What is temporary stored procedure?
How to throw custom exception in Stored Procedure?