Results 1 to 3 of 3

Thread: taking backup

  1. #1
    Join Date
    Jun 2007
    Posts
    197

    Smile Unanswered: taking backup

    just as we export in db2 database

    as db2move databasename export -u username -p password


    how we will export in sql server

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    to export just one table's data, use bcp.exe, look for "bcp utility" in BOL.

    to backup the entire database, see the syntax for BACKUP DATABASE in books online.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    As you are new to the SQL Server I also suggest to refer to Books online which is installed on your machine in order to get acquaintance with the statements, fyi
    http://www.microsoft.com/technet/pro...ackuprest.mspx
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •