Results 1 to 2 of 2

Thread: Few questions

  1. #1
    Join Date
    Oct 2003
    Posts
    83

    Unanswered: Few questions

    Hi All,
    I am new in SQL SERVER 2000.I have few questions -
    1) WHAT WILL I DO TO TRUNCATE THE SIZE OF A TRANSACTION LOG?
    2) WHAT WILL BE THE STEPS OF BUILDING THE MASTER DATABASE?
    3) WHAT WOULD BE THE PLAN OF ACTION WHEN SQL DOES NOT STARTS UP?
    4) WHAT WOULD BE MY PLAN OF ACTION WHEN SQL DB GETS CORUPTED OR STARTS IN A SUSPECT MODE?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    1) See BACKUP
    2) Install SQL 2000
    3) Start MS-SQL, then examine the log file (whether it actually starts or not).
    4) Determine what caused the problem(s), and fix it.

    If these answers seem terse, it is because the questions sound like homework to me.

    -PatP

Posting Permissions

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