It can be for any database .....not necessarily tempdb ..

Just now ....log for one user database crossed 100 percent 😉

Pls suggest .

when i check for the contents in the errorlogfile and sqlagent.out , it shows me that windows event log service has not been started .

i try to start it manually...

;0 😉

Sql server service is up and running fine ....

Agent is only that is not coming up

I restarted the sql services and it came up without fail.

I think the prob was with the database locating the data/log files ....

The status of the database is in RECOVERY PENDING state .

Pls suggest

Its helpful to get the results of a query for n number of instances in a registered server list or as you mention in Central management servers list .

But...

@Eights - "A user without login..go db-->security-->right click users--->User's properties is showing without login..."

I followed it , but i am not able to select without login while creating a user...

Try using the script to automate when the deadlock happens ....

--== This is for SQL 2005 and higher. ==--

--== We will create a temporary table to hold the error log...

I am able to connect through SSMS now , but the prob still persists for my command prompt

use master

go

SELECT

percent_complete AS 'PctComplete',

start_time AS 'StartTime',

command AS 'Command',

b.name...

I cant go to the above mentioned path to check media device in my SQL 2008 R2 .

Please direct .

TIA 🙂

I am not able to do it even when i am trying to do it in my base machine

Wrong Link

Bro, This is not what i am looking for .

I want to reduce the initial file size to avoid mis-happenings in Future 🙂

I am able to take backup to the shared location now 🙂

I granted permission on OS level to the service account for the sql and is working fine now .