Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

write the query for taking database backup in sql

Question Posted / madhu

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


Please Help Members By Posting Answers For Below Questions

How can we determine what objects a user-defined function depends upon?

694

What are the instances when triggers are appropriate?

716

What is a sql join?

748

What is save transaction and save point?

837

Explain triggers?

753




Differentiate between sql temp table vs table variable?

666

Explain about unique identifier data type in sql server?

679

What are xml indexes?

693

Tell about MOM Tool(Microsoft Operator Manager)?

1587

what are acid properties? : Sql server database administration

665

What does the update command do?

784

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

2167

What is Command line parameters in PLSQL.?

760

What are data regions?

107

Write an sql query for deleting duplicate rows?

724