Post reply

How to back up tables in ms sql server 2005

  • September 6, 2007 at 9:57 am

    #174622

    Hi I am new to ms sql server.The problem i am facing is that,i need to back up some of the tables from a database folder.I found option to back up the entire folder.but since the folder is really huge i need to back up those particular tables.plz help me in doing this.

    thanks

  • September 6, 2007 at 12:23 pm

    #731946

    There is no way to backup a single table in SQL (natively), you would have to bulk copy out the individual tables.  Look up the "Importing and Exporting Bulk Data" document in Books Online.

  • September 7, 2007 at 6:00 am

    #732091

    What is the actual size of the database?  When a backup file is created, the size of the backup file will be the size of the actual data.  So if you allocated 20 GB for the datbase and only 1GB is actual data, the backup file size will only be about 1GB.

  • September 7, 2007 at 10:03 am

    #732205

    pretty easy to with Server Management Studio.  Right click on DB. ->Tasks->Export Data... Follow prompts

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply