Exporting sql server database

hi,
can anyone tell me how to export sql server database to a particular location.
thanks.

Quote:

Originally Posted by Prabhua

hi,
can anyone tell me how to export sql server database to a particular location.
thanks.

What do you mean by "export sql server database"? And "particular location"?
If you want to export data from database, you can use Export and Import Wizard (right-click on the database in the Management Studio or Enterprise Manager, All Tasks).
If you want to backup the data - use backup feature.
If you want to move database to another SQL Server - detach database, copy database files to new SQL Server's DATA folder and attach database.