Interested to Buy Any Domain ? << Click Here >> for more details...
write the query for taking database backup in sql
- 10 Answers
- 36398 Views
- ABC, IBM, Logica CMG, MA, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shardul negi
backup database <database name> to disk
= 'c:\<DatabaseName>.bak'
| Is This Answer Correct ? | 118 Yes | 25 No |
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 |
Answer / 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 |
Answer / purav topiwala
Backup database (your database name) to disk="(location
where back will store)"
| Is This Answer Correct ? | 12 Yes | 6 No |
Answer / hemant pal
backup database northwind to disk = 'c:\northwind.bak'
| Is This Answer Correct ? | 11 Yes | 10 No |
Answer / stephen tharkey
I think it is better but still need improvement.
| Is This Answer Correct ? | 6 Yes | 7 No |
Answer / prasant
It is working good but taking many time (Approx. 3 minutes for a 2gb database).
| Is This Answer Correct ? | 1 Yes | 3 No |
How do you trace the traffic hitting a sql server?
What are the steps you will take to improve the performance of a poor performing query?
What is an expensive query?
Can we update data in a view?
Difference between rowid and rownum in SQL?
You want to implement the one-to-one relationship while designing tables. How would you do it?
what is Covering Index ?
Can primary key be a foreign key?
Explain use of expression builder.
Explain important index characteristics?
What is the maximum number of index per table?
Explain powershell included in sql server 2008?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
