Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Restoring master database Expand / Collapse
Author
Message
Posted Saturday, May 17, 2014 10:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 6:40 AM
Points: 2,567, Visits: 3,799
Hi Experts,

I want to restore master database and when i tried the RESTORE FILELISTONLY it is giving below details.

master V:\MSSQL10_50.SQL1\MSSQL\DATA\master.mdf D PRIMARY
mastlog V:\MSSQL10_50.SQL1\MSSQL\DATA\mastlog.ldf L NULL

when i tried earlier SQL failed to restart and was showing that the sql is trying to find files form V drive i dont have V drive in my system but have only C & E drive.

Please help me with script to restore this master database.

TIA
Post #1572008
Posted Saturday, May 17, 2014 10:37 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 6:40 AM
Points: 2,567, Visits: 3,799
Some one please help..

earlier i tried the command
RESTORE DATABASE master FROM DISK = 'E:\MASTER_05172014.bak' replace
Post #1572009
Posted Saturday, May 17, 2014 10:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 6:40 AM
Points: 2,567, Visits: 3,799
Restored database with above command in error log i got below..What can i do to make SQL up and running.

2014-05-17 22:19:03.16 spid10s FCB::Open failed: Could not open file V:\MSSQL10_50.SQL1\MSSQL\DATA\model.mdf for file number 1. OS error: 3(The system cannot find the path specified.).
2014-05-17 22:19:03.17 spid7s Server name is 'ABC\R8'. This is an informational message only. No user action is required.
2014-05-17 22:19:03.22 spid10s Error: 5120, Severity: 16, State: 101.
2014-05-17 22:19:03.22 spid10s Unable to open the physical file "V:\MSSQL10_50.SQL1\MSSQL\DATA\model.mdf". Operating system error 3: "3(The system cannot find the path specified.)".
2014-05-17 22:19:03.22 spid10s Error: 945, Severity: 14, State: 2.
Post #1572010
Posted Saturday, May 17, 2014 10:58 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:24 AM
Points: 42,422, Visits: 35,483
https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1572013
Posted Saturday, May 17, 2014 11:39 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 6:40 AM
Points: 2,567, Visits: 3,799
Thanks a lot Gail.

Where should i run this Sqlservr.exe –T3608 ,is this available in SQL 2008?
Post #1572020
Posted Sunday, May 18, 2014 9:30 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:24 AM
Points: 42,422, Visits: 35,483
That article was written using SQL 2008, so yes.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1572089
Posted Tuesday, May 20, 2014 5:45 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 6:40 AM
Points: 2,567, Visits: 3,799
Thanks Gail.

From where i need to run this, I have setup.exe but not this one. Please help.
Post #1572592
Posted Tuesday, May 20, 2014 6:47 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 3:06 AM
Points: 447, Visits: 1,657
By default it's located at C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn

but it depends on your installation. Have a look there first.
Post #1572625
Posted Wednesday, May 21, 2014 8:12 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 6:40 AM
Points: 2,567, Visits: 3,799
Thanks Beatrix Kiddo.

Tried and i am getting nothing but a box and a red cross in it. I have a 2012 instance running on that now. I need to start my SQL 2008 named instance.
Post #1573193
Posted Wednesday, May 21, 2014 8:41 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 3:06 AM
Points: 447, Visits: 1,657
Talk us through what you've done so far.

So: have you opened a command prompt window and navigated to the location of the BINN folder for your 2008 instance?

If you have, please post the syntax you are using to try to start the 2008 instance.
Post #1573218
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse