August 23, 2004 at 7:37 am
I have something strange on My DB
beside of it .. it is written (Single user)
i open it in my application
and if i try to open Enterprise manager .. a message appears told me that :
Error 22285: [SQl-DMO] Database 'MYDBName' is already open and can only have one user at a time
and when i right click on MyDB and choose 'properties' in options tab , there is a check on 'restrick access'
and checked 'single user'
and sao i have to uncheck 'restrick access'
I don't know why this happened .. i didn't do this and this happened to me frequently.
by the way there is no except me dealing with this Database
thanks for any one who try to help
Alamir Mohamed
Alamir_mohamed@yahoo.com
August 23, 2004 at 7:48 am
I get also this error
error 9002 : the log file for database 'MyyDB' is Full , back up the transaction log for the database
So the problem was the Log was Full because of Hard Disk is Full
So i backup Transaction Log
then Shrink it with a script ..and log goes to real Size and DB is working
Alamir Mohamed
Alamir_mohamed@yahoo.com
August 23, 2004 at 10:12 am
My guess is that the DB went to single-user mode after the log/disk was full.
There are 2 ways to correct for this if the database is in full recovery mode (or in SQL7 "trunc. log on chkpt" is not selected):
1) Create a maintenance plan to do transaction log backups.
2) Put the database into "Simple" recovery mode or select "trunc. log on chkpt".
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
August 24, 2004 at 6:14 am
where can I "trunc. log on chkpt" ?
Alamir Mohamed
Alamir_mohamed@yahoo.com
August 24, 2004 at 6:39 am
In SQL Enterprise Manager, browse the tree (yourservername, Databases, right-click youdbname, Properties, Options. That's for SQL 2000, and as I recall, it's in the same place for SQL 7.0. In SQL 2000 the picklist is labeled "Recovery Model".
August 24, 2004 at 6:52 am
My apologies, I didn't qualify the #2 option.
In SQL 7 they used "trunc. log on chkpt" and something like "unlogged bulk copy" check boxes to set up how you were going to do backups restores.
In SQL 2000 they combined and changed the options into the recovery model box.
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply