How to check Sql server instance and databases up and running or not

[perugu_vada]

? Ela check chestaru ?

also management studio ise chestara or configuration manager use chestara sql server dba's to take backups ?

[chinnabhai]

Instance service run..itundo..ledo..chudu..

Back ground lo..

 

If it's in foreground..check...process is running

Ps -ef | grep process name

 

 

[Quickgun_murugan]

40 minutes ago, chinnabhai said:

Instance service run..itundo..ledo..chudu..

Back ground lo..

 

If it's in foreground..check...process is running

Ps -ef | grep process name

 

 

post not clear @chinnabhai

[k2s]

55 minutes ago, perugu_vada said:

? Ela check chestaru ?

also management studio ise chestara or configuration manager use chestara sql server dba's to take backups ?

Ardam kaledu Q? 

[mtkr]

select * from sys.databases

[khabardar]

management studio tho try cheyali.. r u able to connect to that instance. .. if you are not able to connect then open the configuration manager and check the SQL server services are running or not ...

 

ne question ki direct answer////////////Server level ithe   check the SQL server services are running or not ... 

 

DB level ithe  select * from sys.databases this query. 

[Suhaas]

Configuration manager to check if the instance/agent is running. 

Management studio for backups.