Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

write the query for taking database backup in sql

Answer Posted / selvaraj.v

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I save a stored procedure in sql server?

928


how to create a scrollable cursor with the scroll option? : Sql server database administration

1024


Do you know query execution plan?

1072


Explain relational data?

855


What is the difference between resultset and resultsetmetadata?

891


Explain activity monitors

1003


What is Federation and Federation Member?

92


How do you make a trace?

954


Define model database?

932


Can you explain about buffer cash and log cache in sql server?

904


What is difference between line feed ( ) and carriage return ( )?

852


Can primary key be null?

879


how you can get the list of largest tables in a database? : Sql server administration

985


What is the Control Flow in SSIS

1031


How to drop existing indexes in ms sql server?

1013