0

I am not a DBA, but SQL Developer.

Our company has a Azure VM that has a very active SQL Server 2008.

Currently, a disk drive (H:\ drive) that holds SQL data is getting full (up to 2 TB, possibly due to all log files we never trimmed).

Also, partition style for H:\ drive is MBR, so there is a limitation with this partition in the OS.

enter image description here

Our IT is trying to extend the disk up to (4 TB) using GPT.

This is IT's plan:

• Leave H: (PID 1) untouched.

• Create VM snapshot as a backup.

• Format an unused 4TB existing drive for extensibility (GPT)

As a SQL Developer, I know little bit about SQL Server Admin part, and I am curious whether there should be any type of configuration we have to do to SQL Server Mgmt Studio (SSMS) application itself or other app. in Windows that configures SSMS to make sure data carries to extension using GPT without any disruption to the data.

I am trying to make sure IT's operation goes smoothly without losing any data or performance in the future, and would like to get some feedback from the community.

This is updated content (after I got some feedback): enter image description here

enter image description here

enter image description here

10
  • 1
    "Leave H: (PID 1) untouched." and "Format an unused 4TB existing drive for extensibility (GPT)". What's your game plan to move the database to the new bigger drive?
    – J.D.
    Jan 31, 2023 at 19:04
  • 1
    Np, just wanted to make sure I didn't misunderstand. The steps at a high level usually involve updating the database file paths meta-data on the server, stopping the SQL Server service, moving the files to the new drive, and starting the SQL Server service back up. If I get a chance I'll write up an answer with details.
    – J.D.
    Jan 31, 2023 at 19:19
  • 1
    Do you know if the system databases (master, model, msdb, and tempdb) files are stored on the H: drive too? If so, do they also need to be moved to the new drive or is it ok by you guys to leave them on the old drive?
    – J.D.
    Jan 31, 2023 at 19:26
  • 1
    @J.D. That would be great. Our team is still learning this new task, so if you can refer to links or provide on the bottom as answer, that would be superb! Regards to your questions about system databases, I am not sure the best way. I guess I will follow the most standard/safer way.
    – Java
    Jan 31, 2023 at 19:26
  • 1
    Sorry I haven't had a chance to write up a formal answer yet. But regarding the locations of the system database files, you can run the following query to get that: SELECT name AS FileLogicalName, physical_name AS FileLocation FROM sys.master_files WHERE database_id <= 4
    – J.D.
    Feb 2, 2023 at 18:21

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.