write the query for taking database backup in sql
Answers were Sorted based on User's Feedback
Answer / shardul negi
backup database <database name> to disk
|Is This Answer Correct ?||118 Yes||25 No|
SQL Server 2000 BackUp Database,
backup database selvaa to disk = 'c:\selvaa.bak'
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
[db_SourceDbName] --SOURCE DB
TO DISK = N'\\192.168..124\db_TragetDbName.BAK' -- LOCATION
NAME = N'myDbFull Backu[p-Full Database Backup',
STATS = 10
|Is This Answer Correct ?||36 Yes||21 No|
Answer / vinod
its really working good
|Is This Answer Correct ?||19 Yes||9 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 / christopher issac
|Is This Answer Correct ?||13 Yes||9 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 / kishore
|Is This Answer Correct ?||8 Yes||10 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 to find number of columns in a table in sql server 2000 and 2005 also
If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?
Which command using Query Analyzer will give you the version of SQL server and operating system?
What is a transaction and what are ACID properties?
what purpose does OPENXML clause have in sql server stored procedure?
Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance
Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???
Why Do you want to work in this company?
how to rest identity columns in sql server
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply
how to find nth highest salary