Results 1 to 5 of 5
  1. #1
    Newcomer
    Join Date
    Aug 2012
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default System Databases restoring

    Hello,

    i'm testing the TDP 6.X for SQL.

    How can I restore the system databases (master)??

    -------

    1. Starting the SQL in Single Mode (sqlservr.exe -m)
    2. Starting the TDP Console
    3. Select the master database
    4. Restoring with Replace (true).

    Error: ACO5424E Could not connect to SQL server; SQL server returned: Failed to connect to server SQLSERVER. Login failed for user 'Domain\Administrator'. Reason: Server is in single user mode. Only one administrator can connect at this time.

    The Connection in the TDP is configured for Windows Authentication

    => http://publib.boulder.ibm.com/infoce...2Fdpsql151.htm

    --

    What have I forgotten? Are there any tutorials or videos?

    Can you help me?

    Thanks
    Last edited by Gipsy; 11-27-2012 at 05:28 PM.

  2. #2
    Senior Member domino's Avatar
    Join Date
    Nov 2005
    Location
    Germany
    Posts
    697
    Thanks
    1
    Thanked 23 Times in 21 Posts

    Default

    Any member of the computer's local Administrators group can connect to the instance of SQL Server as a member of the sysadmin fixed server role.
    If Microsoft is the answer, I want my problem back!

  3. #3
    Newcomer
    Join Date
    Aug 2012
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Hello domino,

    thank you for your answer!

    What you mean? The user 'administrator' is in the local Administrator-Group and fixed sysadmin user.

    When i try with SQL Authentication => 'sa', then is the same error.

    --

    When i try it, sql-single-mode prompt (cmd) show this:

    2012-11-27 23:24:20.71 Logon Login failed for user 'Domain\Administrator'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: <local machine>]

    OR

    2012-11-27 23:25:39.46 Logon Error: 18461, Severity: 14, State: 1.
    2012-11-27 23:25:39.46 Logon Login failed for user 'sa'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: IP-Address]

    ---

    Can you help me? Do you need more information?

  4. #4
    Newcomer
    Join Date
    Nov 2012
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    RecoveryFIX for SQL Database Recovery retrieves all data stored within SQL server .MDF files such as tables, triggers, views, stored procedures with damaged unique keys, primary keys and foreign keys. Deleted files are also successfully recovered and saved in a separate batch file for further use.
    http://www.repairsqlserver.net

    Thanks

  5. #5
    Senior Member
    Join Date
    Jan 2010
    Location
    San Nicolas de los Garza NL
    Posts
    181
    Thanks
    0
    Thanked 10 Times in 10 Posts

    Default

    In my particular opinion I prefer take backup of the system databases to disk and later get in tape


    Look this:
    Restoring the master database
    http://pic.dhe.ibm.com/infocenter/ts...rdatabase.html


    Restoring the Master DB using Data Protection for SQL
    http://www-01.ibm.com/support/docvie...id=swg21145873

    Best regards
    Francisco Parrilla
    IBM Certified Deployment Professional - Tivoli Storage Manager V6.3
    IBM Certified Technical Sales Specialist - Power Systems with POWER7 and AIX & Linux -v2

Similar Threads

  1. Restoring Oracle onto another system
    By Cederico in forum Oracle
    Replies: 4
    Last Post: 10-24-2012, 09:36 AM
  2. Restoring MSSQL Databases
    By vvragav in forum TSM Database
    Replies: 1
    Last Post: 07-17-2008, 06:31 AM
  3. Restoring of SQL Databases
    By chalkd in forum Restore / Recovery Discussion
    Replies: 8
    Last Post: 02-08-2008, 09:20 AM
  4. restoring system object from one node to another
    By cgreen in forum Backup / Archive Discussion
    Replies: 3
    Last Post: 10-12-2006, 03:04 PM
  5. Restoring System Object in a different node
    By tatoma in forum Backup / Archive Discussion
    Replies: 0
    Last Post: 05-21-2003, 05:10 PM

Posting Permissions

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