CODEWITHSUNDEEP
sqlsql-serverdatabase
user1832437
user1832437

Reputation: 11

SQL Server: Tempdb: per Instance not per Database?

The tempdb system database is created by system per Instance or per Database on SQL Server?

I believe it is created per Instance is it true?

Kindly requested to guide!

Regards,

Upvotes: 0

Views: 852

Answers (1)

SchmitzIT
SchmitzIT

Reputation: 9602

It's per instance. Every instance will have 1 tempdb, which will be recreated every time SQL Server restarts.

Upvotes: 3

Related Questions