SQL server not starting after database restore

Posted on 2007-08-03
Last Modified: 2008-01-09
WINDOWS 2000 Server
The server is configured as Drive C: with operating system, Drive D: Program Files, SQL server 2000 and drive E: Data, location of SQL database files. The Drive E is running out of disk space and i replaced it. The seteps i took were as follows
1. Take Tape backup of all drives C D and E using Microsoft Backup
2. Replace Drive E with larger capacity and fprmatted
3. Restored only Drive E from Microsoft Backup
When all these steps were carried out i rebooted the server expecting the database to come back online. The SQL service will not start and the following entry is listed in the event logs.
Event Type:      Error
Event Source:      MSSQLSERVER
Event Category:      (2)
Event ID:      17055
Date:            03/08/2007
Time:            15:28:54
User:            N/A
Computer:      SUN_DATA
17113 :
initconfig: Error 2(error not found) opening 'e:\Program Files\Microsoft SQL Server\MSSQL\data\master.mdf' for configuration information.
0000: d9 42 00 00 10 00 00 00   ÙB......
0008: 09 00 00 00 53 00 55 00   ....S.U.
0010: 4e 00 5f 00 44 00 41 00   N._.D.A.
0018: 54 00 41 00 00 00 00 00   T.A.....
0020: 00 00                     ..      
Question by:rtl_support
    LVL 10

    Expert Comment

    Was SQL Server shut down while you took the backups?  If you don't want to shut down SQL Server while taking backups then you must use use SQL Server to take the backups - if you did neither of these things then you have some work in front of you before you can get a working database again...
    LVL 25

    Accepted Solution


    I must say you went the long way around to do this. What I would do is put the old drive back and add the new drive to the system as drive F. Then, backup the whole db in enterprise manager and then detach the database file. Then, copy the entire contents from E to F and  reattach the database and start it all up. This way you move the files.

    If you didn't want to do that, then add the drive still as drive F, then backup the database in enterprise manager and copy all the data to drive F. Remove drive E from the system and then when you reboot, if Windows doesn't reassign the drive letters, then go into the Disk Management and reassign the drive letter from F to E.

    You shouldn't need tapes at all and it would allow you to do what you wanted without having to use the dreaded "Microsoft Backup" which is not very good.


    LVL 25

    Expert Comment

    by:Lee Savidge

    One thing to note. You can't just move a database from SQL server. If you do, you have to detach it first and then reattach it when you want it back.



    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This article describes some very basic things about SQL Server filegroups.
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now