SQL Server Performance

backup & restore

Discussion in 'General DBA Questions' started by arunkumar_mp, Oct 17, 2006.

  1. arunkumar_mp New Member

    hi gurus

    Can u tell me what are all the possible ways to take backup and restore the database in sql server.

    Please reply me soon.


    Regards

    Arun
  2. ranjitjain New Member

    Hi,
    are you looking for this...
    1>Go to enterprise manager and right click on the database you want to backup.
    2>Open Query analyser and using sql statements like 'backup database' to backup your database
  3. xiebo2010cx Member

    You also take advantage of maintenance plan jobs to take care of full backup, differential backup and trans log backup f0r 2005 instance.



    ------------------
    Bug explorer/finder/seeker/locator
    ------------------
  4. ghemant Moderator

    Hi,
    And Refer BOL which will clear all your queries relating backup and restore.

    Hemantgiri S. Goswami
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
    ------------------------
    http://hemantgirisgoswami.blogspot.com

Share This Page