Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server goes into single user mode

Status
Not open for further replies.
jfield817

jfield817

Programmer
Jun 2, 2000
153
US
A SQL Server 7 database started into single user
mode automatically...(the "truncate on checkpt" option
was just checked ...i dont know if thats related)

Any ideas ?

thanks
john field
 
Sort by date Sort by votes
I do not have an idea why your database was switched to single user. I do know that it has nothing to do with 'truncate log on checkpoint'.
Try to make another database and see if it also automatically is in single user mode.
Could you be running the server in single user mode? This is done with startup options -m or -f.
good luck
 
Upvote 0 Downvote
Do you have a maintenance plan in place? Is it set to automatically repair? Repairing the database will switch it into single-user mode.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MathiasB
  • Question
Parameterised sql server query
Replies
8
Views
464
Chriss Miller
C
peac3
  • Locked
  • Question
Consolidate multiple rows into single row 1
Replies
4
Views
1K
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Group results into one row 3
2
Replies
37
Views
2K
Chris Miller
Chris Miller
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
887
SashaBuilder3
SashaBuilder3
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
791
Volvere
V

Part and Inventory Search

Sponsor

Back
Top