• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 397
  • Last Modified:

SQL SERVER DB restores to Single User mode default, WHY???

We have a db that is backed up using SQL Server LITESPEED.  It's read only, and when i restore it, it defaults to single-user mode.  Why is this happening?  It's the only one doing this.

of course, i can change it back, but i don't want it to default to single user mode.
0
alenknight
Asked:
alenknight
  • 3
  • 3
1 Solution
 
chapmandewCommented:
are you sure it doesn't set it to single user mode before it backs it up?
0
 
alenknightAuthor Commented:
yes, because other DBs don't.  It's actually multiple instances of the same DB with different names.  it's a READ ONLY DB.
0
 
chapmandewCommented:
Is it the only read only db?
0
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
alenknightAuthor Commented:
no.  all of them are.
0
 
alenknightAuthor Commented:
so this is not normal behavior?  there is no default option for when a DB gets backed up to switch to single user?
0
 
chapmandewCommented:
not in sql server, but not sure what lite speed is doing in the background.  You could run profiler on the db to see what lite speed is doing when it backs it up.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now