MS-Sql server not runing

Hi,

After restart, our SQL server stop and working and run the sqlservr.exe  in binn folder using command prompt, it's generate the following logs, request you to kindly help on this.

2015-06-02 14:05:15.22 Server      Microsoft SQL Server 2008 R2 (RTM) - 10.50.16
00.1 (X64)
        Apr  2 2010 15:48:46
        Copyright (c) Microsoft Corporation
        Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service
 Pack 1)

2015-06-02 14:05:15.23 Server      (c) Microsoft Corporation.
2015-06-02 14:05:15.23 Server      All rights reserved.
2015-06-02 14:05:15.23 Server      Server process ID is 3720.
2015-06-02 14:05:15.23 Server      System Manufacturer: 'INTEL', System Model: '
MFS5520VI Compute Module'.
2015-06-02 14:05:15.23 Server      Authentication mode is MIXED.
2015-06-02 14:05:15.23 Server      Logging SQL Server messages in file 'E:\Progr
am Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2015-06-02 14:05:15.23 Server      This instance of SQL Server last reported usi
ng a process ID of 4156 at 02/06/2015 2:02:19 PM (local) 02/06/2015 8:32:19 AM (
UTC). This is an informational message only; no user action is required.
2015-06-02 14:05:15.23 Server      Registry startup parameters:
         -d E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\D
ATA\master.mdf
         -e E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\L
og\ERRORLOG
         -l E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\D
ATA\mastlog.ldf
2015-06-02 14:05:15.23 Server      SQL Server is starting at normal priority bas
e (=7). This is an informational message only. No user action is required.
2015-06-02 14:05:15.24 Server      Detected 16 CPUs. This is an informational me
ssage; no user action is required.
2015-06-02 14:05:15.24 Server      Cannot use Large Page Extensions:  lock memor
y privilege was not granted.
2015-06-02 14:05:15.32 Server      Using dynamic lock allocation.  Initial alloc
ation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an infor
mational message only.  No user action is required.
2015-06-02 14:05:15.32 Server      Lock partitioning is enabled.  This is an inf
ormational message only. No user action is required.
2015-06-02 14:05:15.35 Server      Node configuration: node 0: CPU mask: 0x00000
0000000ff00:0 Active CPU mask: 0x000000000000ff00:0. This message provides a des
cription of the NUMA configuration for this computer. This is an informational m
essage only. No user action is required.
2015-06-02 14:05:15.35 Server      Node configuration: node 1: CPU mask: 0x00000
000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a des
cription of the NUMA configuration for this computer. This is an informational m
essage only. No user action is required.
2015-06-02 14:05:15.37 spid9s      Starting up database 'master'.
2015-06-02 14:05:15.49 spid9s      Resource governor reconfiguration succeeded.
2015-06-02 14:05:15.49 spid9s      SQL Server Audit is starting the audits. This
 is an informational message. No user action is required.
2015-06-02 14:05:15.49 spid9s      SQL Server Audit has started the audits. This
 is an informational message. No user action is required.
2015-06-02 14:05:15.49 spid9s      FILESTREAM: effective level = 0, configured l
evel = 0, file system access share name = 'MSSQLSERVER'.
2015-06-02 14:05:15.51 spid9s      SQL Trace ID 1 was started by login "sa".
2015-06-02 14:05:15.51 spid9s      Starting up database 'mssqlsystemresource'.
2015-06-02 14:05:15.52 spid9s      The resource database build version is 10.50.
1600. This is an informational message only. No user action is required.
2015-06-02 14:05:15.54 spid9s      Error: 15466, Severity: 16, State: 1.
2015-06-02 14:05:15.54 spid9s      An error occurred during decryption.
2015-06-02 14:05:15.55 spid9s      Server name is 'BESTLERPSRV03'. This is an in
formational message only. No user action is required.
2015-06-02 14:05:15.55 spid13s     Starting up database 'model'.
2015-06-02 14:05:15.56 spid13s     Error: 17204, Severity: 16, State: 1.
2015-06-02 14:05:15.56 spid13s     FCB::Open failed: Could not open file D:\Micr
osoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\model.mdf for file number 1.
 OS error: 3(The system cannot find the path specified.).
2015-06-02 14:05:15.56 spid13s     Error: 5120, Severity: 16, State: 101.
2015-06-02 14:05:15.56 spid13s     Unable to open the physical file "D:\Microsof
t SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\model.mdf". Operating system erro
r 3: "3(The system cannot find the path specified.)".
2015-06-02 14:05:15.56 spid13s     Error: 17207, Severity: 16, State: 1.
2015-06-02 14:05:15.56 spid13s     FileMgr::StartLogFiles: Operating system erro
r 2(The system cannot find the file specified.) occurred while creating or openi
ng file 'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\modellog.ldf'
. Diagnose and correct the operating system error, and retry the operation.
2015-06-02 14:05:15.56 spid13s     File activation failure. The physical file na
me "D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\modellog.ldf" may
be incorrect.
2015-06-02 14:05:15.56 spid13s     Error: 945, Severity: 14, State: 2.
2015-06-02 14:05:15.56 spid13s     Database 'model' cannot be opened due to inac
cessible files or insufficient memory or disk space.  See the SQL Server errorlo
g for details.
2015-06-02 14:05:15.56 spid13s     Could not create tempdb. You may not have eno
ugh disk space available. Free additional disk space by deleting other files on
the tempdb drive and then restart SQL Server. Check for additional errors in the
 event log that may indicate why the tempdb files could not be initialized.
2015-06-02 14:05:15.56 spid13s     SQL Trace was stopped due to server shutdown.
 Trace ID = '1'. This is an informational message only; no user action is requir
ed.
sitgAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Deepak ChauhanSQL Server DBACommented:
Error is clearly saying model.MDF file is missing from D:\ drive or SQL server can not read the file from this drive. Please check the file exists or not at the specified path. SQL server can not be start in normal mode because in absence of Model database , TempDB can not be created.

Model.mdf and model.ldf file should be there
"D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\"
0
sitgAuthor Commented:
it is available on there,  please see the below detail.

14/12/2014  03:21 AM       450,887,680 inforlndb.ldf
14/12/2014  03:21 AM     2,097,152,000 inforlndb.mdf
02/06/2015  12:34 PM         4,194,304 master.mdf
02/06/2015  03:59 PM         1,048,576 mastlog.ldf
05/11/2014  04:57 PM         2,359,296 model.mdf
05/11/2014  04:57 PM           786,432 modellog.ldf
23/01/2015  03:00 AM       115,802,112 MSDBData.mdf
05/11/2014  04:57 PM       104,595,456 MSDBLog.ldf
05/11/2014  04:57 PM         6,553,600 ReportServer.mdf
05/11/2014  04:57 PM        27,525,120 ReportServerTempDB.mdf
05/11/2014  04:57 PM        17,235,968 ReportServerTempDB_log.LDF
05/11/2014  04:57 PM         6,553,600 ReportServer_log.LDF
09/01/2015  04:06 PM       387,579,904 tempdb.mdf
11/01/2015  12:01 AM         1,048,576 templog.ldf
28/05/2015  09:30 AM         1,048,576 timestampSQL.ldf
28/05/2015  09:30 AM         2,359,296 timestampSQL.mdf
              19 File(s) 80,668,327,936 bytes
               2 Dir(s)  100,302,860,288 bytes free
0
Deepak ChauhanSQL Server DBACommented:
How much disk space available on D:\ drive, free up some space if not there.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

sitgAuthor Commented:
it is 400 Gb partition and 100gb is free
0
sitgAuthor Commented:
space screen short
space.JPG
0
Deepak ChauhanSQL Server DBACommented:
Seems not a space issue, now check files model.mdf. and .ldf files should not be readonly.
SQL server service account has permission to read the files from this drive.
0
John TsioumprisSoftware & Systems EngineerCommented:
Do you see any strange markings on the Database when you connect with SQL Server Management Studio...
0
sitgAuthor Commented:
el.mdf. and .ldf files having full permission

++++++++++++++++++++

here is the error detail

TITLE: Connect to Server
------------------------------

Cannot connect to 172.16.15.203.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
0
Deepak ChauhanSQL Server DBACommented:
Check sql services are running and TCPIP and Named pipe are enabled in SQL server configuration manager. For named instance check SQL server browser service should be running as well.
0
sitgAuthor Commented:
Finally I have uninstall sql and than re-install as repairing option was also not working.
now I am not able attached DB or restore it from backup.
 
when try to restore it from backup it show  

------------------------------

You must select a restore source.

------------------------------
when try to attached data, it show

++++++++++++++++++++++++++++++++++++++++++++++++++
BackupDiskFile::OpenMedia: Backup device 'D:\temp\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\BeStylish_1_Data.ndf' failed to open. Operating system error 5(Access is denied.).
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
0
Deepak ChauhanSQL Server DBACommented:
@when try to restore it from backup it show......... "You must select a restore source."
Are you able to connect to SQL server using SSMS?

Is D:\ drive or folder where file exists is compressed ? or is it write protected.

check sql server services account it should be running LocalSystem or domain account.
0
sitgAuthor Commented:
Hi,
I resolve this issue with some external help in remote session and the command is below

ALTER DATABASE Bestylish SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC Checkdb( Bestylish, REPAIR_ALLOW_DATA_LOSS)
DBCC Checkdb( Bestylish,REPAIR_REBUILD)
ALTER DATABASE Bestylish SET OFFLINE
ALTER DATABASE Bestylish SET ONLINE
ALTER DATABASE Bestylish SET MULTI_USER WITH ROLLBACK IMMEDIATE
CREATE database for attach_rebuid_log
ALTER DATABASE bestylish REBUILD LOG ON (NAME=bestylish_Log, FILENAME='D:\mssql\bestylish\BeStylish_Log.ldf')
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sitgAuthor Commented:
issue resolve with expert support
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.