Exporting sql server database

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Prabhua
    New Member
    • Nov 2006
    • 29
    #1

    Exporting sql server database

    hi,
    can anyone tell me how to export sql server database to a particular location.
    thanks.
    Tags: None
    • almaz
      Recognized Expert New Member
      • Dec 2006
      • 168
      #2
      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.

        Comment

        Previous template Next
        Working...