Results 1 to 6 of 6

Thread: Backup Database

  1. #1
    Join Date
    Feb 2005
    Posts
    36

    Unanswered: Backup Database

    Hi all,
    I wanna Format my database server due to some reason...
    so how i can Backup of SQL Server Databases....
    i have around 25 Databases in Sql Server.. and i wanna take backup of all..
    So how i can perform this task..
    plz guide Step by step....
    i m new in DataBase Backup ......
    Thanx
    Sajjad

  2. #2
    Join Date
    Jan 2003
    Location
    Nottinghamshire, UK
    Posts
    364
    Golden Rule number 1 - protect the data

    If you have no Backup regime in place I suggest you create one - sharpish.
    Then practice restoring the backups.

    Create a New Maintanence plan under Management in EM (right click Maint Plans)

    Create a new DB and backup then delete - re create the DB right click it and restore from Device - point device to .bak file.

    Make sure you have all the logins recorded


    GW
    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You have 25 databases and NO BACKUPS?

    Either get a DBA, or become a DBA, very fast. You can start by reading Books Online, which covers backups, log dumps, and everything else you need to know.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Feb 2005
    Posts
    36
    thanx for reply,,
    plz give some link of DBA books or give web address for this
    thanx
    Sajjad

  5. #5
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Quote Originally Posted by imshally81
    thanx for reply,,
    plz give some link of DBA books or give web address for this
    thanx
    Sajjad
    http://www.microsoft.com/sql/techinf...000/books.mspx

    -- This is all just a Figment of my Imagination --

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Books Online should have been installed with SQL Server by default. It should be in your Start menu along with SQL Server Enterprise Manager.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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