Viewing 7 posts - 1 through 7 (of 7 total)
Thanks for all comments,
The database is online again, just changing the auto_close parameter to Off.
ALTER DATABASE [DATABASENAME] SET AUTO_CLOSE OFF
Reference: http://technet.microsoft.com/en-us/library/bb402929.aspx
Database Option to OFF:
This rule checks whether the...
December 29, 2009 at 11:05 am
The state=2 AND state_desc is "RECOVERING"
December 29, 2009 at 8:16 am
the log file show me a message "SQL server has encountered 1 occurrence(s) of cachestore flush for the bounds trees cachestore (part of plan cache) due to some database maintenance...
December 29, 2009 at 8:11 am
Hi, the instruction "select * from sys.databases" work fine and I get all DB but when I try to access the DB or expanding objects it show me a message...
December 29, 2009 at 7:57 am
I'm agree with you.
So, this is my first month in the company and I'm knowing
the way they work. I will try put in order the DB Administration
as soon as possible...
December 10, 2009 at 7:34 am
thank's a lot.
That's I wanted to know. In my case I know the 'sa' password, so I just need to change it (for security) using @old='OldPassw' and I think is...
December 9, 2009 at 4:21 pm
Thank's for your comments..
That's true.. i don't need to chance nothing about services or jobs.
Just tell me somthing .. According to your experience ¿how do you change the 'sa' password?...
December 9, 2009 at 12:52 pm
Viewing 7 posts - 1 through 7 (of 7 total)