Running SQLserver as a Role. Where are the tables and tmp disk stored on a bare metal server

[Joe_Larche]

We are currently running stand alone SQLserver as a role on a Server 2019 instance. Would like to migrate to a Hyper-V VM to make it more portable. Need to know where the tables and tmp disk are currently stored. 

[#2 · Accepted solution]

@Joe_Larche , not very clear what you mean / are looking for?

Tables = data are stored in the database files.

"Tmp disk" is a database as well.

You can use DMA = Overview of Data Migration Assistant (SQL Server) - SQL Server | Microsoft Learn

for migration to a VM/cloud/whatever.

[#3]

@olafhelper

Exactly what I needed. 

THANK YOU!