Skip to main content
Database Administrators

Return to Question

Code formatting is for code, not emphasis see https://meta.stackexchange.com/questions/135112/inline-code-spans-should-not-be-used-for-emphasis-right
Source Link
Paul White ♦
Paul White ♦
  • 90.3k
  • 30
  • 424
  • 663

We had a server running MSSQL 2014 databasesMicrosoft SQL Server 2014 databases on Hyper-VHyper-V. I exported it (with C:C: and D:D: drives) and opened on other machine.

I could not start the MSSQLSERVER service service because it said the master dbmaster db needed to be rebuilt.

I've rebuitrebuilt the master DBmaster db, but now the DB'sdatabases are empty, I cannot see databases except master, model, msdb and tempmaster, model, msdb, and tempdb.

I have all databases Databases (mdf and ldf files)(mdf and ldf files) in this folder D:\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA how. How to restore them and not lose all functionality?

We had server running MSSQL 2014 databases on Hyper-V. I exported it (with C: and D: drives) and opened on other machine.

I could not start MSSQLSERVER service because it said master db needed to be rebuilt.

I've rebuit the master DB but now the DB's are empty, I cannot see databases except master, model, msdb and temp.

I have all Databases (mdf and ldf files) in this folder D:\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA how to restore them and not lose all functionality?

We had a server running Microsoft SQL Server 2014 databases on Hyper-V. I exported it (with C: and D: drives) and opened on other machine.

I could not start the MSSQLSERVER service because it said the master db needed to be rebuilt.

I've rebuilt the master db, but now the databases are empty, I cannot see databases except master, model, msdb, and tempdb.

I have all databases (mdf and ldf files) in this folder D:\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA. How to restore them and not lose all functionality?

added 23 characters in body
Source Link
Marin
Marin
  • 1
  • 2

We had server running MSSQL 2014 databases on Hyper-V. I exported it (with C: and D: drives) and opened on other machine.

I could not start MSSQLSERVER service because it said master db needed to be rebuilt.

I've rebuit the master DB but now the DB's are empty, I cannot see databases except master, model, msdb and temp.

I have all Databases (mdf and ldf files) in this folder D:\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA how to restore them and not lose all functionality?

We had server running MSSQL 2014 databases on Hyper-V. I exported it and opened on other machine.

I could not start MSSQLSERVER service because it said master db needed to be rebuilt.

I've rebuit the master DB but now the DB's are empty, I cannot see databases except master, model, msdb and temp.

I have all Databases (mdf and ldf files) in this folder D:\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA how to restore them and not lose all functionality?

We had server running MSSQL 2014 databases on Hyper-V. I exported it (with C: and D: drives) and opened on other machine.

I could not start MSSQLSERVER service because it said master db needed to be rebuilt.

I've rebuit the master DB but now the DB's are empty, I cannot see databases except master, model, msdb and temp.

I have all Databases (mdf and ldf files) in this folder D:\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA how to restore them and not lose all functionality?

Source Link
Marin
Marin
  • 1
  • 2

Databases missing after exporting server and rebuilding master DB

We had server running MSSQL 2014 databases on Hyper-V. I exported it and opened on other machine.

I could not start MSSQLSERVER service because it said master db needed to be rebuilt.

I've rebuit the master DB but now the DB's are empty, I cannot see databases except master, model, msdb and temp.

I have all Databases (mdf and ldf files) in this folder D:\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA how to restore them and not lose all functionality?