| Feature | LocalDB | SQL Server Express (Service) | SQLite | |---------|---------|------------------------------|--------| | Runs as service | No | Yes | No | | User isolation | Per-user | System-wide | Per-process | | Max database size | 10 GB | 10 GB | 140 TB | | Memory & CPU | Process-limited | Instance-limited | Process-limited | | Network access | Named pipes only (no TCP) | Yes | No | | Management tools | SSMS, SqlCmd | SSMS, SqlCmd | CLI only |
sqllocaldb stop MSSQLLocalDB sqllocaldb delete MSSQLLocalDB sqllocaldb create MSSQLLocalDB sql server express localdb