[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3060
  • Last Modified:

SQL server not starting after database restore

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                     ..      
  • 2
1 Solution
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...
Lee SavidgeCommented:

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.


Lee SavidgeCommented:

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

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now