Forum Discussion
Running SQLserver as a Role. Where are the tables and tmp disk stored on a bare metal server
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.
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.
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.
