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 12»»

DB Offline Expand / Collapse
Author
Message
Posted Wednesday, November 13, 2013 12:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:55 PM
Points: 218, Visits: 556
Hi

In event log i can see 'Database option changed from Offline to On'. Whant to chekc why did the db get offline and when? Where can this informaiton be found?

Thanks and regards
Post #1513719
Posted Wednesday, November 13, 2013 1:12 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 @ 5:40 AM
Points: 42,419, Visits: 35,482
Someone ran ALTER DATABASE ... SET OFFLINE, or that command is in a job somewhere. SQL won't take a DB offline by itself, someone or some app ran the ALTER DATABASE


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 #1513722
Posted Wednesday, November 13, 2013 1:48 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:55 PM
Points: 218, Visits: 556
Where can we see who did it? when it was done?
Post #1513727
Posted Wednesday, November 13, 2013 1:54 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 @ 5:40 AM
Points: 42,419, Visits: 35,482
Should be in the default trace. Otherwise ask the other DBAs, it required DB_owner permissions or high server level permissions, so not something that everyone should be able to do.


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 #1513729
Posted Wednesday, November 13, 2013 2:09 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:55 PM
Points: 218, Visits: 556
I have all the permissions. Can you explain where i can see this information.
Also in the error log i can see the spid who has thurned the db on. But How can i find to which user this SPid had belonged to? (its this isue had occured 2 days back)
Post #1513739
Posted Wednesday, November 13, 2013 2:27 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 @ 5:40 AM
Points: 42,419, Visits: 35,482
Krishna1 (11/13/2013)
Can you explain where i can see this information.


I said in my previous post. It should be in the default trace.
Also, taking a DB offline or bringing it online requires high permissions, so ask the people who have such permissions whether they ran the command and if so, why




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 #1513744
Posted Wednesday, November 13, 2013 2:41 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:55 PM
Points: 218, Visits: 556
Hi

Ok will check with them. I could open the trace file also. I would like to check with you if SQL server maiantains the history of the SPID and user

Regards
Post #1513749
Posted Wednesday, November 13, 2013 2:47 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 @ 5:40 AM
Points: 42,419, Visits: 35,482
Krishna1 (11/13/2013)
I would like to check with you if SQL server maiantains the history of the SPID and user


It does not.



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 #1513753
Posted Wednesday, November 13, 2013 4:50 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:55 PM
Points: 218, Visits: 556
In trace file can not see entry saying DB made offline
Post #1513805
Posted Wednesday, November 13, 2013 6:01 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 @ 5:40 AM
Points: 42,419, Visits: 35,482
The default trace doesn't keep data forever. It keeps 5 files of max 20MB each. Could be the files have rolled over and the date of the alter database is no longer in the trace.


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 #1513825
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse