Interested to Buy Any Domain ? << Click Here >> for more details...
write the query for taking database backup in sql
- 10 Answers
- 36763 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 |
What is mean by dml?
what are the disadvantages of cursors? : Sql server database administration
What is view in sql?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
How do you drop an index?
How to rebuild indexes with alter index ... Rebuild?
How can you stop stored procedures from recompiling?
can you any body tell me suppose database is suspect mode. how can take to normal?
Explain full-text query in sql server?
whats the maximum size of view state??
Can we create clustered index on non primary key column
20 Answers ABC, CTS,
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
-
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)
